Customer does not have access to Business Objects, Crystal Reports or similar but requires percentiles to be calculated at runtime.
Customer wants 10th, 25th, 50th, 75th and 90th percentile of the employees' individual wages to be presented for whatever combination or drill-down of characteristics are selected in report. Eg first display is organizational units as a hierarchy, each unit should have the percentiles displayed and calculated on the wages of the employees for that unit. Also, minimum wage for each unit and total sum for wages for each unit should be presented.
If user adds Gender from free characteristics, the percentile values should be re-calculated so that they are based on the employees' wages for each gender under each unit.
Is this at all possible?
Query Designer does not provide any options unless we predefine which characteristics we want to use and sort and index the data accordingly. This is not an option since user will analyse many scenarios and does not know beforehand which scenarios are applicable.
Web Application Designer can offer median value (50th percentile) via context menu but only based on the subtotals and totals presented in query (eg total wage for organizational unit, not employees' individual wages).
Only option as we see it now is to try to create an enhancement of context menu in WAD and use a customer exit to do the calculation and then send result back to query. But is this a solution? Will it even work? Can this work dynamically or must user make selection on menu for each re-calculation of the values? Will it damage performance?
There is very little information about percentile calculations on forums or SAP help, is this not supported at all if customer does not use BO or similar?
Please advice on solution or information about whether or not this is supported by BI.
(links to info regarding enhancement and customer exit
(System information: SAP Netweaver 7.0 EHP 1, suppport pack 8)