Overriding Substitution Variables for Report Collections and Financial Package When Running a Process Flow
- 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
Article summary
Did you find this summary helpful?
Thank you for your feedback
When process flows for Report Collections or Financial Publishing Packages (FPP) are run, you can edit substitution variables for dynamic reports with substitution variables in the header, footer, member selections, report sets, or line headers.
The substitution variables user prompt 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. Users can override the values before generating the report. To do so, click the Browse (arrow icon) option. Choose the desired value from the list, and click OK.
Notes:
- 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 substitution variable.
- If a single substitution 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 grid if the variable is used on headers, footers, 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 substitution variables are displayed in the dialog, and you can update the 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 Cube Settings, under the Substitution Variables tab.
Was this article helpful?