dbTalk Databases Forums  

External Function with Variant Array

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss External Function with Variant Array in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
J Porter
 
Posts: n/a

Default 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.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.