Discoverer Conditions

...

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.

Conditions

Restraints to filter data in a worksheet
Eliminates data you don’t want to see
When creating a report for the first time, good idea to include at least one
Can be simple or complex
Can include parameters
Can include calculated columns
No restrictions as to number you can create

However, there is a trade‐off in performance
Apply to indexed columns for best performance

Examples:

Simple Condition:

Pa_Period_Name = ‘Jun‐10’

Complex Condition:

((Commitments_To_Date IS NOT NULL ) OR (Burdened_Cost_Pa_Period IS NOT NULL ))

Effective: 08/23/2010

Revision: 1

Oracle Tutor can be licensed to modify and add to this content, documenting all of your business process documentation in the Oracle Tutor format.