Interested to Buy Any Domain ? << Click Here >> for more details...
IN WHICH DIFFERENT SCENARIOS WE CAN USE @AA FUNCTION?
- 1 Answers
- 6437 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
How to create Index to the table in the universe designer and how it improves the Query performence
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
Hi friends,
I am trying to create OLAP connection in IDT. I am getting
error "error code:405 METHOD NOT ALLOWED"
I am using "http:
How were the reports scheduled and how to resolve unexecuted documents?
what is the difference b/w the refresh and buffered data?
Difference between b.o 5.1 and 6.1b?
How to generate the report from excel sheet?
How would you format some text using css to be verdana and bold?
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
What is the difference between absolute and relative div positioning?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
What three things do you consider to be the most important factors for a manager?
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)?
Explain what is the difference between business requirement document and use case document.
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
