- 1 Minute to read
- Print
- DarkLight
- PDF
Overriding Substitution Variables for Report Collections and Financial Package When Running a Process Flow
- 1 Minute to read
- Print
- DarkLight
- PDF
You can edit substitution variables (either standard or dynamic) for Dynamic Reports for a Report Collection or Financial Publishing Package (FPP) when Process Flows are run for variables that are used in the header and footer, member selections, report sets, or line headers.
The substitution variables user prompt (shown below) is displayed when Process Flows are executed via Run Now.
A consolidated list of all substitution variables used in all reports across all Report Collections and FPPs mapped in the Process Flow tasks is displayed. You can override the default values before generating the Dynamic Report by clicking the variable and making the change.
When the Process Flow with Report Collection or FPP task is run, each report is run for the substitution variable values as selected in the User Prompt at run time. The updated values in the User Prompt are not saved in the system nor do they update the default values of the master substitution variable.
Additionally:
If a single variable is used in multiple reports or multiple times in a single report, it is displayed only once in the User Prompt and takes the common value;
Icons appear in the gird if the variable is used on headers, report sets, or dimensions;
If the same variable is used in the header of one report and on the report set in another report, both header and report set icons are shown;
Default values from master substitution variables are displayed in the dialog, and you can update the variable values before running the Process Flow.
When Process Flows are executed automatically via Cloud Scheduler, the global substitution variables values are run as defined in Maintenance, Reports, Cube Settings, under the Substitution Variables tab.