Versions Compared

Version Old Version 3 New Version Current
Changes made by

Migration (Unlicensed)

Andy Heller (Deactivated)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Panel
borderStylenone

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.

Column
width20%
Hide Columns
TypeCXO-Cockpit Tips and Tricks
Audience

What is the role of the CXO-Cockpit CaptainAdministrator

DifficultyMedium
Applies to

Multi-Column Template

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 /wiki/spaces/CXO/pages/2806775914 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:

...