The MDSCHEMA_ACTIONS rowset contains the following columns.
|
Column name
|
Type indicator
|
Length
|
Description
|
|---|
|
CATALOG_NAME
|
DBTYPE_WSTR
|
|
The name of the database.
|
|
SCHEMA_NAME
|
DBTYPE_WSTR
|
|
Not supported. Always contains VT_NULL.
|
|
CUBE_NAME
|
DBTYPE_WSTR
|
|
The name of the cube to which this action belongs.
|
|
ACTION_NAME
|
DBTYPE_WSTR
|
|
The name of this action.
|
|
ACTION_TYPE
|
DBTYPE_I4
|
|
A bitmap that is used to specify the action's triggering method. The Msmd.h file defines the following bit value constants for this bitmap:
-
MDACTION_TYPE_URL (0x01)
-
MDACTION_TYPE_HTML (0x02)
-
MDACTION_TYPE_STATEMENT (0x04)
-
MDACTION_TYPE_DATASET (0x08)
-
MDACTION_TYPE_ROWSET (0x10)
-
MDACTION_TYPE_COMMANDLINE (0x20)
-
MDACTION_TYPE_PROPRIETARY (0x40)
-
MDACTION_TYPE_REPORT (0x80)
-
MDACTION_TYPE_DRILLTHROUGH (0x100)
|
|
COORDINATE
|
DBTYPE_WSTR
|
|
A Multidimensional Expressions (MDX) expression that specifies an object or a coordinate in the multidimensional space in which the action is performed. It is the responsibility of the client application to provide the value of this restriction column.
The CORDINATE must resolve to the object specified in COORDINATE_TYPE.
|
|
COORDINATE_TYPE
|
DBTYPE_I4
|
|
A bitmap that specifies how the COORDINATE restriction column is interpreted. The Msmd.h file defines the following bit value constants for this bitmap:
-
MDACTION_COORDINATE_CUBE (1)
-
MDACTION_COORDINATE_DIMENSION (2)
refers to the dimensions hierarchies.
-
MDACTION_COORDINATE_LEVEL (3)
-
MDACTION_COORDINATE_MEMBER (4)
-
MDACTION_COORDINATE_SET (5)
-
MDACTION_COORDINATE_CELL (6)
|
|
ACTION_CAPTION
|
DBTYPE_WSTR
|
|
The action name if no caption was specified and no translations were specified in the DDL.
If a caption or translations were specified, and CaptionIsMDX is false, one of the following strings:
-
The translation for the appropriate language.
-
The specified caption if no translation was found for the specified language.
-
The action name if no translation was found and the caption was not specified in DDL.
If a caption or translations were specified, and CaptionIsMDX is true, the string resulting from finding the appropriate translation for the specified language or the specified translation in the DDL caption, and calculating the formula to create the string.
If the action was specified in MDX Script, there are no translations and the caption is always treated as MDX expression.
|
|
DESCRIPTION
|
DBTYPE_WSTR
|
|
A user-friendly description of the action.
|
|
CONTENT
|
DBTYPE_WSTR
|
|
The expression or content of the action that is to be run.
|
|
APPLICATION
|
DBTYPE_WSTR
|
|
The name of the application that is to be used to run the action.
|
|
INVOCATION
|
DBTYPE_I4
|
|
Information about how the action should be invoked:
-
MDACTION_INVOCATION_INTERACTIVE (1) indicates a regular action used during normal operations. This is the default value for this column.
-
MDACTION_INVOCATION_ON_OPEN (2) indicates that the action should be performed when the cube is first opened.
-
MDACTION_INVOCATION_BATCH (4) indicates that the action is performed as part of a batch operation or Microsoft SQL Server Integration Services task.
These enumeration values are defined in the file, Msmd.h.
|
The rowset is sorted on CATALOG_NAME, SCHEMA_NAME, CUBE_NAME, ACTION_NAME.
.gif) Note: |
|---|
|
Actions of MDACTION_TYPE_PROPRIETARY type must provide a value for the APPLICATION column.
|