IN WHICH DIFFERENT SCENARIOS WE CAN USE @AA FUNCTION?
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 custom sorting?how we can do this expalain with procedure???
when and where we use @varialble function
What is Complex Reports?
what is the source for metrics?
how to test the reports if there are multiple sql statements?i,e if there is 1 single sql statement we can copy it and paste it in TOAD or someother tools to test it but if we have multiple sql statements in a single query????
how to solve the incompatible objects and how they are formed actually.
How do u Receive requiremnts from the client?
what is a Micro cube?
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
What is ment by For each For all function. In which case we use the option in BO?
How to open a universe with out using the Designer ??
How will you move reports from Dev to QA in BO