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 (typically because the information in the Forecast is not relevant until that month), we recommend applying Cube Calculations to hide these columns. In this example, we would use the MEA (measure) Dimension to create a Cube 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 | 
