A customer always wants Aggregate Table l to be looked at first to see if it can answer the query.
What should be done to make sure this happens?
A.
Make Aggregate Table 1 the first table in the list of Logical Table Sources.
B.
Do not map the logical level in the Content tab.
C.
Set the Priority Group to 0.
D.
Set the Priority Croup to 5.
Explanation:
Priority group
You can set priority group numbers to determine which logical table source should be used for
queries for which there is more than one logical table source that can satisfy the requested set of
columns.
For example, you might have user queries that can be fulfilled by both a data warehouse and an
OLTP source. Often, access to an operational system is expensive, while access to a data
warehouse is cheap. In this situation, you can assign a higher priority to the data warehouse toensure that all queries are fulfilled by the data warehouse if possible.
Note that the priority group of a given logical table source does not always ensure that a particular
query will be fulfilled by that source.
Priority Group Designation
0 the highest-priority source (the default)
1 a lowest-priority source
C
if source 1 with priority number=0 can answer the query, obiee will continue to query the source with lower priority number of just return to report?