FUNCTIONS Rowset

The FUNCTIONS rowset exposes all functions supported by the MDP, including user-defined functions (UDF) registered on the client.

The default sort order is ORIGIN, INTERFACE_NAME, and FUNCTION_NAME.

The rowset has the structure described in the following table.

Column name	Type indicator	Description
FUNCTION_NAME	DBTYPE_WSTR	Required. The name of the function.
DESCRIPTION	DBTYPE_WSTR	Optional. A human-readable description of the function.
PARAM_LIST	DBTYPE_WSTR	Optional. A comma delimited list of parameters in Visual Basic style, for example: Name as String.
RETURN_TYPE	DBTYPE_I4	Required. VARTYPE of the return data type of the function.
ORIGIN	DBTYPE_I4	Required. Indigenous or user-defined function, such as MSMD_SCHEMA_FUNCTIONS_ORIGIN_MSOLAP, or a UDF such as MSMD_FUNCTIONS_ORIGIN_UDF, which are both supported by MSOLAP.
INTERFACE_NAME	DBTYPE_WSTR	Required. Name of the interface for UDF and Group name for the MDX functions.
LIBRARY_NAME	DBTYPE_WSTR	Optional. Name of the type library for UDFs. NULL for MDX functions.
DLL_NAME	DBTYPE_WSTR	Optional. Name of the .dll or .exe in which this function is implemented. NULL for MDX functions
HELP_FILE	DBTYPE_WSTR	Optional. Name of the help file in which this function is documented. NULL for MDX functions.
HELP_CONTEXT	DBTYPE_I4	Optional. Help context ID for this function in the help file.
OBJECT	DBTYPE_ WSTR	Optional. Object, such as dimension or level, to which function applies. For example, Products.count uses the dimension Products, with "count" as the function.