Introduction

In some cases it is useful to have certain meaningless cells hidden.

For example, if your company does not want to show to the YTD values for certain accounts.

Solution

The solution is to introduce a calculated member of the measure dimension. This measure checks if a certain dimension value is used and then returns null (empty).

Read more about creating calculated members in the Calculated Members Article

Example MDX statement

In this example, we would use the MEA (measure) dimension to create a custom calculation to apply the logic for hiding the row values that combine with a YTD column:

CREATE MEMBER CURRENTCUBE.MEA.MEA.Null_WhenYTD

If you apply this measure to the rows of those accounts that do not need values for YTD, these row values will automatically empty for the YTD columns.