Interested to Buy Any Domain ? << Click Here >> for more details...
IN WHICH DIFFERENT SCENARIOS WE CAN USE @AA FUNCTION?
- 1 Answers
- 6601 Views
- Accenture, I also Faced
- E-Mail Answers
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 |
What is global filters and local filters
i want to creat 2way drilling using hyrarchies and hyperlinks...can anyone please help me
What Is The Difference Between Oltp And Olap?
WHAT ARE THE INDEXES THAT SUPPORT DATA WAREHOUSING ? Thanks In advance Prakash
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
Can any please explain FOR EACH AND FOR ALL?
what is diff between webi,deski,infoview
What is report template in b.o?
Where will you find the address of repository in Business Objects?
What are templates? Explain what you have created?
Can we use two different sources in webirich client to create A report ? Like universe and excel etc...
What is DSS?? (Defination of DSS)
Teradata 
