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