none
How to give different Dimensions in single set?

    Question

  • Hi ,

         I am migrating  cognos power play reports into ssrs.Already i migrated cognos cube in to ssas cube.Now the problem is in cognos report , it is having attribute from different dimensions in single column.how to achieve this in mdx query or ssrs.

    Please let me know whether it is possible in SSAS or SSRS.

    For example 

    Dimension1

    dim1attribute1

    dim1attribute2

    Dimension2

    dim2attribute1

    dim2attribute2

    I want result like below

    Result

    dim1attribute1

    dim2attribute2

    dim2attribute2

    Thanks and Regards,

     Bharath T


    Bharath T

    Wednesday, August 21, 2013 9:40 AM

All replies