Variables and Filters allows you to dynamically modify content of the report. It isfeature, that makes filtering and drilling into the report very straightforward for report viewers. Since all filter options, data and time are accessible via custom components. Report creator can apply these componentsinto the report. See screenshot below.

 

On this page:

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.

 

Editing Variables

Click on Edit button to enter Variables dialog.

BellaDati allows you to:

  • Select variable type including:
    • Number
    • Text
    • Date
    • Filter
  • Edit variable name
  • Specify description
  • Setup default value
  • Edit variable value

Select Show variables settings panel to report users if you want variables settings to be visible to report users.

 

Translating Variables

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.

Applying variables in indicator settings

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.

Applying variables in time interval settings

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.

Applying variable asrelativedate

You can also use relative dates in variables. To allow this option, go to Variables and filters, create date variable, go to advanced settings for this variable. 
This window allows you to:
  • Display default relative dates by selecting option Use relative dates
  • Allow Autosubmit after selection (every timeuser selects a value, the setting will be automatically saved)
  • Select Display mode (Radio, Select, Checklist) 
  • Set Preset values (displayed Name of the value, and Definition of the value - g.e. "now-2d" as the day before yesterday)

In the definition of the value can be used following date strings:

  • now - represents actual date
  • actualyear - represents the first day ofactual year (1.1.20XX). Forexampleactualyear selected on 21.9.2010 represents date 1.1.2010
  • actualquarter - represents the first day of actual quarter (1.1.20XX, 1.4.20XX, 1.7.20XX, 1.10.20XX). Forexampleactualquarter selected on 21.9.2010 represents date 1.7.2010
  • actualmonth - represents the first day ofactual month (1.1.20XX, 1.2.20XX, ...). Forexampleactaulmonth selected in 21.9.2010 represents date 1.9.2010
  • actualweek - representsfirst day ofactual week (Monday). Forexampleactualweek selected on 21.9.2010 represents date 20.9.2010 (Monday of this week incalendar)
  • availableFrom, availableTo - represents the first and last available date entry
  • relative and absolute enterigof date can be adjusted by operators using this syntax: date +|- n[d|w|m|q|y], where n is integer, d represents day, w represents week, m represents month q represents quartal and y represents year. We can for example define time in this way:  actualyear + 2m -4d. Today is 21.9.2010, so this value represents 1.1.2010 + 2 months - 4 days, which means date 25.2.2010.

 

 

 

Applying variables as global report filters

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.

UsingVariables in viewfilters

Formore information about Setting Filters on views - continue by Using Filters .

Variables can also be used in view filter.

  1. Createnewvariable, forexample"var".
  2. Addfilterto view.
  3. Type ${@var} and click on Custom value: ${@var} to confirm.
  4. Close the window and Save filter and report.

Using Variables in Report and View Titles

You can use variable values in reports' and views' titles. To do so:

  1. Click on Title you would like to modify
  2. Type @ followed by Variable Name. For example: 'Patient Details: @patient_name'.
  3. Click Save or hit Enter

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.

Using variables in indicator names

This function is available since BellaDati 2.9.7.

It is possible to use variable values in indicator names. To do so:

  1. Click on Indicator you would like to modify
  2. Type @ followed by Variable Name. For example: 'Value as of @date_variable'.
  3. Click Save or hit Enter

Next Steps