Interested to Buy Any Domain ? << Click Here >> for more details...
IN WHICH DIFFERENT SCENARIOS WE CAN USE @AA FUNCTION?
- 1 Answers
- 6602 Views
- Accenture, I also Faced
- E-Mail Answers
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
Can we configure two instances of CMS pointing to two different CMS system databases?
How to execute the plsql procedure from the report by clicking with mouse?
what is the difference b/w the refresh and buffered data?
Difference between zabo and webi?
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
8. How much supervision have you typically received in your previous job?
what are the day to day activities of BO administrator ?
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?
Explain what task is 98% of the required work of a business analyst?
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....
What is the difference between datawarehousing and businessintelligence?
how to create reports on screech?
Explain about a time when you discovered a more efficient way to do a work task?
Explain the difference between detect alias and detect context?
