There are two aggregate tables that are available for query. How would they be mapped into the logical data model so queries can use them?
A. By creating two new logical tables sources
B. By opening the two logical Table Source dialog boxes and mapping the appropriate levels in the Content tab
C. Both A and B
D. By creating one new Logical Table Source
Correct Answer: B
Explanation/Reference:
B: Example:
1. Configure the new source table to have the ‘logical level’ under the content set to ‘Countries’ (the summarized level)
2. Do the similiar setting for dimension table
Now when user query the data at ‘Counties’ level, the query will be redirected to these summary table instead of the more detail fact table
Note: Aggregate tables are Physical tables that store Aggregates of measures across multiple levels of a Hierarchy.