Excel Pivot display as SSAS cube browser RRS feed

  • Question

  • Hi Experts,

    I've created SSAS cube and in that when I am browsing it am getting each measure under each column value like below...


    Dimension1         Jan 2009                                                                    Feb 2009

                              Measure1      Measure2  Measure 3                           Measure1      Measure2  Measure 3

    1234567890     3232              4345           7565                                   4343              3222          6544

    I want the same structure while browsing the cube using excel Pivot. but in excel pivot am getting display as below...

    Rowlabel      Column label

    Dimension1   Dimension2

                         Jan 2009           Feb 2009      Jan 2009           Feb 2009   

                         3232                  4343            4345                  3222

    I've kept my Dimension1 in Row label and Dimension2 in Column label and all measures in values.

    Could you please help me in getting the display of cube browser in Excel pivot

    Thank you in advance


    Sunday, August 25, 2013 5:54 AM


  • Hi NoorBi,

    I performed a test on my environment, it seems we can get expected output format for the PivotTable report. Please see the screenshot below:

    Please refer to my design structure of PivotTable to see if this work for you.

    Best Regards,

    Elvis Long
    TechNet Community Support

    Tuesday, August 27, 2013 11:39 AM