Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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. |