In the Data handling section of the Add-ons pane there are two options to control calculation and rendering of either menubar itself or other charts/extensions that support calculation conditions.
Use the Calculation condition input box to define a Sense variable that is checked to be
true before the actual rendering (‘calculation’) takes place. It’s also possible to use any function or expression here. The Displayed message is the message to be shown unless the condition is
true and can be customized.
Calculation condition variable
The Calculation condition variable is the opposite of the Calculation condition: It is do define a variable that is set to
trueas soon as menubar initialized all the default selections you may have set in Single Selects and to be used by other extensions supporting this Data handling feature.
To set the calculation condition variable automatically to
The Dimension calculation switch toggles the calculation for dimensions used in menubar.
The Calculation is disabled by default, but in this mode it is not possible to use the same dimension multiple times.
If you have to use multiple dimensions or if you have a drilldown dimension, which contains some dimensions, which are already in the dimension list, you have to enable the calculation. In this case you could have some performance drawbacks.
Figure 49. The calculation condition properties in the Data handling section.