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 |
Have you created hierarchy in obiee. If so where and how?
How do i disable cache for only 2 particular tables?
What is the difference between Data Level Security and Object Level Security?
How online/offline mode impact development and delpoyment?
How will you port changes for dashboards,reports,rpd from development to production?
Can you bypass siebel analytics server security ?if so how?
How we are going to decide which schema we are going to implement in the data warehouse?
What are the major challenges you faced while creating the rpd?
What are the challenges you faced while making of reports?
Can you run multiple rpd’s in a single obiee instance?
How will you create interactive dashboards ?
How do you bring/relate the aggregate tables into the Siebel analytics Logical layer?