Variables
When data is in a report in CDM, use variables to reference the data wherever it appears in other parts of the report.
Variables are used to simplify the process of periodically updating the recurrent information that is often found in a report, or multiple reports. Instead of entering this information throughout multiple reports, and then having to update it repeatedly, you can use a variable to represent the information.
Wherever a value is displayed in a report, you can define and substitute a variable in place of it. When the report is generated, the value is substituted in place of the variable. When the value changes, you can update the variable with the new value in one place and the change is then propagated throughout all of the reports.
For example, you have a time period "For the year ended 2009" referenced in multiple places in your report. By using ##D<fsyear> as a variable ("For the year ended ##D<fsyear>") you can change those multiple time period references to "For the year ended 2010" by applying the value 2010 once to the variable ##D<fsyear>.
Variable Types
You can use different types of variables in your report in CDM to reference different types of data, build a table of contents, or specify the order of attached notes.
You can use variables with the following items:
-
Report objects
To reference information in report objects, for example, between Excel objects and Word objects. -
Global objects
To reference information in report objects across different reports. -
Queries
To reference information from the data source, for example, time periods. These variables are configured by the administrator. See Query Variables for more information.
See the following articles for more: