Oracle® Business Intelligence Discoverer Plus User's Guide
10g Release 2 (10.1.2.0.0) Part No. B13915-01 |
|
![]() Previous |
![]() Next |
Applying more than one single condition at the same time can have the same effect as creating a multiple condition. This can keep your condition statements short and make them easier to understand by other Discoverer users. Single condition statements also enable you to selectively apply individual condition statements.
For example, you apply the following two single conditions:
Year = 2001
Sales SUM > $100,000
This has the same effect as one multiple condition containing two condition statements:
Year = 2001 AND Sales SUM > $100,000
Note: When filtering certain types of data, using a multiple condition produces different results from using more than one single condition. For example, when using analytic functions (for more information, see "About analytic functions and sequencing").