You need to be in view mode in order to add variables and filters. |
Only report author or report editor can create report variables and set their default values. Every other user that has access to the report, can only change report variable values. |
Select Variables and Filters from the report toolbox list in the upper right corner to open Variables panel.
Variables and Filters dialog allows you to:
Variables are set up on report level and work only within this space. |
Click on Edit button to enter Variables dialog.
BellaDati allows you to:
Select Show variables settings panel to report users if you want variables settings to be visible to report users. |
It is possible to translate both the name of the variable and the preset values. After clicking on the name or the value, users can select the language and add the translation.
You can leverage variables in indicators formulas.
In such dynamic defintion, the Views including the Indicator will be reculated after every modification done to variable in right Variables panel.
For more information about Displaying Indicators - continue by Displaying Indicators .
Prefix variable with '@' in order to refer to variable value. |
Report Variables could also serve as a basic planning and forecasting tool. Analyst can setup formulas for various versions or time intervals and then change variables values in order to observeimpact of such changes. |
You can leverage variables in time interval settings. Variable has to haveproperdate format in order to be able to be used as date interval.
Select Custom interval to apply variables. |
In such dynamicdefinition, the Views including the Time interval will be recalculated after every modification done to variable in right Variables panel.
For more information about Setting Date Interval - continue by Setting Date Interval .
Prefix variable with '@' in order to refer to variable value. |
In the definition of the value can be used following date strings:
You can leverage variables also as global filters. When Filter variable is set up to drill-down path, all Views including this Drill-down will be filteredaccording the definition.
Click on Filter values in Variable panel to change them. |
In such dynamic defintion, the Views including the filtered Drill-down will be refreshed after every modification done to variable in right Variables panel.
Formore information about Setting Filters on views - continue by Using Filters .
Variables can also be used in view filter.
You can use variable values in reports' and views' titles. To do so:
This feature is handy especially when creating Global Filters or drill-throughts with URL Appearance. |
Value of an additional filter can be also displayed the same way. In most cases, it is necessary to change the code of the filter.
When the value of the variable or filter is not set, nothing will be displayed in the title.
This function is available since BellaDati 2.9.7. |
It is possible to use variable values in indicator names. To do so: