Microsoft SQL Server 2005 Analysis Services

Calling Stored Procedures from MDX

After registering an assembly with Analysis Services, you can call it from MDX expressions

and queries. Because stored procedures extend native MDX functions, you can use them

in any expression that allows an MDX function with the same return type. For example,

if you call a stored procedure from the axis definition of the

SELECT statement, it should

return a

Set object or another MDX object that you can convert to a Set object, such as a

Member or Tuple. (For the rules of type conversions, see Chapter 11, “Advanced MDX.”)

You can see an example in the following query:

SELECT MyUserDefinedFunctionAsSet() ON COLUMNS ...