4.what is aggregate awareness ? how do we use ? where do we
use ?
Answer Posted / mrs.narmatha
Aggregate awareness: is the ability of a universe to make
use of aggregate the tables in a database. These tables
have precalculated data
USE:
you can use a function @aggregate_Aware in the select
statement for an object that directs a query to be run
against aggegate tables
This function can be used to speedup the exceution of the
query and to improve the performace of sql transaction
| Is This Answer Correct ? | 33 Yes | 3 No |
Post New Answer View All Answers
How we drill up week to month?
Can anybody tell me what are the tuning problems?
What is Indexing? how did u implement indexing?
When to use local filter and when to use global filter?
any difficulitis have you phase while creating bo reports and how did u solve it
What is report template in b.o?
Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,
What Is Snow Flake Schema?
Explain how to schedule the report in b.o?
When we use aggregate awareness function in designer?
What is the difference between absolute and relative div positioning?
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
Can you please send me the migration related issues .
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)?
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?