none
MDX remove all

    Question

  • Hi,

     I have a MDx  for  Named set ...

    NONEMPTY([date].[hierarchy].members,measures.count)

    output is ok but i dont want "all"

    I tried children in place of Members but didnt work as it showsonly Year( I want all the hierarchy) display as I am using this as Filter in PPS.

    Thanks,

    Red

    Tuesday, July 16, 2013 11:51 PM

Answers

  • I just got to hook this in MDX Query Window and it blows up ?

    SELECT {} ON 0,
    ([Time].[Year - Quarter - Month - Day].[Level].Members) ON 1 
    FROM [Patient Admissions]


    This one seems to be working fine

    SELECT {} ON 0,
    ([Time].[Year - Quarter - Month - Day].Members - [Time].[Year - Quarter - Month - Day].[All]) ON 1 
    FROM [Patient Admissions]
    
    Thank you !



    Rajkumar Yelugu

    • Marked as answer by Reddy07 Wednesday, July 17, 2013 4:52 PM
    Wednesday, July 17, 2013 10:52 AM

All replies

  • Hi

    Try this

    NONEMPTY({[date].[hierarchy].members - [Date].[hierarchy].[All] } ,measures.count)


    Prav

    Tuesday, July 16, 2013 11:57 PM
  • That's workable but not the best or the most legible way. An attribute hierarchy contains two levels. The [All] level and the level with all members. To exclude the all member, define the set as [Date].[Hierarchy].[Level].Members. If you do so, the [All] member will not be included in the set definition.

    NonEmpty( 
    	[Date].[Hierarchy].[Level].Members,
    	[Measures].[Count]
    )
    

    HTH, Martin


    http://martinmason.wordpress.com

    Wednesday, July 17, 2013 1:59 AM
  • I just got to hook this in MDX Query Window and it blows up ?

    SELECT {} ON 0,
    ([Time].[Year - Quarter - Month - Day].[Level].Members) ON 1 
    FROM [Patient Admissions]


    This one seems to be working fine

    SELECT {} ON 0,
    ([Time].[Year - Quarter - Month - Day].Members - [Time].[Year - Quarter - Month - Day].[All]) ON 1 
    FROM [Patient Admissions]
    
    Thank you !



    Rajkumar Yelugu

    • Marked as answer by Reddy07 Wednesday, July 17, 2013 4:52 PM
    Wednesday, July 17, 2013 10:52 AM
  • I used the

    NONEMPTY

    (DESCENDANTS(TIME.Hierarchy.level.&yr.members,measures.count)

    it worked..

    Wednesday, July 17, 2013 4:53 PM