External Function with Variant Array -
09-16-2004
, 04:35 PM
Is it possible to call an external function that has variant array
parameters from within Analysis Services?
I want to make a function (Example in VB) that has parameters as
follows:
Public Function XYZ(ParamArray Agrs() as Variant) as Double
This will allow me to use it in many of my calculations and pass
however many sets are necessary. i.e.
XYZ({SET1},{MEASURE_SET2})
XYZ({SET1},{SET2},{MEASURE_SET3})
XYZ({SET1},{SET2},{SET3},{MEASURE_SET4})
If I am calculating accross X dimensions, I can pass the UniqueName
arrays to the first X-1 parameters and the last parameter will be the
measure.
Hope this makes sense.
Thanks. |