1. Categories >> Software >> Data Warehouse >> Business Objects
  2. Suggest New Category

IN WHICH DIFFERENT SCENARIOS WE CAN USE @AA FUNCTION?

Question Posted / riaz


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

Answer / sachin jain

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

WHAT ARE THE TYPES OF UNIVERSES?PLZ EXPLAIN IT

9 Answers   Business Intelligence Analytics, SRA,

When any new universe changes are deployed how does the end user get the view of the new classes/objects added(aprt from specs doc)?

4 Answers   IBM,

What is the difference between the Bo 3.0 and 3.1?

1 Answers  

What are the errors u have faced in creating reports in business objects and explain some?

3 Answers   TCS,

1. What is the difference between in creating filters in designer and business objects? 2.How did u give a developed universe to your client? 3.If i want to grant access to a report to a group of users,how do i do?

2 Answers  




what is BIAR file in business objects xi r2

3 Answers   TCS,

Explain about Short cut join?

2 Answers   Wipro,

How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.

0 Answers  

Explain what is the difference between business requirement document and use case document.

0 Answers  

how to do scheduling in desktop intelligence in BO XI R2

3 Answers  

what will be the contents for a functional requirements specifications

0 Answers  

Tell me about a complicated object you have created?

1 Answers  

For more Business Objects Interview Questions Click Here
Categories