what is aggregate navigation?
- 3 Answers
- 25936 Views
- Countrywide, CTS, HCL, I also Faced
- E-Mail Answers
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
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
how many reports have u created ? explain a few.
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)?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
Give some information on report bursting?
What is aggregate table and aggregate fact table ... Any examples of both?
What sort of existing documents should business analysts refer to when starting on a new project?
Explain what is the difference between slice and dice and cross tab report?
What is report template in b.o?
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
Explain difference between zabo and webi?
What Is Snow Flake Schema?
What is a fantrap in business objects?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
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:
