Oracle® Business Intelligence Discoverer Plus User's Guide
10g Release 2 (10.1.2.0.0) Part No. B13915-01 |
|
![]() Previous |
![]() Next |
Filters apply to dimensions. Each dimension has an associated query. The data selected by a dimension's query might or might not be dependent on the data selected by another dimension's query. Consider the following example:
Time dimension: Select latest 6 months
Geography: Select territories where Sales is greater than Quota.
Product: For each territory, select categories where Sales growth is negative.
For clarity, a filter must be fully qualified. For example, suppose you create a query in which you want to display the top three selling products for each Geography, and Time is set to January. If you change the value of Time to February, then you change the result of the query; that is, the top three selling products might be different for February.