What is aggregate navigation? How do you configure the Aggregate tables in OBIEE?
- 1 Answers
- 2577 Views
- I also Faced
- E-Mail Answers
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 |
Did you create any new logical column in BMM layer, how?
If you have 3 facts and 4 dimension and you need to join would you recommend joining fact with fact? If no than what is the option? Why you won’t join fact to fact?
how will you implement security in obiee,so that subjects areas accessed by one group are not accessed by another group.
How do you split a table in the rpd given the condition. ( the condition given was Broker and customer in the same table) Split Broker and customer.
What are the different layers of obiee repository?
What is the end to end life cycle of OBIEE?
Define repository in terms of OBIEE?
How will you do sort in reports in obiee.
What is Authentication? How many types of authentication do we have in OBIEE?
How will you create report from two subject areas
What are the things you can do in the BMM layer?
How to get sql from obiee for reports?
Teradata 
