共用方式為

Drilling Down in a Scorecard

  • 發行項

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.

clip_image002

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.
clip_image004

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.
clip_image006

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

Greg Bernhardt (gregbern@microsoft.com)

Comments

  • Anonymous
    January 27, 2008
    The comment has been removed

  • Anonymous
    February 14, 2008
    How would (or can) you do the same thing if your datasource is an Excel Spreadsheet?

  • Anonymous
    February 14, 2008
    Sorry about my comment above, I meant to post it on your other blog.  :)

  • Anonymous
    February 17, 2008
    The comment has been removed

  • Anonymous
    July 17, 2008
    Has anyone found an automated method for this?  Supratim.Biswas and I have the same concern for large dimensions.

  • Anonymous
    October 17, 2008
    I hope the capability to automatically add large dimensions with their hierarchies will be added to an upcoming release. Unless there is a Hotfix or Service Pack that addresses this! I'm seconding Supratim and J0EE on this request. :-) It is PAINSTAKING to have to do this for EACH level and ALL of the members of a given hierarchy. Any ideas on when this will be available? Nate

  • Anonymous
    October 17, 2008
    We are not publically disclosing information on future releases at this time but should be ready to talk more about our plans in a few months.   Thanks, Alyson

  • Anonymous
    June 12, 2009
    Many months have passed since the last commment on this blog entry. I'm wondering if you are going to continue development on the tool, and if so, will you provide a method to resolve the hierarchy issue discussed in this blog entry? Also, where can I submit other enhancement requests? Thanks, Reuben

  • Anonymous
    June 15, 2009
    Sorry for the delay, we are still not yet publically disclosing the feature set for the next version yet.  My apologies for the delay.  Additional feature suggestions can be sent to me as well.  (alysonp@microsoft.com) Thanks, Alyson