Page Comparison

In some cases it is useful to have columns hidden based on the Point of View selection.

For example, if your company does not want to compare to the forecast until the month of April has reached (typically because the information in the forecast is not relevant until that month), we recommend to apply custom calculations to hide these columns.

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

WHEN
[PER].[PER].CurrentMember.Name = 'Jan' or
[PER].[PER].CurrentMember.Name = 'Feb' or
[PER].[PER].CurrentMember.Name = 'Mar'
THEN
NULL
ELSE
[MEA].[MEA].None]
END