MDX to List Dimension Members with Properties based on the Property value

• Jimmy-516531

  Old Hand

  Points: 338

  More actions

  November 24, 2010 at 7:19 am

  #227189

  Hey Guys,

  I'm new to MDX and my the amount of hair left to pull out is becoming limited.. a little help please 🙂

  This should be simple but I can't seem to work it out.

  I need to retrieve a list of dimension members based on the value of one the dimension properties. SO:

  Member ID Property

  M01 N

  M02 333

  M03 444

  M04 N

  I need to get a list of Member IDs and the Property based on the property being <> N.

  How can I do this?

  Help is much appreciated.

  Regards,

  J

• Jimmy-516531

  Old Hand

  Points: 338

  More actions

  November 24, 2010 at 7:23 am

  #1255086

  Typically I strike gold just after I posted:

  Thanks and I hope I didn't waste anyone's time

  J

  .....................Solution..........................

  WITH

  MEMBER

  [Measures].[ACCOUNT_CODE]

  AS

  '[ACCOUNT.H1].properties("PROP")'

  SELECT

  {[Measures].[ACCOUNT_CODE]}

  ON AXIS(0),

  {FILTER (DESCENDANTS ({[ACCOUNT.H1].[LEV10]}),[ACCOUNT.H1].properties("PROP") <> "N")}

  ON AXIS(1)

  FROM

  [CUBE]