what is aggregate navigation?
Answer Posted / sam
To receive the performance benefit offered by an aggregate
schema, a query must be written to use the aggregate.
Rewriting the sample query was a simple matter of
substituting the name of the aggregate fact table for that
of the base fact table. This may be easy for technical
personnel, but can prove confusing for an end user. The
complexity grows as additional aggregate tables are added.
Technical and business users alike may err in assessing
which table will provide the best performance. And, if more
aggregate tables are added or old ones removed, existing
queries must be rewritten.
The key to avoiding these pitfalls lies in implementation
of an aggregate navigator.
A component of the data warehouse infrastructure, the
aggregate navigator assumes the task of rewriting user
queries to utilize aggregate tables.
Users and developers need only be concerned with the base
schema. At runtime, the aggregate navigator redirects the
query to the most efficient aggregate schema.
Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
What we need to discuss with designer before starting the universe designing.
Hi friends,
I am trying to create OLAP connection in IDT. I am getting
error "error code:405 METHOD NOT ALLOWED"
I am using "http:
Explain in detail about type 1?
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
Explain what task is 98% of the required work of a business analyst?
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
How to execute the plsql procedure from the report by clicking with mouse?
What is Indexing? how did u implement indexing?
what are the tables used in health care domain project and columns used in report?
Can more than 1 metric be applied on an analytic in business objects?
how many reports have u created ? explain a few.
Can you please send me the migration related issues .
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.