what is the syntax for aggregate awareness?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / vams_gk
@Aggregate_Aware(sum(agg_table_1), ... sum(agg_table_n))
| Is This Answer Correct ? | 15 Yes | 3 No |
Answer / suresh
@AGGRIGATE_AWARE(SUMMERY TABLE1.COLUMN,SUMMERY TABLE2.COLUM.........,DETAILED TABLE.COLUMN)
| Is This Answer Correct ? | 1 Yes | 0 No |
what r the advantages of creating the universe?
Can we add our own component in Xcelcius ,I am having a Indian client and I want to either create or import component (map) is it possible?? Currently I have imported Map image and working through icons is there any other way out??Please help.
1. what is import wizard and its purpose ? 2. what is publishing wizard and its purpose ?
Hi All, If anyone of you had very Latest & Authentic BUSINESS OBJECTS - XI Certification Dumps for the below Codes, can you please forward it to me, its really very urgent to me SABE 201, SABE 301, SABE 401, SABE 501V3.0 Thanks Mohan
What are the different types of connections?Explain?
what is universe null
What is difference between merged dimension and forced dimension??
My data source is Excel sheet. How to write the SQL Statement for Excel file in data provider? Is is possible?
How can we improve performance?
What is the drill up , drill down, drill by , drill trough ?
What Is The Difference Between Oltp And Olap?
Can we have multiple domains?