locked
Unrelated Measures RRS feed

  • Question

  • Is there a way to make unreleated measures show blank instead of the sum of the measure?

     

    I know I can do it with calculated measures, but I was hoping there was a checkbox I'm missing somewhere :-)

     

    Friday, September 30, 2011 9:57 PM

Answers

  • In the cube if you go to the Measure group->Properties there is a property called IgnoreUnrelatedDimension. Set this value to False. It will show NULL at member level but not at the ALL level.
    vinu
    • Proposed as answer by JesseO Saturday, October 1, 2011 2:21 AM
    • Marked as answer by Challen Fu Tuesday, October 4, 2011 5:27 AM
    Friday, September 30, 2011 10:25 PM

All replies

  • In the cube if you go to the Measure group->Properties there is a property called IgnoreUnrelatedDimension. Set this value to False. It will show NULL at member level but not at the ALL level.
    vinu
    • Proposed as answer by JesseO Saturday, October 1, 2011 2:21 AM
    • Marked as answer by Challen Fu Tuesday, October 4, 2011 5:27 AM
    Friday, September 30, 2011 10:25 PM
  • Thanks! Exactly what I wanted.
    Friday, September 30, 2011 10:27 PM