About Variable Mapping

Variable mapping allows you to export batch PDFs 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.

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 map a report with a variable to a parent folder in reports.
  • OLAP list: allows you to select values from the databases available on a certain connection.
  • 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 If enabled, this option creates the same report but preset for each situation you have selected for the Batch PDF.

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.