Post reply

SSAS Nested Column

  • June 19, 2012 at 1:12 pm

    #258337

    Hi All,

    I am fairly new to SSAS. I successfully built and deployed the cube. I am also able to connect from Excel or Management studio to the cube.

    The issue is with nested columns. If I drop more than one column then it automatically nests it under the first column. I am trying to achieve a tabular report using excel connecting to SSAS.

    Is it possible to achieve this ?

    Thanks,

    Suri

  • June 25, 2012 at 9:14 am

    #1505104

    Using Excel 2007.

    Drag your columns into the pivot as you need them.

    to prevent Excel from automatically nesting the columns, do the below

    Click on a column in the pivot

    Go to 'Design' tab in Excel 'ribbon' menu

    Under 'Layout', drop down the 'Report Layout' and select 'Show in Tabular form' from the 3 options.

    You can use different 'PivotTable Styles' also presented in the Design ribbon. These are pretty cool and can add some fantastic formatting to enhance your report.:-P

  • June 25, 2012 at 1:32 pm

    #1505258

    Thanks it worked.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply