Versions Compared

Version Old Version 1 New Version Current
Changes made by

CXOS

Andy Heller

Saved on

Key

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

{{Infobox

bodystyle = width:20em;

title = Hide Columns

titlestyle =

headerstyle =

labelstyle = width:33%

datastyle =

image = 200px

imagestyle =

header1 =

label1 = Type

data1 = CXO-Cockpit Tips and Tricks

header2 =

label2 = Audience

data2 = CXO-Cockpit Captain

header3 =

label3 = Difficulty

data3 = Medium

label4 = Applies to

data4 = Multi-Column Template,Columns List
}}

Panel
borderStylenone
Column
width80%

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

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

What is the role of the CXO-Cockpit Administrator

DifficultyMedium
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.