Oracle9i Discoverer Administrator Administration Guide Version 9.0.2 Part Number A90881-02 |
|
Use this dialog to create a new condition, or edit a condition in the business area.
This dialog is also displayed as:
For more information, see:
"What are the different types of condition?"
"How to create simple conditions"
"How to create advanced conditions"
Simple conditions typically contain one filter criterion. For example:
Use this field to enter a name for the new condition.
Click this check box if you want Discoverer to create a name for you.
Use this field to enter additional information about the condition. This description is displayed when you select this condition in the work area, and in Discoverer Plus. Make your description useful to both you and your users.
This field displays the name for folder that will store the condition. This is the location you selected when you chose Insert | Condition.
Use this drop down list to choose the condition type:
Use this box to specify the filter criterion that you want to use.
Use this drop down list to choose what item you want to filter the data on. For example, choose Year here if you want to display data for a particular year.
Use this drop down list to choose how to match data against the item. For example, choose the '>' symbol (greater than) here to filter data where the item value is greater than a particular number.
Use this box to define what data you want to match against. For example, enter 2001 here to look only at data for the year 2001. If you created a list of values for the item, these items appear in the drop down list.
You can also click the drop down list and match against the following:
You select one or more values to use in the condition.
You create a calculation to use in the condition.
You select an item to use in the condition.
Use this check box to match upper and lower case text data exactly. When selected, the match value 'New York' would not return data for 'new york'.
Use this button when you want to create more than one filter criterion. Here, you display additional fields and buttons used to create advanced conditions (see "New Condition dialog (Advanced)").
|
Copyright © 2002 Oracle Corporation. All Rights Reserved. |
|