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.|
The input of the variable. The following options are available:
|Fallback value||The value used by the system every time the value defined in the list type does not exist.|
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:
The name of the parent folder where the report is stored. For example: Product Analysis ()
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:
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.