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 aggregation
in the Content tab
C.
By creating four new logical table sources and using the Fragmentation content to specify the
aggregation levels
D.
By creating four new logical table sources and using the “where” section of the Content tab to
specify the aggregation levels
Explanation:
Content Tab
Aggregation Content
You can define the aggregation (ie the group by) of:
by hierarchy level
by logical column
It helps you to define an aggregate navigationNote: logical table source
Logical table sources define the mappingsfrom a single logical table to one or more physical
tables. A logicaltable contains one or more logical table source. The mapping between physical
columns and logical columns are done in this element.
The definition of the logical table source is used:
The Content tab of the Logical Table Source is used to define :
B)
http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/bi1221/rpd/rpd.html
->using aggregations
->Setting Aggregate Content
->set the logical level of aggregated fact source table and aggregated dimension source table