Hide columns based on the Point of View selection
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
| Hide Columns | |
|---|---|
 | |
| Type | CXO-Cockpit Tips and Tricks |
| Audience | |
| Difficulty | Medium |
| Applies to | |
If you apply this Measure to the columns of the Forecast, these columns will automatically hide when the Point of View 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 Suppress Value setting of these columns to 'SuppressNoDataAndZeros'.
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 'SuppressNoDataAndZeros' to any Variance columns.
This tip is also applicable for other common situations, such as hiding Forecast versions that are irrelevant for that specific month. If you include all Forecast versions in the columns and apply different Measures to these columns so that only one of the Forecast versions shows up for any given month, you end up with a column that only shows the comparison to the relevant Forecast version.