You may notice that when you add dimension data from a cube into a scorecard, that the scorecard does not keep the cube's hierarchy (doesn't allow you to drill down) by default.

At this time, you have to add the hierarchy information manually to the scorecard.


To work around this, there are a couple things you need to do:

1. After you add all the members to the scorecard, you have to manually recreate the hierarchy, by choosing "Decrease Level" from the ribbon.

2. Also, make sure your KPI is set to "Source Data" for its calculation type. Otherwise the top value (Sales Amt) will not show up.

3. When you are done, click "Update" to load the data from Analysis Services.

Greg Bernhardt (