MDX Drill down hierarchy showing blank.

• Olalekan Adewale

  Right there with Babe

  Points: 767

  More actions

  September 6, 2018 at 9:42 am

  #415553

  Dear all,

  The attached
  

  I am looking for way to suppress an hierarchy on past period. The past is a computed measure using the actual figure and date member, this works perfectly with [All], but immediately I drilled down the hierarchy, the figure will go wrong.

  An idea came up to use SCOPE, but I don't know where to start from. Kindly assist, where the drill down on the hierarchy will not affect the measure.

  Thanks.