ACTIONS Rowset

The ACTIONS schema rowset allows OLAP tools to be easily integrated with other applications by providing descriptive and content information to perform the action. The following table describes the available columns in the ACTIONS schema rowset. (The default sort order is CATALOG_NAME, SCHEMA_NAME, and CUBE_NAME.)

Column name	Type indicator	Description
CATALOG_NAME	DBTYPE_WSTR	Optional. The catalog name.
SCHEMA_NAME	DBTYPE_WSTR	Optional. The name of the schema to which this cube belongs. NULL if the provider does not support schemas.
CUBE_NAME	DBTYPE_WSTR	Required. Name of the cube.
ACTION_NAME	DBTYPE_WSTR	Optional. The action name. This column value should not be changed and usually is not presented to users.
ACTION_TYPE	DBTYPE_WSTR	Optional. One of the enumerated action types.
COORDINATE	DBTYPE_WSTR	Required. A string indicating the "coordinate" of the action. Its format is dependent on COORDINATE_TYPE. Generally used as a restriction when querying for the actions available on a particular object.
COORDINATE_TYPE	DBTYPE_UI4	Required. One of the following: MDACTION_COORDINATE_CUBE MDACTION_COORDINATE_DIMENSION MDACTION_COORDINATE_LEVEL MDACTION_COORDINATE_MEMBER MDACTION_COORDINATE_SET MDACTION_COORDINATE_CELL The format of COORDINATE is determined by this value.
CAPTION	DBTYPE_WSTR	Optional. The friendly name for the action. Will be presented to users and can be localized.
DESCRIPTION	DBTYPE_WSTR	Optional. A description of the action. Will be presented to users and can be localized.
CONTENT	DBTYPE_WSTR	Optional. The string containing the action. Its meaning is dependent on the action type.
APPLICATION	DBTYPE_WSTR	Optional. The application "name." This is a loosely defined field that might be useful in the following circumstances: Distinguishing proprietary actions Logically grouping actions for presentation to the user The APPLICATION column should not be interpreted to contain a path name.