Interested to Buy Any Domain ? << Click Here >> for more details...
IN WHICH DIFFERENT SCENARIOS WE CAN USE @AA FUNCTION?
- 1 Answers
- 6496 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
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?
what is the difference b/w the refresh and buffered data?
I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
How to restrict password to a user while sending a document in .pdf format
What is aggregate table and aggregate fact table ... Any examples of both?
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
How many universes can be created in a project?
Explain how we drill up week to month?
What three things do you consider to be the most important factors for a manager?
What is object stores?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
Explain about a tricky situation for which you found a very simple solution?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
