How to calculate the quartile values in BEx Query based on 0PSTNG_DATE (Posting Date) and 0QUANT_B (Quantity in base units of measure)

[vishal_raina]

I have Posting date in the query. I have to convert the posting date to the Day of the week.

User will have prompt to enter week 1 YTD and week 2 YTD

Based on input, user wants to see the computed quartiles -50%, -25%, Average, +25%, +50%
based on key figure 0QUANT_B for day 1, day 2, day 3, day4, day5.

Like:

For day1 (Monday)

What is the quartile values -50%, -25%, Average, +25%, +50%

For day2(Tuesday)

What is the quartile values -50%, -25%, Average, +25%, +50%

For day3(Wednesday)

What is the quartile values -50%, -25%, Average, +25%, +50%

For day4 (Thursday)

What is the quartile values -50%, -25%, Average, +25%, +50%

For day5 (Friday)

What is the quartile values -50%, -25%, Average, +25%, +50%

Please help and guide how to meet this requirement.

Regards

V.

[carlos_weffer]

HI Vishal

I suggest you add 0WEEKDAY1 Time Characteristic to your infoprovider. Assign 0WEEKDAY1 value based on 0PSTNG_DATE during data load transformation. Then follow the approach described here  (by Neelesh) to create a 'Bucket Scenario' where to allocate the quartile values using exception aggregation:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/c09f49c2-7448-2c10-ac92-d75f263a0...

Regards,

Carlos