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


Please Help Members By Posting Answers For Below Questions

Explain how to execute the plsql procedure from the report by clicking with mouse?

823


How to schedule the report in b.o?

764


What is top business?

758


What is the difference between absolute and relative div positioning?

793


Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com

2186


Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

824


how get the grand total in master-detail report?

2012


What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

815


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?

3345


can anybody tell me about complicated object you have created

2977


Explain what are the steps to do to use alerts in bo?

810


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,

1813


Explain what would you consider as your biggest achievement and why?

758


What are the data types present in bo? What happens if we implement view in the designer and report?

805


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

4759