ACTIONS Rowset

  • Article

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.