what is the syntax for aggregate awareness?
Answer Posted / kshatri
Aggregate awareness is a feature that makes use of
predefined aggregate tables to enhance the performance of
SQL transactions. It is used to improve the speed by which
aggregates are calculated in the database. To set up
aggregate awareness in a universe, you define or more
objects using the @Aggregate_Aware function. The syntax for
this function is as follows:
@Aggregate_Aware(aggregate_table_1, ... aggregate_table_n)
The arguments of this function are all the names of
alternative aggregate tables. When you formulate the
syntax, you should be aware of the order of the arguments.
The precedence is from left to right; this means that
BusinessObjects determines the aggregate to use beginning
from the leftmost argument.
Is This Answer Correct ? | 20 Yes | 5 No |
Post New Answer View All Answers
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
How were the reports scheduled and how to resolve unexecuted documents?
how to create reports on screech?
What are the steps to do to use alerts in bo?
how to prepare the documentation in business objects and where to get the requirement?
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?
What is the difference between condition & filter?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
Explain which versions are used in the bo dashboard work?
in sap bi we have wad, then why we go for sap bo
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
What is the difference between user and versatile user?
Can we configure two instances of CMS pointing to two different CMS system databases?
what is document design in boxi,have u participate in that