Report Object Query Variables

A report object query variable is a variable that is used to filter data source queries for a particular report object. You can inherit object-level query variables from the report-level variables and further customize their properties. After the value of a variable has been overridden at the report level, it can be further overridden to filter the result set for the report object.

Create a Report Object Query Variable

You can create a report object query variable for Excel objects in CDM.

1. Open the report that you want to work with.
2. Open the Excel object for which you want to create a report object query variable.
3. Click the Data tab on the ribbon, then click Report Object-Level Variables. The Manage Report Object Query Variable window appears.
4. Select a report query variable in the left pane and click the arrow or drag the variable into the right pane. The Edit window appears for you to edit the variable according to your report object requirement.
5. Edit the value and comment of the variable.
6. Click OK to create the variable.

Note: If you do not have the Manage Query Variables application permission, when you add a query variable that is locked to a report object, CDM adds it directly without displaying the Edit window.

Edit a Report Object Query Variable

1. Open the report that you want to work with.
2. Open the Excel object for which you want to edit a report object query variable.
3. Click the Data tab on the ribbon, then click Report Object-Level Variables.
4. In the Manage Report Object Query Variable window, double-click a report object query variable in the right pane.
5. Modify the report object query variable contents and then click OK to save your changes.

Note: You cannot edit a locked query variable if you do not have the Manage Query Variables application permission.

Delete a Report Object Query Variable

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

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

To delete a report object query variable:

1. Open the report that you want to work with.
2. Open the Excel object for which you want to delete a report object query variable.
3. Click the Data tab on the ribbon, then click Report Object-Level Variables.
4. In the Manage Report Object Query Variable window, select a report object query variable in the right pane and click the arrow or drag the variable into the left pane.
5. Click OK to delete the report object query variable.