IN WHICH DIFFERENT SCENARIOS WE CAN USE @AA FUNCTION?
- 1 Answers
- 5850 Views
- Accenture, I also Faced
- E-Mail Answers
Can follow two approaches.
1. Aggregate tables are built in the database, which contains the dimension fields(not foreign keys) along with the aggregated measures. In the universe they are present as standalone tables.Aggregate aware function is used to define both the dimensions and measures of such tables
2. No aggregate tables are built in the database level. They contain the normal fact table at different granularities. In the universe, aggregate aware is used only to define the measures and aggregate incompatibility is set accordingly
The first approach is better in terms of performance, since for the higher levels of aggregation, all the information is obtained for a single table. However, a large scale implementation of this approach in a dimensional schema is difficult. In most BI projects, the second approach is preferred
| Is This Answer Correct ? | 2 Yes | 0 No |
wat is the difference between full clinet report and thin client report?wat is the difference between desktop intelligence and web intelligence?
What is the difference between absolute and relative div positioning?
whats the Diffrerence between business objects and cognos?
what is the source for metrics?
Can you please send me the migration related issues .
How to create predefined filters in B.O.
How to link one location universe to other location universe
What is meant by multiple data provider.How to use it in universe as well as reporting environment?
What is a bo repository?
i am using Business Objects 6.1(a) facing a problem. ie when we save report in xls format then in xls sheet pictures are inserted into rep file are not come. Is it a bug. Give me answer as soon as possible. Thanks in Advance
Can we start CMS server from CMC? Is yes can anyone tell me how plz Thanks in advance?
Shall we connect to the oltp systems directly .,
Teradata 
