why we use aggregation in lower level

Answer Posted / shamanth

Aggregation will be defined at lowest level only, because
we can move/drill anytime from lowest-highest but viceversa
(highest-lowest) is not possible.

Defining aggregation at the lowest level is best practice
to improve performance.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the difference between detect alias and detect context?

691


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)?

612


explain in detail about type 3?

688


What is report template in b.o?

640


How to create Index to the table in the universe designer and how it improves the Query performence

2191






Differences between business objects and web intelligence reports?

725


When we use aggregate awareness function in designer?

613


Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.

3909


Is there any other repository domains rather than universe, security, document?

673


What is the difference between user and versatile user?

651


Explain which versions are used in the bo dashboard work?

698


Explain about alerts in bos, under what situation we need to use alerts?

624


What sort of existing documents should business analysts refer to when starting on a new project?

677


how get the grand total in master-detail report?

1870


Migration of Reports from business objects 5.1.5 to samee version in different hardware?

1972