Interested to Buy Any Domain ? << Click Here >> for more details...
what is the syntax for aggregate awareness?
- 3 Answers
- 19939 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 difference between condition & filter?
When to use local filter and when to use global filter?
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
what are the tables used in health care domain project and columns used in report?
Explain about alerts in bos, under what situation we need to use alerts?
What is a bo repository?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
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?
8. How much supervision have you typically received in your previous job?
Can Bo generates the Report from the cubical data Explain?
how to create metric universe ?
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
what is the difference b/w the refresh and buffered data?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
