IN WHICH DIFFERENT SCENARIOS WE CAN USE @AA FUNCTION?
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
Which versions are used in the bo dashboard work?
What is the difference between absolute and relative div positioning?
What is a fantrap in business objects?
What three things do you consider to be the most important factors for a manager?
How to schedule the report in b.o?
Difference between b.o 5.1 and 6.1b?
How to open a universe with out using the Designer ??
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
What Is The Difference Between Oltp And Olap?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
What Is Snow Flake Schema?
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
What is top business?
Did you face any problems while creating reports? Name? Solutions?
8. How much supervision have you typically received in your previous job?