Aggregation in Universe

[Former Member]

Hi ,

There is a Key Figure Quantity. I need to aggregate it in Universe on the basis of characteristic A and B, and restrict the rows if the aggregated quantity is less than 15. Is this possible in Universe ?

We tried this in Bex with conditions , but this is not suported in BO XI 3.1 .

Regards,

Sneha

[Former Member]

There is aggregation () function in Universe. Will it work for SAP as backend. What is the syntax for it ? I want to aggregate the measure on basis of two characteristric.

>> Restricting rows means on basis of the condition on this aggregated measure.

Thanks,

Sneha

[Former Member]

This can't be done in the universe when based on a BEx query. However, you could do the aggregations in BEx or in the InfoCube.

What do you mean about restricting the rows?