Friday, September 14, 2012 8:06 PM
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.
Wednesday, September 19, 2012 12:42 PMModerator
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/
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.
- Marked As Answer by Eileen ZhaoMicrosoft Contingent Staff, Moderator Tuesday, September 25, 2012 8:03 AM