The only Percentile function with which I have any exposure is the Essbase MDX function. Is this the function to which you are referring?

Example:

WITH MEMBER [Measures].[Perc] AS
'Percentile(Products.Levels(0).Members, [Measures].[Price Paid], 10)'
SELECT {[Measures].[Price Paid], [Measures].[Perc] } ON COLUMNS,
{ Products.Levels(0).Members } ON ROWS
FROM AsoSamp.Sample


Per the documentation, "this function orders the set according to the numeric value expression. It then finds the tuple at the given percentile and returns its value ... The returned value is such that n percent of the set members are smaller than it."

Is this what you are trying to accomplish? Where are you trying to use the function?



Thanks.

Bill