Interested to Buy Any Domain ? << Click Here >> for more details...
what is the syntax for aggregate awareness?
- 3 Answers
- 20098 Views
- Exilant, i-Tree, Wipro, I also Faced
- E-Mail Answers
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
What is the dense rank?
Explain what are the steps to do to use alerts in bo?
Explain in detail about type 1?
Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
U r project in which stage in implementation?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
in sap bi we have wad, then why we go for sap bo
What is the difference between slice and dice and cross tab report?
What three things do you consider to be the most important factors for a manager?
What are the data types present in bo? What happens if we implement view in the designer and report?
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY
Can we configure two instances of CMS pointing to two different CMS system databases?
what is universe null
