Bottom Sum (Dimensional Reporting)

[cognos05]

Hi All,

Can anyone let me know the how the bottom sum function works in dimensional reporting,
I couldn't understand the below explanation.

bottomSum(set_exp,numeric_exp1,numeric_exp2)
This function sorts on "numeric_exp2",evaluated at the corresponding member of "set_exp", and picks up the bottom most elements whose cumulative total is atleast "numeric_exp1".

bottomSum( Regions,5000, Tuple([Revenue],[2006]) -- what does this mean..  It will give me the regions whose revenue value is ?

Thanks,
Nithya.

[bi4u2]

It should give you the regions whose revenue value for 2006 is at least 5000.

[bi4u2]

Correction - it would give you the bottom region - ascending value - just one region. topSum would be in descending value.

[MFGF]

Hi All,

Can anyone let me know the how the bottom sum function works in dimensional reporting,
I couldn't understand the below explanation.

bottomSum(set_exp,numeric_exp1,numeric_exp2)
This function sorts on "numeric_exp2",evaluated at the corresponding member of "set_exp", and picks up the bottom most elements whose cumulative total is atleast "numeric_exp1".

bottomSum( Regions,5000, Tuple([Revenue],[2006]) -- what does this mean..  It will give me the regions whose revenue value is ?

Thanks,
Nithya.

Hi,

You are giving it a threshold to work with - think of it as a running total. It will retrieve the region members with the lowest value of revenue in 2006. You can't say for sure how many it will retrieve - just that the sum of the revenue for all of these members is less than the threshold you specified. If it had retrieved one more, the sum of the revenue values would have exceeded the 5000 threshold.

Cheers!

MF.