2

I have a dimension hierarchy that is related to multiple fact tables with different granularities. In the case of one fact table, it relates to the middle level of a three level hierarchy.

When you drill down that dimension, I would prefer to have values at that granularity and nothing if you drill down further. The default behaviour seems to be just duplicating the parent total for each of the leaf members.

I thought there was a property to control this but for the life of me I can't find it now.

Improve this question
1
  • I think you are thinking of HidememberIF, but that really only works on Parent-child hierarchies rather than any hierarchy.
    – mmarie
    Commented Jul 24, 2013 at 22:13

1 Answer 1

Reset to default
0

In the cube-designer there is a tab "dimension usage" where you can set IgnoreUnrelatedDimensions for each measure group. When you set IgnoreUnrelatedDimensions to False for the measure group with the values you meant, the result should show null for levels below the granularity level.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.