Dynamic KPI goals

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