Remove a level from the Parent-child Hierarchy dimension doesn't work.

• sana786

  Newbie

  Points: 5

  More actions

  April 29, 2014 at 4:49 am

  #285006

  HI,

  I am trying to remove a member from the Parent-child Hierarchy dimension. My Hierarchy has 5 Levels and i am trying to remove the desired levels/members from the Dimension using the below query. The query still retrieves all the levels and does not remove the members. If i need to remove level1 , i need all the members in level1 also removed. I can do this individually on each level. But, i need this from the [All] set of the dimension hierarchy.

  In Below query, level1 has all the regions say - NY,DC,MO,IL .... and each of these regions have a list of Products which fall under level2 and each prouct is inturn has a list of buyers which fall under level 3 and so on upto level5.

  I need to remove one level member from level1 and also few products from level2. SO from my output count, my level1 should disappear and level2 should have only count of the members and exclude the count of the members removed.

  SELECT {[Measures].[Visits]} on columns

  , subset (NONEMPTY( (NONEMPTY([Account Hierarchy].[Product Hierarchy].[Level 01],[Measures].[Visits])),{[Measures].[Visits]}), 0,5000) on rows

  FROM ( select - descendants ( {[Account Hierarchy].[Product Hierarchy].&[1],[Account Hierarchy].[Product Hierarchy].&[13]

  }, , LEAVES)on columns from [MYCUBE] )

  Any help on this would be appreciated.

  Thanks

  Sheeba.