Powerview based on powerpivot (Excel 2010) in sharepoint 2010 do not show the hierarchy RRS feed

  • Question

  • Hi

    We developed a powerpivot in Excel 2010 based on SQL Server 2012 db. A three level hierarchy was created on one of the table. 

    This powerpivot was deployed on shareoint 2010 and accessed using powerivew. 


    Powerview do not display the hierarchy column created from powerpivot (powerpivot is deployed on sharepoint 2010). However it is observed that excel pivot shows the same hierarchy column.

    To check further, we created new powerview based on cube. In this powerview, it is showing the hierarchy column created in cube.

    Attached the screen shot for both the scenario:

    Powerview not showing the Hierarchy column

    Excel Pivot shows the hierarchy column

    Nikesh Shah

    Nikesh Shah

    Monday, November 3, 2014 1:03 PM