The Add-ons pane
- Derrich Schleich
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.
Calculation condition
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Ā trueĀ as 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Ā true, at least one defined default selection is required in a single select. Button actions are currently not supported in connection with this function. A implementation will take place in one of the next versions.
Dimension calculation
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.