FUNCTIONS Schema Rowset

Standard Mapping

The FUNCTIONS schema rowset returns metadata that indicates which functions are available on the cubes that can be accessed by the provider. Each row in the FUNCTIONS schema rowset corresponds to one function that is available in the provider. The default sort order is ORIGIN, INTERFACE_NAME, and FUNCTION_NAME.

The following table describes the columns that are available in the FUNCTIONS schema rowset.

Standard Mapping

Column Name	Type Indicator	Mapped Value	Restrictions Supported?
FUNCTION_NAME	DBTYPE_WSTR	Name of the function.	Yes
DESCRIPTION	DBTYPE_WSTR	Description of the function.	No
PARAMETER_LIST	DBTYPE_WSTR	Comma-delimited list of parameters.	No
RETURN_TYPE	DBTYPE_14	Variable type of the return data type of the function.	No
ORIGIN	DBTYPE_14	One of the following: built-in MDX and SAS functions user-defined or external functions	Yes
INTERFACE_NAME	DBTYPE_WSTR	Name of the interface for the user-defined function, as well as the group name for the MDX functions.	Yes
LIBRARY_NAME	DBTYPE_WSTR	Name of the type library for user-defined functions.	Yes
DLL_NAME	DBTYPE_WSTR	Name of the .dll or .exe in which this function is implemented.	No
HELP_FILE	DBTYPE_WSTR	Name of the help file that documents this function.	No
HELP_CONTEXT	DBTYPE_14	Help context ID for this function in the help file.	No
OBJECT	DBTYPE_WSTR	Object to which this function applies such as a dimension or level.	No
PARAM_LIST	DBTYPE_WSTR	Comma-delimited list of parameters.	No
CAPTION	DBTYPE_WSTR	Name of the function.	Yes

Note: For more information about restrictions, see How to Restrict the Rows That Are Returned.