IN WHICH DIFFERENT SCENARIOS WE CAN USE @AA FUNCTION?

Question Posted / riaz

1 Answers
6605 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

how many micro cubes can a report can have

3 Answers

what is the difference between breaks and sections?

3 Answers IBM,

How to view Public folder in Infoview for the Non-admin user? (normal user) What is the diff of working DEKI,WEBI in Infoview, and working as Individual start->Business Objects-> Deskto Intelligence, Web Intelligence.

1 Answers Cap Gemini, TCS,

can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?

0 Answers

What is the equivalent oracle operators for following BO Operators where we use in prompt: a. Different from pattern b.Match pattern c. Both and d.Except

2 Answers Nucleus Software,

Tow tables is there employee, projects . (many to many) one employee has different projects and one project has different employees . how we can achive the data from both

2 Answers Hexaware,

Explain how to schedule the report in b.o?

0 Answers

Tell me about a complicated object you have created?

1 Answers

what r the types of joins universe supports

3 Answers

What is the difference between master-detail and Breaks?

3 Answers

How to make alternative rows red and green in WebI Report?

3 Answers Accenture, Mphasis,

webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??

0 Answers

For more Business Objects Interview Questions Click Here