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
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
Explain is there any other repository domains rather than universe, security, document?
Explain how we drill up week to month?
Explain what would you consider as your biggest achievement and why?
what are the tables used in health care domain project and columns used in report?
What is Indexing? how did u implement indexing?
How to create Index to the table in the universe designer and how it improves the Query performence
What is report template in b.o?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
What are the steps to do to use alerts in bo?
What is difference between custom hierarchy and report based hierarchy?
Explain what task is 98% of the required work of a business analyst?
how to create reports on screech?
Explain in detail about type 1?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?