Query Variables

You can use query variables in CDM to maintain unique internal references for each report.

You can also copy a report-level query variable to the object-level variables table and apply properties to it. For more information, see the CDM User Guide.

Required Permission

To manage query variables in CDM, you should have the following permission allowed:

Application Permissions > Data Management > Manage Query Variables

Add a Query Variable

If you need a query variable that does not currently exist in CDM, you can create one.

1. In CDM, do either of the following to open the Query Variables tab in the work area:
   • Click the File tab, then navigate to Administration > External Data > Query Variables.
   • Click the Home tab, then in the Navigation Pane, click Administration and double-click Query Variables under External Data.
2. Click Home > Add > Query Variable. The Add Query Variable window displays.
3. Specify a name and value for the query variable.
4. You can add a comment to provide information about the purpose and use of the query variable.
5. If you want to allow a user to override the value that you specified, select Allows Override.
6. If you do not want users who do not have the Manage Query Variables application permission to further edit the variable when they use it, select Locked.
7. Click OK.

Edit a Query Variable

You can change details of a query variable.

1. From the query variable list in the work area, right-click the variable you want to edit and select Edit, or double-click the query variable row.
2. You can change the value and comment for the query variable.
3. To change the override setting, select or clear Allows Override.
4. To change the lock setting, select or clear Locked.
5. Click OK.

Delete a Query Variable

If you no longer need a query variable, you can delete it.

You cannot delete a query variable if it is currently used by a data query or data source or if it is overridden.

Important: If you delete a query variable, you cannot undo your action. Proceed with caution.

To delete a query variable:

1. From the query variable list in the work area, select the variable you want to delete and click Delete.
2. In the confirmation window, click Yes.