I am trying to determine the best way to call an Excel function (Or maybe a
custom function written in .NET) for data returned from a Drillthrough
operation. Basically I need to calculate the 90th Percentile for a field in
my fact table so I need to pull back all the underlying data. My question
is this:

Has anyone been able to do efficient aggregations against drillthrough data?
Are there ways to create a temp table to hold this drillthrough data?

I don't want to have to pull all the data back into an ADOMDDataReader to
parse through all of the data to then just perform the aggregation if I
don't have to.

thanks