Example: Report with Variables


For this example, start by creating a new report group called “Marketing”, with “Units” as a new report hierarchy and “Regions” as a new folder. Now switch to the Variable Mapping tab and select the type “OLAP List”:

It will look like this:

Enter “Europe” as “Fallback value”; this value will be used if a mapping is not possible. Then select “Regions” in the Demo database and click on “Apply mapping”.

As a subfolder of “Regions” create the folder “Years”. For this folder, we proceed accordingly. We set the variable mapping “OLAP List” and “Years” of the database “Demo”. Furthermore, we enter “All Years” in the field “Fallback value”.

Now switch to the Report Designer. Recreate the following Jedox view in a new workbook called “Units Hardware”:

For the following steps we have to detach this view (Command: Query→Detach View) so that the PALO.ENAME functions are replaced with corresponding PALO.ESELECT  functions.

In order to work with “Regions” and “Years” as variables, we will replace “=PALO.ESELECT(…)” in cell D3 with “=@Regions”  and “=PALO.ESELECT(…)” in cell F3 with “=@Years”:

Note: variables for use in Jedox views are always defined by =@[Name].

Save and close this file. Now switch back to the Reports module and drag “Units Hardware” over to the folder “Years” and select this report. Go to the Variable Mapping tab and select for the variable “Regions” below “List Type” the entry “Report List” and below “List/Dynamic folder” the entry “Regions(/)”. Confirm these changes by clicking Apply. Then select for the variable “Years” below “List Type” the entry “Report List” and below “List/Dynamic folder” the entry Years(/Regions)”. Click Apply to confirm.

Once the variable settings have been accepted, the variables are entered by clicking on “User preview”.

Double click on the file “Units Hardware” for France and the year 2014, which will look like this:

Instead of an entire dimension (e.g. Regions above), you can also select a Jedox subset list for variable mapping. Then the resulting dynamic folders are all displayed on the same level, and they are not displayed indented depending of their hierarchical levels.

If you select the list type “OLAP List”, then the variables come directly from the list (parent folders should have no mapping). In this case, it is possible to determine whether the variables in Reports are displayed or not. This display is typically not needed if the variables are mapped for batch printing purposes. With deactivation of “Expand”, the variables are not displayed in Reports, but they are still available for batch processing. This gives you a better overview and saves a lot of computation time.

Was this post helpful?
NoYes (-1 rating, 1 votes)