Interested to Buy Any Domain ? << Click Here >> for more details...
what is aggregate navigation?
- 3 Answers
- 26802 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
8. How much supervision have you typically received in your previous job?
How many universes can be created in a project?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
Explain is there any other repository domains rather than universe, security, document?
In banking domain how many Fact tables,Dimension table are present?
Can anybody tell me what are the tuning problems?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
What are all difference between business objects 6.5 and xi r2?
explain in detail about type 3?
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
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:
Can more than 1 metric be applied on an analytic in business objects?
Differences between business objects and web intelligence reports?
