If you have a database with four aggregate tables, how should the repository be configured
to take advantage of the aggregates?
A.
By creating four new logical tables sources
B.
By creating four new logical table sources and choosing each dimension’s level of
aggregationin the Content tab
C.
By creatingfour new logical table sources and using the Fragmentation content to specify
theaggregation levels
D.
By creating four new logical table sources and using the “where” section of the Content
tab to specify the aggregation levels
B
OK
B.
“Aggregate tables store precomputed results from measures that have been aggregated over a set of dimensional attributes.
Each aggregate table column contains data at a given set of levels.
For example, a monthly sales table might contain a precomputed sum of the revenue for each product in each store during each month.
You configure this metadata in the Content tab of the Logical Table Source dialog.”
http://docs.oracle.com/cd/E28271_01/fusionapps.1111/e20836/lts.htm