How do you bring/relate the aggregate tables into the Siebel analytics Logical layer?
Answer / madhu
One way of bringing the Aggregate Tables into the BMM layer is by bringing them as Logical Table sources for the corresponding Fact table.
This is done by dragging and dropping the aggregate table into the corresponding fact table. After doing that establish the column mappings and the set the aggregation levels in the content tab of the LTS.
| Is This Answer Correct ? | 1 Yes | 0 No |
What is aggregate navigation? How do you configure the Aggregate tables in OBIEE?
Suppose I have report which is running for about 3 minutes typically. What is the first step you take to improve the performance of the query?
What is data level security?
How to enable drills in a given column data?
How do you work in a multi user environment? What are the steps?
What are the different log files in obiee?
What are the different types of variables in obiee 11g? Explain
How will change port of obiee answers?
What is connection pool and how many connection pools did you have in your last project?
What is query repository tool?
What are other ways of improving summary query reports other than Aggregate Navigation and Cache Management?
How do you implement security using External Tables and LDAP?