Return to IS Home Page.
 
...      ...  ...

 

 

Discoverer Plus - Conditions Adding Existing Conditions to a Worksheet

Distribution

ODS Specialist

ODS Specialist-Limited

ODS Specialist-Restricted

Ownership

The ISDS System Usability Director is responsible for ensuring that this document is necessary, reflects actual practice, and supports University policy.

Discoverer Plus        
M -> File -> Edit Worksheet   
Selected Items - Conditions

Conditions Overview

A condition is a filter that you place on an item to restrict the number of rows returned from the query.  For example, you may want to see financial information for your Organization that is identified as Org 12345.  To do this, you place a condition on the output to filter all Organizations that do not begin with 12345.

Applying a condition to a table or crosstab in a predefined report, or in a report you have created, does not remove the data from the workbook.  It merely filters the data to show the precise data you want to see.  To return the rest of the data to the table or crosstab, you must turn off the condition.

Selecting Conditions

Select [Show Folders].

Scroll down in the Selected window to see which conditions apply to the report.

NOTE: Especially with the new consolidated finance report, not all conditions can be added to a worksheet as they are dependent on the folders the date filter is built on.

Pre-defined conditions are available at UVA only when accessing pre-defined reports. You can select conditions from the list of available items in the wizard. While stepping through the wizard to build your query, you can choose to include the same conditions or new conditions.

Pre-defined conditions are displayed in the Conditions window and in the Available list in the Workbook Wizard. To see a condition, follow these steps:

1.   Select the condition you want to see.

2.   Right click the name of the Condition.

3.   Select Add to the Worksheet.

If you do not apply at least one pre-defined condition when you create a query you might receive a vast amount of information that is not applicable to your question.

Conflicting Conditions:  If you select two or more conditions that conflict a warning message is displayed.