Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calling user defined function in MDX

Status
Not open for further replies.
svega

svega

Programmer
Jul 21, 2002
2
US
Has anyone written a user defined function that takes a safearray as a parameter? What is considered a better practice declaring parameters of type SAFEARRAY(type) or VARIANT? Any info will be greatly appreciated!

Thanks,
Svega
 
Sort by date Sort by votes
Well, after some messing around it looks like AS always passes a VARIANT with a SAFEARRAY of VARIANTs to UDFs. If a UDF is declared to take a SAFEARRAY(type) as a parameter in type library AS will fail to call it.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

burakcan
  • Locked
  • Question
How to rounding up to next integer value In MDX
Replies
0
Views
180
burakcan
burakcan
juanvg1972
  • Locked
  • Question
Problems linking dimension tables and fact tables in SSAS cube
Replies
0
Views
149
juanvg1972
juanvg1972
edvmat
  • Locked
  • Question
Error in the conversion sql query
Replies
2
Views
219
edvmat
edvmat
burakcan
  • Locked
  • Question
How to hide unwanted dimension values in SSAS cube
Replies
1
Views
277
Motlatjo
Motlatjo
JP_Quinn
  • Locked
  • Question
Adding New Column to Dimension Table, Used in Other Cubes, Must I Update the Models of Other Cubes?
Replies
0
Views
182
JP_Quinn
JP_Quinn

Part and Inventory Search

Sponsor

Back
Top