Interested to Buy Any Domain ? << Click Here >> for more details...
IN WHICH DIFFERENT SCENARIOS WE CAN USE @AA FUNCTION?
- 1 Answers
- 6539 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
Explain is data mart?
What is package in BO
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
Can we create universe with no cache??
Explain how to execute the plsql procedure from the report by clicking with mouse?
What is aggregate table and aggregate fact table ... Any examples of both?
What task is 98% of the required work of a business analyst?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
Differences between business objects and web intelligence reports?
What is a fantrap in business objects?
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 ?
how many reports have u created ? explain a few.
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
Explain about a task that really tested your analytical abilities?
