Page Comparison

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

Panel
borderStyle none
Column width 80% 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 Forecast until the month of April has reached (typically because the information in the forecast Forecast is not relevant until that month), we recommend to apply custom calculations applying Cube Calculations to hide these columns. In this example, we would use the MEA (measure) dimension  Dimension to create a custom calculation 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 Column width 20% Hide Columns Type CXO-Cockpit Tips and Tricks Audience What is the role of the CXO-Cockpit CaptainAdministrator Difficulty Medium Applies to Multi-Column Template, Columns List

If you apply this measure Measure to the columns of the forecastForecast, these columns will automatically hide when the point Point of view Wiew is set to Jan, Feb or Mar (be aware that dependent on your configuration of your Hyperion system, you will have to use 'Jan' or 'January' etc)

In order to complete this functionality, you have to put the suppression Suppress Value setting of these columns to 'SuppressNodataandZerosSuppressNoDataAndZeros'.

It is important to know that all variances referring to this column, also disappear, because the VAR function result for variances referring to this NULL column also returns NULL. Please be aware that you also have to apply 'SuppressNodataandZerosSuppressNoDataAndZeros' to the Var any Variance columns.

This tip is also applicable for other common situations, such as hiding forecast Forecast versions that are irrelevant for that specific month. If you include all forecast Forecast versions in the columns and apply different measures Measures to these columns so that only one of the forecast Forecast versions shows up for any given month, you end up with a column that only shows the comparison to the relevant forecast Forecast version.