About Variable Mapping


If a Report in Jedox Web utilizes variables, you can map the variables to Jedox database dimensions, subsets, or constant lists in the “Reports” panel. Variable mapping allows you to create several virtual instances of a report. An end user of the “Reports” panel would see several copies of a single Report (one for each value of the subset or list to which a variable is mapped). Variable mapping also allows you to create Batch PDF exports of Reports in an efficient manner. If you use reports with comboboxes, assigning variables to the combobox allows you to use the same item later, in other reports, and not only in the current spreadsheet. To map variables, you must first have them defined in your report. For more details on how to define variables, see Working with Named Ranges and Variables.

To map variables, open your report in Design View. In the Variable mapping tab, you can see all the variables that you created in the report. At this point, the variables are not mapped.

Note that you could also define a general mpping list on a folder containing several reports. This allows to define a mapping list just once, and then reuse the defined mapping on all of the reports contained in the folder, using the “Report list” option described below.

The following table describes the Variable mapping tab:

Variable The name of the variable, as defined in the report.
List type

The input of the variable. The following options are available:

  • Report list: allows you to inherit the mapping of a report’s parent folder
  • OLAP list: allows you to select elements from the dimensions databases available on a certain connection, including stored subset results
  • Constants list: allows you to define a list of static elements.
  • Constant: allows you to define a static element.
  • Jedox Subset: allows you to select elements from the Subset Editor.
Fallback value The value used by the system every time the value defined in the list type does not exist.
List/Dynamic Folder

The actual sources of the list types. See the section below for more details.

Private Shows whether the variable is private. For more information about private and global variables, see Working with Named Ranges and Variables.
Force Allows you to force override a private variable.
Expand This option controls whether the mapped variables will create the dynamic report / folder hierarchy or not. If the option is unchecked, the mapping can be used for the generation of Batch reports (or tasks), but will not influence the Reports tree.

Defining the Lyst/Dynamic Folder

This section describes the definition of List/dynamic folders for each List type:

Report list

 The name of the parent folder where the report is stored. For example: Product Analysis ()

OLAP list

You can input the path to the list, for example: localhost/Demo/Years/.

Additionally, you can select it from the OLAP list selection window that opens when you click the arrow in the drop-down list:

Constants list

You can input the elements separated by comma, for example: 2016,2017,2018.

Additionally, you can add them to the list from the Constants list selection window that opens when you click the arrow in the drop-down list:

Constant You can input the constant element that you want to use in your Batch PDF.
Jedox subset list You can only select the list from the subset editor that opens when you click the arrow in the drop-down list.

You can find more about creating a report with variables in Example: Report with Variables.