pinki

• Jul 14th, 2006

 

Hi

1. In order to solve fan trap in busines objects we either create alias table or aggregate awareness function

2. Through aggregate navigation we can also select the compatable as well as incompatable objects

Ex:-year, quarter, month, week, day

year:-quarter, month, week, day are compatable objects

quarter:-year class is incompatable and month, week, day are compatible.

3. We specify the objects in descending order

like @ aggregate awareness(sum(year), sum(quarter), sum(month),......).

ASHOK1324

 Profile Answers by ASHOK1324 

• Apr 19th, 2009

 

In Universe Designer, we can use aggregate functions to define measure objects. A measure object is any numeric field with summary details caculated using aggregate functions.