Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
purpose and limitation of aggregation function.If any?
Hi,
Hope attached file helps you.
Regards,
Jagan.
Generaly Aggr function used where we want to implement functionality like group by in our charts..
It is generaly comes handy in pivot table where we need to do analysis on dimensional group basis.
HTH
Sushil
Without use aggr function to calculate the expression corresponding based on all the dimension..
sometimes the expression gives blank value or in correct values
by use of aggr function we calculate that expression on the basis od=f selected dimension.so, dong this we getting a correct value on the basis of dimension which we used as aggr function.. its limitation is that we get the result forcefully based on selected dimension instead of all dimensions......