Drilldown with Excel 07 and SSAS 2005

  • In my cube I have a degenerate dimension for one of my measure groups which I use for drillthrough details. I created and drillthrough action in the cube and can see these detail attributes in the VSS cube browser.

    What I would like is to have these detail attributes shown when drilling down in Excel 2007. Many of my users are using this as their client application. I have the degenerate dimension as invisible to reduce clutter but would like the details to show up when say a particular amount is double-clicked and drills down to the entry level which will automatically include these detail attributes from the degenerate dimension for example.

    Any ideas?

    TIA!

  • D'oh! What I was looking for was under Additional Actions when right-clicking the measure I wanted to drill through for. I could then select the appropriate action in this menu.

    Anyone, know if there's a way to change the default drillthrough to use an Additional Action instead?

    TIA

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply