Interested to Buy Any Domain ? << Click Here >> for more details...
What is aggregate navigation? How do you configure the Aggregate tables in OBIEE?
- 1 Answers
- 2890 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 |
What are global filter and how they differ from column filter?
What is the purpose of Alias Tables?
You come morning to the office. And all the users are complaining about the obiee reporting system is very slow(dasboards). What is your approach to resolve the issue?
What is a bridge table ?
Why do we have multiple LTS in BMM layer? What is the purpose?
What is clusterservices in obiee ? Why its used?
How to get sql from obiee for reports?
If you have 2 fact and you want to do report on one with quarter level and the other with month level how do you do that with just one time dimension?
What is query repository tool?
How will you enable or disable caching in the system level and table level?
What are the challenges you faced while making of reports?
How do you identify what are the dimension tables and how do you decide them during the Business/Data modeling?
Teradata 
