KPI Goals and Percentages as Dimensions or Store as Facts?

Scoop at 22h05
31
Mar
2009
KPI Goals and Percentages as Dimensions or Store as Facts?

We are using PPS Monitoring for our Dashboards and we are creating our KPIs within PPS and SSAS. Our client would like to create a dimension with these KPI goals and percentages for each goal per department and measures or add to the fact table.

Now please do not judge us by these topics sometimes but we are at a client site that is different is the word we will use.

We are looking for input from

Read more
Reply
About
This topic belongs to the forum

  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1858
  • Numbers of messages : 8714
  • Numbers of users : 3801
  • Numbers of points : 1672
Similar topics
Sales facts vs sales goals & calls
I did a quick search of the forums and did not see this, but it seems a rather common scenario so I apologize if I am being redundant. I have a primary sales fact table that lists sales as line items from an order, pretty common arrangement. There are
Dimensions Directly Tied to Facts vs. Snowflaking
Hi all, Thanks in advance for your input on this. We are in the midst of a building out a portion of our data warehouse. The example here has to do with insurance data. Hopefully the discussion can be abstracted to a more generic modeling level. We
Multiple facts in a fact table
One proposed model for our business (wholesale/retail) sales fact is to have every register ring in one fact. This causes refunds, voids, coupons and other 'facts' to be stored in a single fact entity. There is a column type dimension that then tells us
Conformance of Dimension for facts aggregated at different levels
I am a newbie to Data Modeling. I am modeling a warehouse for Global reporting solution for a business operating in 3 countries. 2 business processes involved are "Sales" and "shipment Expenses" The input is sumarized excel files
Facts or Dimension Attributes?
My company is currently building a data warehouse and I have a design issue that I am not sure how to address. In general, our business is selling an asset, such as the stock of a corporation, with a certain number of shares and a value. The value of th
Forums from same category
See also
more_less
Informations

12 Replies For the topic :
"KPI Goals and Percentages as Dimensions or Store as Facts?"

This topic has been viewed 5112 times.

Last message :
31/03/2009 at 22h05 by "Scoop"