none
PowerPivot drillthrough or additional actions

    Question

  • Dear all,

    Is it possible to create additional actions or drillthough functionality in PowerPivot? For example I'd like users to be able to drill down on sales value by customer to see th products bought.

    I can do this in SSAS with additional actions and this option appears when you right click a PowerPivot pivot but I can't see how to creat them.

    Thanks,

    Matt

    Tuesday, August 31, 2010 2:41 PM

Answers

  • In power pivot version2 there is drill thriough functionality.

     once you create a pivot table from power pivot work book, if you double click on any cell (that cell should me a measue implicit/explicit)/ right click on a cell and then click on show details , you can achieve drill through functionality.But the data will be displayed in a seperate work sheet.

    Don't forget to mark as answer if helpful

    Monday, February 06, 2012 9:56 AM

All replies

  • Unfortuately, drillthrough is not supported in this version of PowerPivot.

    Marco


    Marco Russo
    • Proposed as answer by Dan EnglishMVP Sunday, September 12, 2010 1:01 AM
    Tuesday, August 31, 2010 10:05 PM
  • Marco,

    Thanks for your reply and assistance.

    Can you think of another way to link from the "summary" to the "detail" without adding further items to the pivot rows and columns?

    Matt

    Wednesday, September 01, 2010 1:04 PM
  • Unfortunately no - drillthrough is an important feature and I requested it since beta versions of PowerPivot, but it has not been included in feature of v1.

    Marco


    Marco Russo
    Wednesday, September 01, 2010 4:32 PM
  • for "drilldown" i use following workaround/design:

    Excel Sheet: Overview
    Here you can create a pivot-table/chart, slicers with powerpivot/olap data.
    Near the pivot-table put a hyperlink for jump to sheet "details"

    Excel Sheet: Details
    Contains a "flat" pivot-table using same data like the pivot-table/chart on sheet "Overview".
    All Slicers of sheet "overview" are also connected to the pivot-table on sheet "details".
    In Cell A1 put a hyperlink for jump to sheet "overview"
    Optional you can hide the theet "overview".

    Usage:
    Users can now analyze data with sheet "Overview" in excel or sharepoint/excel services.
    If they want to see details for the pivot-cell/measure the can drill-down/jump to sheet "details"

    A alternative workaround would be following:
    1. Create a "flat" PivotTable1 based on powerpivot data.
    2. Now you can create pivot-tables/charts based on "excel native" data in PivotTable1
    3. As the pivot-table is not based on powerpivot/olap you can now double-click a cell to drilldown with the native excel functionality

    Contraint: The data you want to analyze is to big and at least smaller then the excel limit 1Mill rows..

    Of course this are all nasty workarounds for a missing feature!! 
    This feature, and the buggy sorting of dates/month names, is at top1 position in my whishlist for next version of powerpivot  ;) 

     

    • Proposed as answer by JJ78 Thursday, May 31, 2012 3:33 PM
    Saturday, September 04, 2010 7:33 PM
  • Hi JJ78

    Sorry I am not excel expert, Please can you explain in more detail around using Alternative you suggessted above to accomplish the drill down functionality.

    Thanks!

    Saturday, September 11, 2010 12:55 AM
  • Can you please explain the above briefly ..i mean where have to start.. i'm unable to do that.. please help me out.

    Thanks

    Immadi

    Thursday, November 11, 2010 12:14 PM
  • It also looks like this version also does not support Reporting Services actions.  I get the actions in a non PP connection but they do not appear in PP - SO VERY FRUSTRATING!

    Friday, February 04, 2011 8:34 PM
  • Hi Brad,

    what do you mean with "I get the actions in a non PP connection"?
    Do you mean the excel-pivot-right-cick-contextmenu option?

    As Marco explained there's currently no support or a ui to define drilldown actions defined in the powerpivotcube! ;)

    BUT you can publish the excel/powerpivot to sharepoint excel services... and then you can connect to this powerpivot cube via SSRS where you are free to define drilldown-actions or url-actions (report builder textbox properties>actions) in your report layout !

    Cheers,

    JJ

    Friday, February 04, 2011 8:42 PM
  • I know this is a long time after the original post but can you provide any more details on what you mean by within the "Excel Details" section?

    I follow easily what you are saying in the overview section but am having a hard time understanding what you are referring to in the details.   I have created a "flat" pivottable from within PowerPivot and still cannot access the details behind it.   I get the typical PowerPivot error.

     

    Thanks,

     

    Friday, February 03, 2012 6:36 PM
  • In power pivot version2 there is drill thriough functionality.

     once you create a pivot table from power pivot work book, if you double click on any cell (that cell should me a measue implicit/explicit)/ right click on a cell and then click on show details , you can achieve drill through functionality.But the data will be displayed in a seperate work sheet.

    Don't forget to mark as answer if helpful

    Monday, February 06, 2012 9:56 AM
  • A good workaround however the imperfect is that you have to change all filters to slicers, which might have performance concerns.

    Derek

    Wednesday, May 30, 2012 5:55 PM
  • A good workaround however the imperfect is that you have to change all filters to slicers, which might have performance concerns.

    Derek

         In fact you have NOT to change all filters to slicers but you have to ADD slicers for all existent filters, so pivot-filter and slicer can co-exist for same fields ;)     Background is that only slicers have the ability to be linked to multiple pivot-tables. Regarding performance concerns..good point, not have any performance tests available but should not be to hard performance issue (as metadata for slicer is already loaded by pivot-filters!?)

    JJ

    Thursday, May 31, 2012 3:38 PM
  • Nice to see the drill through functionality.  I'm wondering if there is a way to control what displays in the new sheet created by the drill through.  The column names are ugly database table/column names.  Also, I don't want to return all the columns available.  Does anyone know if this is possible?
    • Proposed as answer by Roy JC Wednesday, January 09, 2013 8:06 PM
    • Unproposed as answer by Roy JC Wednesday, January 09, 2013 8:06 PM
    Wednesday, July 18, 2012 1:30 AM
  • You can create your reports using a perspective and you can select exactly what you want to see.

    Where is life's source code ? I want to fix some bugs...

    Wednesday, January 09, 2013 8:08 PM