A static variable is a string of text, such as a label or paragraph, which can be inserted into a report package doclet.
As an example, if you create a static variable for the current month called "CurrentMonth", you might enter the text, “August 2016”. When you roll over to the report for the next month, it is a simple matter to update the text in the CurrentMonth variable to “September 2016,” and the change is propagated to all instances of that variable throughout the report package.
The static variable can also be created and defined in the Oracle Enterprise Performance Reporting Cloud web interface; however, it must be inserted into the doclet using Oracle Smart View for Office.
Before you begin, ensure that you have opened a report package, and opened and checked out a doclet.
To create a static variable:
The report package panel displays Create Static Variable, where you enter the variable name and value, and an optional description:
The name must be unique across variables within the report package, and should be descriptive of the variable to make it easier to find.
The text string can be a label or paragraph, and the entire string will be displayed as entered in the report package.
In the following example, the user created a static variable with the Name of "CurrentMonth", a Description of "The current month and year for the report", and a Value of "August 2016". This variable can be inserted in multiple locations showing the date of the current month in different usages, as shown below:
This variable can be inserted in multiple locations showing the date of the current month in different usages; for example:
Insert the static variable into the text displayed in an internal Operating Expenses doclet that reads "For the month of <<CurrentMonth>>".
Insert the static variable into a paragraph in footnote of any of the doclets that reads: "During <CurrentMonth>>, ... ."
The next month, to update all instances of the Current Month date in the report package, modify the variable value to use the new month; for example, September 2016. This option ensures that the change is implemented uniformly, and no incorrect dates for the value remain.
To cancel creating the variable, click the Cancel button,