Oracle® Fusion Middleware Administrator's Guide for Oracle Business Intelligence Discoverer 11g Release 1 (11.1.1) Part Number B32519-01 |
|
|
View PDF |
Use this dialog to create a new condition for use in the business area.
For more information, see:
"What are the different types of condition?"
"How to create simple conditions"
"How to create advanced conditions"
Advanced conditions contain multiple criteria. For example:
to restrict Discoverer end users to data for the year 2001 in the first quarter, you might create a mandatory condition here: Year = 2001 AND Quarter = Q1. When they access workbooks, Discoverer end users will always see data for the year 2001 in the first quarter.
to enable Discoverer end users to easily look at data for different quarters in the year 2001, you might create the optional conditions:
Year = 2001 AND Quarter = Q1
Year = 2001 AND Quarter = Q2
Year = 2001 AND Quarter = Q3
Year = 2001 AND Quarter = Q4
When they access workbooks, Discoverer end users will be able to focus on data for particular quarters in the year 2001 by applying these conditions.
Name
Use this field to enter a name for the new condition.
Generate name automatically
Select this check box for Discoverer to create a name for you.
Clear this check box to enable the Name field and enter a condition name.
Description
Use this field to enter additional information about the condition. This description is displayed when you select this condition in the Workarea, and in Discoverer Plus. Make your description useful to both you and your users.
Location
This field displays the name of the folder that will store the condition. This is the location you selected when you chose Insert | Condition.
Type
Use this drop down list to choose the condition type:
Mandatory
Mandatory conditions are always applied to a worksheet that contains one or more items from the folder that contains the condition. Discoverer Plus users are not notified of mandatory conditions and cannot turn them off.
Optional
Optional conditions can be turned on or off as required by Discoverer Plus users.
Formula
Use this field to specify the filter criterion that you want to use.
Item
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.
Condition
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.
Value(s)
Use this field 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:
Click Select Multiple Values to display the "Values dialog".
You select one or more values to use in the condition.
Click Create Calculation to display the "New Item dialog".
You create a calculated item to use in the condition.
Use the Select Item option to display the "Items dialog".
You select an item to use in the condition.
Note: You can enter up to 254 values in this field. If you want to enter more than 254 values in the condition, use the OR option to add a new condition statement line for the extra values.
Match case
Use this check box to match upper and lowercase text data exactly. When selected, the match value 'New York' would not return data for 'new york'.
Advanced
Use this button to add one or more new criteria lines to the condition. Use this button to display the Add, Delete, And, Or and Not buttons.
Add
Use this button to insert a new criterion line to the condition. By default, the new item is grouped with a logical AND, which means that data must match all criteria contained within the AND group.
Delete
Use this button to remove the currently selected filter criterion from the condition.
And
Use this button to insert a new criterion line to the condition. The new item is grouped with a logical AND, which means that data must match all criteria contained within the AND group.
Or
Use this button to insert a new criterion line to the condition. The new item is grouped with a logical OR, which means that data much match at least one of the criteria contained within the OR group.
Not
Use this button to invert the condition for the currently selected group. The item is grouped with a logical NOT AND or NOT OR, which means that data must not match the criteria contained with the NOT group.
Notes
The buttons Delete, And, and Or are only available if you have selected a criteria in the Formula display.