IN WHICH DIFFERENT SCENARIOS WE CAN USE @AA FUNCTION?

Question Posted / riaz

1 Answers
6526 Views
Accenture, I also Faced
E-Mail Answers

IN WHICH DIFFERENT SCENARIOS WE CAN USE @AA FUNCTION?..

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

Post New Answer

More Business Objects Interview Questions

Differences between business objects and web intelligence reports?

0 Answers

define universe parameters?

5 Answers

Tell me about a complicated object you have created?

1 Answers

What are all difference between business objects 6.5 and xi r2?

0 Answers

Approximatly how many enduser can use the each bo project?

4 Answers HCL,

what is the syntax for aggregate awareness?

3 Answers Exilant, i-Tree, Wipro,

solve the following loops? dimension table fact table fact table dimension table link will be there between tables?

4 Answers

(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.

0 Answers

what is the difference between input file repository server and output file repository server ?

2 Answers CTS,

What is global filters and local filters

3 Answers IBM,

What is report template in b.o?

0 Answers

what is the difference b/w the refresh and buffered data?

0 Answers

For more Business Objects Interview Questions Click Here