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

IN WHICH DIFFERENT SCENARIOS WE CAN USE @AA FUNCTION?

Question Posted / sachin jain

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

629

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?

1557

Explain what are the steps to be taken to schedule the report?

639

What is the difference between business requirement document and use case document.

585

What is the profile and package?

1767




explain in detail about type 3?

628

Explain which versions are used in the bo dashboard work?

633

What Is The Difference Between Oltp And Olap?

677

What are the data types present in bo? What happens if we implement view in the designer and report?

622

Which versions are used in the bo dashboard work?

601

What is the difference between condition & filter?

607

What is object stores?

583

Can we configure two instances of CMS pointing to two different CMS system databases?

1489

how to prepare the documentation in business objects and where to get the requirement?

1782

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

579