Analysis Services Programming
MDSCHEMA_FUNCTIONS
This schema rowset describes the functions that are available to client applications connected to the database.
Microsoft® SQL Server™ 2000 Analysis Services extends the OLE DB specification with the addition of the following columns to this schema rowset.
| Column name | Type | Description |
|---|---|---|
| FUNCTION_NAME | DBTYPE_WSTR | The name of the function. |
| DESCRIPTION | DBTYPE_WSTR | A user-friendly description of the function. |
| PARAMETER_LIST | DBTYPE_WSTR | Reserved for future use. |
| RETURN_TYPE | DBTYPE_I4 | The VARTYPE of the return data type of the function. |
| ORIGIN | DBTYPE_I4 | For Multidimensional Expressions (MDX) functions, returns MSMD_SCHEMA_FUNCTIONS_ORIGIN_MSOLAP. For user-defined functions, returns MSMD_FUNCTIONS_ORIGIN_UDF. |
| INTERFACE_NAME | DBTYPE_WSTR | The name of the interface for user-defined functions and the group name for the MDX functions. |
| LIBRARY_NAME | DBTYPE_WSTR | (Optional.) For user-defined functions, returns the name of the type library. For MDX functions, returns VT_NULL. |
| DLL_NAME | DBTYPE_WSTR | (Optional.) For user-defined functions, this column contains the name of the .dll or .exe file in which a function is implemented. For MDX functions, it contains VT_NULL. |
| HELP_FILE | DBTYPE_WSTR | (Optional.) Contains the name of the file that contains this function's documentation. For MDX functions, it returns VT_NULL . |
| HELP_CONTEXT | DBTYPE_WSTR | (Optional.) Returns the Help context ID for this function. |
| OBJECT | DBTYPE_WSTR | (Optional). The generic name of the object class to which a function applies. For example, the rowset for the <Level_Name>.Members function returns "Level". This column contains VT_NULL if the function is a user-defined function or if it is not a property. |
The default sort order for this schema rowset is ORIGIN, INTERFACE_NAME, and FUNCTION_NAME.
Restriction Columns
LIBRARY_NAME
INTERFACE_NAME
FUNCTION_NAME
ORIGIN