Twitter Updates

    follow me on Twitter

    Friday, July 29, 2011

    PowerPivot Nuggets - Part 3 - Drill-through

    Analysis Services, PowerPivot's older and bigger brother, has had drill-through functionality for quite some time now. Basically this feature allows you to drill-through a cube and go to the underlying datasoure and fetch the detail rows.

    This feature is now coming to PowerPivot. Right click on a measure and choose "Show Details". Or simply double-click on a measure.

    Excel will open up a new sheet and fetch (by default the first 1000 rows) of the underlying table.

    You can change the number of rows to fetch in the connection properties of your PowerPivot Data Connection.

    A nice new feature that will make data analysis a lot easier.

    No comments: