Dynamic KPI goals

View previous topic View next topic Go down

Dynamic KPI goals

Post  Al on 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?



Posts : 1
Join date : 2011-01-31

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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