Scenario: Factless fact table, the meaning of each measure is defined by one of the dimensions. Generally this is defined by placing the dynamic dimension on columns.
The data represents a type of monitoring solution, with 1 minute samples. Several analysts have requested this type of measure: Show only those where the value (of each measure...) is less than its 95th percentile value
Using 75th percentile instead, example is values of:
1, 2, 3, 4
Return only 1,2, and 3 - so the average is instead (1 + 2 + 3)/3 rather than (1 + 2 + 3 + 4)/4.
Hopefully this is clear. First the good news: I have a ranking MDX function already, so I should be able to query it to return those 95th or 75th percentile values. Given that it's dynamic (each type of measure is going to have differenty
95th percentile values), can someone help with MDX or perhaps give a pointer?
View Complete Post