Post reply

MDX for displaying two Hierarchies on one axis

  • March 1, 2012 at 11:45 am

    #269339

    I have tried every possible way to accomplish this but no luck so far.

    All I want to do is display "Sales Amount" on ROWS and two attributes from different hierarchies. Like "Marital Status" and "Gender" from Customer dimension. It should look like:

    MALE

    FEMALE

    MARRIED

    SINGLE

    I truly don't want a crossjoin like this:

    MALE/MARRIED

    FEMALE/MARRIED

    MALE/SINGLE

    FEMALE/SINGLE

    I hope there is a way to do this very simple task in MDX.

  • March 1, 2012 at 1:44 pm

    #1453870

    Not saying its simple, but I think the hierarchesize function is what you need to use.

    Steve.

  • March 1, 2012 at 1:45 pm

    #1453871

    On rereading what you want, that actually may not be right.

    Steve.

  • March 2, 2012 at 3:29 am

    #1454081

    Steve,

    Could you please elaborate, how can I fix this. I just need to display the attributes on one axis, which is a common query in non-dimensional world.

    Is there any other way of accomplishing this? I am willing to alter my cube design!

    BTW, I am using SQL 2008R2 with PerformancePoint Services.

    Thanks!

  • March 4, 2012 at 12:07 am

    #1454524

    I think Chris Webb explains the issue, and potential work arounds, better than I could. It's here[/url].

    Steve.

Viewing 5 posts - 1 through 4 (of 4 total)

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