Post reply

Please help in changing DRILLTHROUGH query when pivoting in Excel

  • May 30, 2008 at 12:41 pm

    #187323

    Where and how do I change the default drillthrough action so a few additional fields how up when one clicks on "Show Details" in Excel pivot.

    The default query:

    DRILLTHROUGH MAXROWS 1000 SELECT FROM [IS] WHERE ([Company].[Company Master].&[OFCU],[Measures].[AMT],[GL Account Master].[Account Category].&[Sales Revenue],[Master Date].[Cal Year Number].&[2008],[Master Date].[Cal Month Number].&[5])

    Need to add:

    [journal entry].[dscriptn]

    attribute hierarchy: dscriptn

    Thanks!

  • May 30, 2008 at 1:18 pm

    #822526

    It is a drillthrough action in the actions of your cube.

  • May 30, 2008 at 1:23 pm

    #822528

    Michael Earl (5/30/2008)

    It is a drillthrough action in the actions of your cube.

    Thanks a lot for your reply. No, that's the MDX query generated when I click "Show Details" option in Excel pivot. I would like either change the default query or create a drillthrough action with the inclusion of the dscriptn field.

  • May 30, 2008 at 1:38 pm

    #822536

    Yes, what I am saying is you have to either create or change (if one is already configured) the drillthrough action for the cube. Whatever drillthrough has it's default property set to true for the measure group will be used by the "Show Details" in Excel 2007.

  • June 3, 2008 at 11:18 am

    #823768

    Thanks a lot! That is exactly what I needed

Viewing 5 posts - 1 through 4 (of 4 total)

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