locked
removing ALL members RRS feed

  • Question

  • Hi All,

    I want to write a MDX query which will display me results for all the levels except for ALL MEMBERS.

    Total 5 levels are there.

    So if I use a member from level 5 then all the members from level 1,2,3,4 should be displayed except ALL Members at Level 0.

    Thanks.


    -Nitin Pawar
    Friday, January 28, 2011 10:55 AM

Answers

  • Suppose that I have a dimension Named Date and has an attribute called Longdate

    If you use [Date].[Longdate].Members It returns the member and All member.

    If you use [Date].[Longdate].[Longdate].Members It eliminates All member.

    In your query you can use this for level 0 when you make cross join of all 5 levels.

    Friday, January 28, 2011 11:34 AM