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 |
What are different types of variables?
can you change the location of the obiee repository?
If you want to create new logical column where will you create (in repository or dashboard) why?
How will you create report from two subject areas
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?
What are the challenges you faced while making of reports?
What is data level security?
What are the different log files in obiee?
How do you bring/relate the aggregate tables into the Siebel analytics Logical layer?
What is authentication? How many types of authentication.
What is complex join, and where it is used?
What is the purpose of Alias Tables?