Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.
Kimball Forum

Discussion Group for the Dimensional Data Warehouse and Business Intelligence Community


Dynamic KPI goals

Kimball Forum :: Topics :: Dimensional Modeling and Data Architecture

Go down

Dynamic KPI goals Empty Dynamic KPI goals

Post  Al Mon Jan 31, 2011 9:12 am

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 Goals are editable through the user interface and we keep them into the relational database. The goals are not directly linked to A, B, C ... D but they are linked to the KPIs.

The question is how can we add these Goals to our cube?


Thanks,
Al

Al

Posts : 1
Join date : 2011-01-31

Back to top Go down

Back to top

- Similar topics

Kimball Forum :: Topics :: Dimensional Modeling and Data Architecture

 
Permissions in this forum:
You cannot reply to topics in this forum