Dimensions in BSM
Hi
We are building a scorecard to report the sales. We need the rows to display the time, ie., by year, quarter and month. And the columns to display the autaul sales and its target values for a particular time dimension.My datasource is SSAS cubes. Is there a way by which I get the Actual and the target value for a year and by drilling it will I get the values for a quarter for a particular year, and by drilling through the particular quarter, will I get the values for the month of that particular year and quarter.I get all the values in the format that I wanted in my cube.
Can I achieve the same using Business scorecard.
I have created 3 KPI's. One for year, one for Quarter and another for Month. After adding them to my scorecard and editing them, when I publish it to share point I get the correct values for the actuals and targets for a particular year, but for a quarter, the aggregation is done for all the years, ie., for 1st quarter it aggregates for all the years and similarly for te oter 3 quarters..Similarly for month, it aggregates the 1st month value for all the years and so on.. And moreover I don’t get a drill through..
Can you suggest me how to solve my problem
Jyo
