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
how many reports have u created ? explain a few.
Explain is there any other repository domains rather than universe, security, document?
Can we configure two instances of CMS pointing to two different CMS system databases?
how to prepare the documentation in business objects and where to get the requirement?
What is top business?
in sap bi we have wad, then why we go for sap bo
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
how to create reports on screech?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
What sort of existing documents should business analysts refer to when starting on a new project?
Explain about a task that really tested your analytical abilities?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
How to restrict password to a user while sending a document in .pdf format