Twitter Updates

    follow me on Twitter

    Thursday, July 28, 2011

    PowerPivot Nuggets - Part 2 - Hierarchies

    About two years ago I opened the following item on Microsoft Connect.

    "Dimension Hierarchies (eg. Category - SubCategory - Product) are a key element for making cube concepts easier to understand and use for a lot of business people.

    I didn't find a way to create hierarchies in the current CTP of Gemini. I hope this will make it in future CTPs and the final relase."

    Hierarchies didn't make in PowerPivot V1 but they are here now on V2.

    As highlighted in Nugget 1, hierarchies are created in the Diagram View.







    Once created you can use them in your pivot table in the row and colum areas. Another cool thing is that you can also drag a hierarchy to the vertical or horizontal slicer areas. Excel will automatically create a slicer for every level in the hierarchy.





    Cool stuff!

    No comments: