Skip to Content
0
Former Member
Oct 25, 2011 at 02:59 PM

Statistical Functions in BEx or Webi

209 Views

Hi Gurus,

I have a requirement to deliver a statistical report. I can visualize some of the functions but not all. There is just one Key Figure on which all analysis needs to happen.

I need the following Functions.

u2022 Minimum

u2022 Maximum

u2022 Mean

u2022 Quartile 1

u2022 Median

u2022 Quartile 3

u2022 98 Percentile

u2022 SD (Standard Deviation)

I can get the MIn and the Max by using exception aggregation in the BEx Query but am not sure how to get the rest.

Please let me know if you have any ideas.

Thanks

-Sid