The Reference Variables Window

The Reference Variables window is an area of the interface in CDM that you can use to select reference variables that you want to insert into a report object. It is docked by default when first opened in a session, however, you can undock it and position or dock it elsewhere.

Subsequent openings place the window where it was last positioned.

With a report object checked out, you can click Insert Variables in the Report Object tab on the ribbon to open the Reference Variables window. If you click Insert Variables directly, all reference variables in CDM are displayed. If you use the drop-down menu on the Insert Variables button, different variables are displayed depending on the option selected.

Option	Variable Type	Description
Source-Destination	Source-Destination	A source-destination reference variable is displayed if a destination variable (for example, `##D<currentyear>`) is paired with a source variable (for example, `##S<currentyear>`). Displayed with the icon is the name of the variable and the report object and report name where the source variable is defined. If you hover over the icon, other information like comments and location (address) in the report object are displayed.
Source-Destination	Global Source-Destination	A global source-destination reference variable is displayed if a global destination variable (for example, `##GD<currentyear>`) is paired with a global source variable (for example, `##GSD<currentyear>`). Displayed with the icon is the name of the variable and the report object and report name where the global source variable is defined. If you hover over the icon, other information like comments and location (address) in the report object are displayed.
Named Range	Named Range	A named range reference variable is displayed if a named range destination variable (for example, `##D<currentassets>`) is paired with a source named range variable (for example, `##S<currentassets>`). Displayed with the icon is the name of the variable and the report object and report name where the source variable is defined. If you hover over the icon, other information like comments and location (address) in the report object are displayed.
Named Range	Global Named Range	A global named range reference variable is displayed if a global named range destination variable (for example, `##GD<currentassets>`) is paired with a global source named range variable (for example, `##GSD<currentassets>`). Displayed with the icon is the name of the variable and the report object and report name where the global source variable is defined. If you hover over the icon, other information like comments and location (address) in the report object are displayed.
Image Range	Image Range	An image range reference variable is displayed if a destination image range variable (`##IRS`) is paired with a source image range variable (`##IRE`). Displayed with the icon is the name of the variable and the report object and report name where the source variable is defined. If you hover over the icon, other information like comments and location (address) in the report object are displayed.
Chart	Chart	A chart variable is displayed if a chart is defined in an Excel report object. Displayed with the icon is the name of the variable and the report object and report name where the chart variable is defined. If you hover over the icon, other information like location (address) in the report object is displayed.

You can use the drop-down menu to select the following options:

Float
Allows you to move and position the window wherever you choose.
Dock
Keeps the window docked in the interface.
Dock as Document
This option is unavailable.
Auto Hide
Collapses the window to a sidebar that, when clicked on, expands the window.
Close
Closes the window.

The following buttons and menus can be used to sort what is displayed:

Refresh
Refreshes the display in the window to update any changes to the list of reference variables that are shown.
Type
- All - Displays all variables.
- Source-Destination - Filters out all variables except for source-destination variables.
- Named Range - Filters out all variables except for named range variables.
- Image Range - Filters out all variables except for image range variables.
Group
- All - Displays all variables of the type selected using the Type filter.
- Variables from this report only - Displays variables from the current report that are of the type selected using the Type filter.
- Global variables only - Displays only global variables that are the type selected using the Type filter.

The Reference Variables Window

Was this article helpful?