Oracle® Fusion Middleware User's Guide for Oracle Business Intelligence Discoverer Plus 11g Release 1 (11.1.1) Part Number B40105-02 |
|
|
PDF · Mobi · ePub |
This dialog enables you to see in detail a condition defined by the Discoverer manager. When using conditions created by the Discoverer manager, you can look at them, but you cannot change them or remove them from the worksheet.
You can turn them on and off just like other conditions created by you or other Discoverer users.
For more information, see:
What would you like to name your condition?
This field displays the name of the condition.
What description would you like to give your condition?
This field displays additional information about the condition entered when the item was created. It is blank if no additional information is available.
Formula
This box shows the components of the condition:
Item
This read-only field shows the item on data is matched against. For example, to filter information about people who earn more than $30,000, this field might contain 'Salary'.
Condition
This read-only field shows the operators being used to match against the Item. For example, to filter information about people who earn more than $30,000, this field might contain '>' (the greater than operator).
Values
This read-only field shows the value used to use to match against the selected Item. For example, to filter information about people who earn more than $30,000, this field might contain 30,000.
Case sensitive
This read-only field shows whether the condition is case sensitive when matching against text data. For example, if turned on, the value 'New York' would not find details containing 'NEW YORK'. If turned off, the value 'New York' would find details containing 'NEW YORK' and 'new york'.
Note: If the condition is an advanced condition containing multiple lines, the formula box shows the other lines and the logical operators joining the lines.