Dynamic KPI goals

Al at 14h12
31
Jan
2011
Dynamic KPI goals

Hi All,

We have a fact table where we collect some details (e.g. A, B, C, D ...) and on our reports we show KPIs based on these details. Let say KPI_1 is based on A and B, KPI_2 is based on A and D and so on. We have some dimensions like Departments, Teams, Users, ...

Now on our reports we have to show Goals. We have four types of goals: Daily, Weekly, Monthly, Yearly. The Goals are per KPI. Each Department, Team and User has Goals. The

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
Dynamic dimensions
What is the best way to handle dimensions that change depending on user parameters? For example, lets say you want "Months Since Inception" to be a dimension, because you want to bucket by it (i.e. 0 to 50 Months, 51 to 100 Months, etc.) but
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
Modeling goals which may slowly change over time
I did a quick search on goal modeling and didn't seem to find an existing scenario that matched the one I am posting about. I have a DW modeled against data from a time-charging application within an IT department (ie everyone must record time spent on
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
Unable to identify the dynamic object
Hi, could u please help me out to identify a check box which is dynamic. while recording it ,getting the id like this://table[@id='ID_MXTABLE_1333915313']/tbody/tr[7]/td[1]/input which changes each time while run the script.i tried with
Forums from same category
See also
more_less
Informations

0 Replies For the topic :
"Dynamic KPI goals"

This topic has been viewed 777 times.

Last message :
31/01/2011 at 14h12 by "Al"