Percentile calculation in OBIEE

Question

Hi,

I am trying to calculate percentile in OBIEE, used percentile and ntile function..but not getting the desired result.

Expected ans In Red color. How to achieve this in OBIEE..????

DateCount of StudentCount of Student scored more than 025 % Percentile of Student Marks who scored more than 050 % Percentile75 % Percentile 01/01/201520187479401/01/201620186249401/01/2017202041190DateStudent Marks01/01/2015001/01/2015001/01/20151001/01/20159001/01/20151101/01/2015801/01/201510001/01/2015301/01/2015601/01/2015201/01/2015501/01/20159601/01/20159401/01/20154701/01/20158701/01/2015701/01/20157801/01/20155601/01/20159701/01/20159901/01/20169501/01/2016001/01/2016001/01/20161001/01/20169001/01/20161101/01/2016801/01/201610001/01/2016301/01/2016601/01/2016201/01/2016501/01/20169601/01/20169401/01/20162401/01/20168701/01/2016601/01/20167801/01/20165601/01/20169701/01/20179501/01/2017701/01/2017601/01/20171001/01/20179001/01/20171101/01/2017801/01/201710001/01/2017301/01/2017601/01/2017201/01/2017501/01/20179601/01/20179401/01/20174701/01/20178701/01/2017701/01/20177801/01/20175601/01/201797€

Could you pls assist in getting solution.

Thanks,

Gianni Ceresa · Answer

@SANTOSH VIDHATE-Oracle ,

edit: you already have a question posted for this, stay in it, but provide more details, like the things I mention below.

https://community.oracle.com/products/oracleanalytics/discussion/25539/i-need-to-calculate-percentile-of-25th-50th-and-75th-please-let-me-know-any-calculation-available

This is a 8 years old post.

You better post a new question, providing enough information to give you answers not based just on guesses. Things like the part of the product where you are trying to calculate your percentile: in a semantic model? In an analysis? In a Publisher report? In DV workbook? In a DV dataset (based on what source)?

And because you say "function provided in OAC not giving correct result", what did you try, what was the result, what make you say it isn't correct, what are you expecting instead?

Keeping it simple: help others helping you, and a new question is the ideal place for it, better than this abandoned thread that has been migrated across 3 different forum in the past 8 years.

I'm closing this one…

Thanks :)

SANTOSH VIDHATE-Oracle · Answer

I Need to calculate Percentile in OAC tool. But the function provided in OAC not giving correct result.

Brendan T · Answer

yes use the PERCENTILE functions can be used

or use the pl/sql package DBMS_STATS_FUNC.SUMMARY()