Share via


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.