Interested to Buy Any Domain ? << Click Here >> for more details...
what is aggregate navigation?
- 3 Answers
- 26662 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)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
8. How much supervision have you typically received in your previous job?
What Is Snow Flake Schema?
what is universe null
Explain about a task that really tested your analytical abilities?
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
What Is The Difference Between Oltp And Olap?
Difference between b.o 5.1 and 6.1b?
U r project in which stage in implementation?
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
Explain how many universes can be created in a project?
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
What is the functional & architectural differences between business objects and web intelligence reports?
