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:

    Icon

    You need to be in view mode in order to add variables and filters.

    Icon

    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:

    Icon

    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
    Icon

    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 .

    Icon

    Prefix variable with '@' in order to refer to variable value.

     

     

    Icon

    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.

    Icon

    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 .

    Icon

    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.

    Icon

    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
    Icon

    This feature is handy especially when creating Global Filters or drill-throughts with URL Appearance.

    Using variables in indicator names

    Icon

    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