BusinessObjects Board

How to work with Aggregations

building reports desktopintelligence
#1

Hi All,
I have created a Deski report in BO 11.5.

ORDER_NO QUATER AMOUNT
233 1 100
233 1 50
233 1 20
233 170 (Sum of ORDER_NO)
256 1 190
256 190
266 2 100
266 2 60
266 2 50
266 210
267 4 250
267 250

I’m trying show only those orders whose SUM OF ORDER_NOs is >= 200(Tryning to create a filter on Aggregation). In that case, the report should show following data where SUM of AMOUNT for each ORDER_NO is >= 200
ORDER_NO QUATER AMOUNT
266 2 100
266 2 60
266 2 50
266 210
267 4 250
267 250

shuchi (BOB member since 2007-09-24)

#2

Hi there,

How did you create your filter ?
What about your DP ? Simply one ? Multiple ?
And what’s your “explicit” questions ?!

Cheers

kenny :fr: (BOB member since 2007-01-02)

#3

Hi,

I have not created any filter on report. I want to show only those ORDERS_NO in the report whose SUM of amount is greater than 200.
On Sum(Amount) Aggregation I have tried I can’t add any filter, nothing on it.

Thanks in Adavance.

shuchi (BOB member since 2007-09-24)

#4

I have learnt this from the BOB gurus.

Try this:

Make a variable with the condition:
If (SUM OF ORDER_NOs )>= 200 then 1 else 0

then rank your order No based on this new variable with top parameter having a value of “1”.

kurt (BOB member since 2006-11-06)

#5

i was having a go at this but the rank function is greyed out , any ideas why?

seems only dimensions can be ranked?

johnwxyz (BOB member since 2008-01-26)

#6

The rank function will be greyed out, because you have not clicked on the dimension you have to rank. Rank is done on dimension, there is no way you can rank a measure, I mean it does not make any sense. You can rank dimension based on measure.

kurt (BOB member since 2006-11-06)

#7

Look at this in the Business Objects Classic (Reporter) FAQs:

Judy

JMulders :us: (BOB member since 2002-06-20)