Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Click-through? Expand / Collapse
Author
Message
Posted Wednesday, November 16, 2011 3:46 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, March 18, 2014 5:49 AM
Points: 505, Visits: 579
Normal excel pivot tables allow the user to double-click a datum to extract the underlying data into a new worksheet. Is this available in Powerpivot at all?
Post #1206520
Posted Wednesday, November 16, 2011 4:05 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 9:35 AM
Points: 12,206, Visits: 9,169
The underlying data is in the PowerPivot model. You can access this by clicking on the PowerPivot Window button.

If you just want to look at the data, that should be sufficient.
If you want to export the data, you can use a regular PivotTable to connect to the datasource and do the export.

(I do not known if there is a feature in PowerPivot that is exactly the same as in a regular Pivot, but I don't have PowerPivot on this machine, so I can't check it now).




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1206528
Posted Wednesday, November 16, 2011 4:08 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 9:35 AM
Points: 12,206, Visits: 9,169
Did a bit of research, and I found this:

http://social.msdn.microsoft.com/Forums/vi-VN/sqlkjpowerpointforsharepoint/thread/c19a0d0e-a131-4b6b-8e9a-63cbf4d394bd

There is no drill-through, but with a bit of a workaround using regular PivotTables you can achieve somewhat the same result.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1206529
Posted Wednesday, November 16, 2011 4:11 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, March 18, 2014 5:49 AM
Points: 505, Visits: 579
That workaround will be fine - thanks a lot for the help. I figured drill-through isn't available as the volume of data returned could exceed the max row count in Excel.
Post #1206531
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse