Skip to main content
Database Administrators

Return to Question

Added SQL-SERVER tag.
Link
StanleyJohns
StanleyJohns
  • 6k
  • 2
  • 24
  • 44
typo in title
Source Link
Mark Storey-Smith
Mark Storey-Smith
  • 31.9k
  • 9
  • 90
  • 125

How to remove leaf memebermember values?

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 behaviorbehaviour 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.

How to remove leaf memeber values?

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 behavior 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.

How to remove leaf member values?

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.

Source Link
Jeff Sacksteder
Jeff Sacksteder
  • 1.3k
  • 2
  • 19
  • 30

How to remove leaf memeber values?

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 behavior 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.