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
Explanation:
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 tableNote: Aggregate tables are Physical tables that store Aggregates of measures across multiple
levels of a Hierarchy.
I guess it should be both A&B.
Even I guess it should be both A&B.
I went with C. If B is considered to be correct then A must be correct because that addresses the creation of the logical table sources. So, I believe the correct answer is C (Both A and B).
According to me, only B is correct.
Two aggregate tables are already available for query, so, if we read that according to BI Admin Tool concepts, they have already been imported in BMM Layer.
c) is correct