mardi 31 août 2010 14:41
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.
Toutes les réponses
mardi 31 août 2010 22:05
Unfortuately, drillthrough is not supported in this version of PowerPivot.
- Proposé comme réponse Dan EnglishMVP dimanche 12 septembre 2010 01:01
mercredi 1 septembre 2010 13:04
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?
mercredi 1 septembre 2010 16:32
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.
samedi 4 septembre 2010 19:33
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".
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 ;)
- Proposé comme réponse JJ78 jeudi 31 mai 2012 15:33
samedi 11 septembre 2010 00:55
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.
jeudi 11 novembre 2010 12:14
Can you please explain the above briefly ..i mean where have to start.. i'm unable to do that.. please help me out.
vendredi 4 février 2011 20:34
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!
vendredi 4 février 2011 20:42
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 !
vendredi 3 février 2012 18:36
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.
lundi 6 février 2012 09:56
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
- Marqué comme réponse Challen FuModerator lundi 20 février 2012 07:10
mercredi 30 mai 2012 17:55A good workaround however the imperfect is that you have to change all filters to slicers, which might have performance concerns.
jeudi 31 mai 2012 15:38
A good workaround however the imperfect is that you have to change all filters to slicers, which might have performance concerns.
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!?)
mercredi 18 juillet 2012 01:30Nice 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?
mercredi 9 janvier 2013 20:08You 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...