Global Report Object Variables

You can use global report object variables to reference data across different reports in CDM.

The variable can be applied so that data is updated dynamically in value. Similar to uniquely named report object variables, a global report object variable is uniquely named and the prefix determines if it is a source or destination value.

Important: Creating source variables that reference destination variables causes refresh issues, which results in unexpected values. For more information, see the CDM Administration Guide.

The following table lists the global report object variables that you can use.

Use a Global Object Variable to Create Named Ranges in Multiple Reports

You can use named ranges in Excel objects in multiple reports in CDM. When you use source and destination global object variables, named ranges can be created in the worksheet of an Excel object and copied to a worksheet in another Excel object, or a Word or PowerPoint object in a different report. You can also choose to include or exclude formatting. The ability to use named ranges in this way is useful when you have a range of information that would normally require a separate variable for each cell value in the Excel object.

To use a global object variable to create named ranges in multiple reports:

1. Open the report that you want to work with.
2. Open and check out the Excel object in which you want to use a named range.
3. Click the Section View Mode icon in the status bar.
4. In the data worksheet, select the cell range that you want to define as a named range. The data worksheet is originally named Sheet1, but you can rename it if necessary.
5. Click Formulas, then Define Name. The New Name window opens.
6. Type the name of the range in the Name field, for example, AssetsRange, and click OK.
7. In the same data worksheet where you added the named range, create a global source dynamic object variable (##GSD) that tags the range. Set up the global source dynamic object variable in two columns:
   1. In the first column, enter the ##GSD variable as the identifier.
   2. In the second column, enter the name you used for the range you created, for example, AssetsRange.

   Important: Ensure that the variable name is outside of the display range, that is, not contained inside the ##RS and ##RE variables.

8. Save your changes in the source Excel object.
9. Click the Default View Mode icon in the status bar.
10. Save your changes to the report and check in the source Excel report object.

You can now use the global source named range variable to import the information in that range into a report object in a different report.

Use a Global Object Variable to Create a Data Reference in an Excel Object

You can use a global object variable to reference data values in an Excel object in CDM.

1. Open the report that you want to work with.
2. Open and check out the Excel object in which you want to use a named range.
3. Click the Section View Mode icon in the status bar.
4. In the Excel object, enter the parameters to set up a global source object variable (##GSD). Set up the source variable in three columns:
   1. In the first column, enter the ##GSD variable as the identifier.
   2. In the second column, enter the unique variable name for reference, for example, CashCrtYer.
   3. In the third column, enter the value for the variable, for example, 1,066,510.

   Important: Ensure that the variable name is outside of the display range, that is, not contained inside the ##RS and ##RE variables.

5. Save your changes in the source Excel object.
6. Click the Default View Mode icon in the status bar.
7. Save your changes to the report and check in the source Excel report object.

You can now use the source object variable to import the value you applied to the variable into a report object in a different report.