Adding different KPI's to Time Hierarchy

Question

Hi,

I've a 'Time.by week' Hierarchy as  - Year->week->Date .

I also have Sales budgets given to me for them.

let's assume the Sales budgets are as follows.

Yearly       Weekly       Daily

500000      9615      1373

I need to define the "Goal", "Status" and "Trend" KPI's and it should work across the levels of my "Time.by week" hierarchy.

I've built a simple KPI involving just the "Year" and it worked but I'm having difficulty when it involves a hierarchy like this one.

Any help would be appreciated.

Answer 1

Hi Devangparikh26,

A KPI is associated with a measure group and is made up of a set of calculations, the calculations are a combination of calculated members and Multidimensional Expressions (MDX) statements, I suggest you add these KPIs for Time Hierarchy, please refer to the link about adding a KPI to an SQL Server Analysis Services Cube: http://www.simple-talk.com/sql/reporting-services/adding-a-kpi-to-an-sql-server-analysis-services-cube/

Thanks,
Eileen

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.