What is aggregate navigation? How do you configure the Aggregate tables in OBIEE?
Answer / madhu
Aggregate tables store pre-computed results, which are measures that have been aggregated (typically summed) over a set of dimensional attributes. Using aggregate tables is a very popular technique for speeding up query response times in decision support systems.
| Is This Answer Correct ? | 1 Yes | 0 No |
Explain the architecture of obiee and what each components do?
Can you migrate the presentation layer to a different server.
what is guided navigation?
We have 4 dimension tables, in that 2 tables need to have hierarchies then in such a case is it mandatory to create hierarchies for all the dimension tables?
Define repository in terms of OBIEE?
How we are going to decide which schema we are going to implement in the data warehouse?
How will you enable or disable caching in the system level and table level?
What is data level security?
Can you use physical join in BMM layer?
What are global filter and how they differ from column filter?
How will you go about adding additional column to the repository in the presentation layer?
What are different types of variables?