MDSCHEMA_FUNCTIONS Rowset

APPLIES TO:yesSQL Server Analysis ServicesnoAzure Analysis Services

Describes the functions available to client applications connected to the database.

Rowset Columns

The MDSCHEMA_FUNCTIONS rowset contains the following columns.

Column name Type indicator Description
FUNCTION_NAME DBTYPE_WSTR The name of the function.
DESCRIPTION DBTYPE_WSTR A description of the function.
PARAMETER_LIST DBTYPE_WSTR A comma delimited list of parameters formatted as in Microsoft Visual Basic. For example, a parameter might be Name as String.
RETURN_TYPE DBTYPE_I4 The VARTYPE of the return data type of the function.
ORIGIN DBTYPE_I4 The origin of the function:

1 for MDX functions.

2 for user-defined functions.
INTERFACE_NAME DBTYPE_WSTR The name of the interface for user-defined functions

The group name for Multidimensional Expressions (MDX) functions.
LIBRARY_NAME DBTYPE_WSTR The name of the type library for user-defined functions. NULL for MDX functions.
DLL_NAME DBTYPE_WSTR (Optional) The name of the assembly that implements the user-defined function.

Returns VT_NULL for MDX functions.
HELP_FILE DBTYPE_WSTR (Optional) The name of the file that contains the help documentation for the user-defined function.

Returns VT_NULL for MDX functions.
HELP_CONTEXT DBTYPE_I4 (Optional) Returns the Help context ID for this function.
OBJECT DBTYPE_WSTR (Optional) The generic name of the object class to which a property applies. For example, the rowset corresponding to the <level_name>.Members function returns "Level".

Returns VT_NULL for user-defined functions, or non-property MDX functions.
CAPTION DBTYPE_WSTR The display caption for the function.

The rowset is sorted on ORIGIN, INTERFACE_NAME, FUNCTION_NAME.

Restriction Columns

The MDSCHEMA_FUNCTIONS rowset can be restricted on the columns listed in the following table.

Column name Type indicator Restriction State
LIBRARY_NAME DBTYPE_WSTR Optional.
INTERFACE_NAME DBTYPE_WSTR Optional.
FUNCTION_NAME DBTYPE_WSTR Optional.
ORIGIN DBTYPE_I4 Optional.

See Also

OLE DB for OLAP Schema Rowsets