3.1.4.2.2.1.3.12.1 Columns

The MDSCHEMA_ACTIONS rowset contains the following columns.

Name

Type

Restriction

Description

CATALOG_NAME

xsd:string

Yes

The name of the database.

SCHEMA_NAME

xsd:string

Yes

The name of the schema.<246>

CUBE_NAME

xsd:string

[Required]

The name of the cube.

ACTION_NAME

xsd:string

Yes

The name of this action.

ACTION_TYPE

xsd:int

Yes

A bitmask that is used to specify the action type.

  • 0x01 - Action type is URL

  • 0x02 - Action type is HTML.

  • 0x04 - Action type is Statement.

  • 0x08 - Action type is Dataset.

  • 0x10 - Action type is Rowset.

  • 0x20 - Action type is Commandline.

  • 0x40 - Action type is Proprietary.

  • 0x80 - Action type is Report.

  • 0x100 - Action type is DrillThrough.

If the action is PROPRIETARY (0x40), then a value MUST be provided in the APPLICATION column.

COORDINATE

xsd:string

[Required]

An MDX expression that specifies an object or a coordinate in the multidimensional space in which the action is performed. The COORDINATE MUST resolve to the object specified in COORDINATE_TYPE.

COORDINATE_TYPE

xsd:int

[Required]

An enumeration that specifies how the COORDINATE restriction column is interpreted. The possible values are as follows:

  • 1 - Action coordinate refers to the cube.

  • 2 - Action coordinate refers to a dimension.

  • 3 - Action coordinate refers to a level.

  • 4 - Action coordinate refers to a member.

  • 5 - Action coordinate refers to a set.

  • 6 - Action coordinate refers to a cell.

ACTION_CAPTION

xsd:string

The caption for the action. The action name is used if no caption was specified and no translations were specified when the action was created or altered.

DESCRIPTION

xsd:string

A description of the action.

CONTENT

xsd:string

The expression or content of the action that is to be run.

APPLICATION

xsd:string

The name of the application that is to be used to run the action.

INVOCATION

xsd:int

Yes

Information about how to invoke the action:

  • 1 - Indicates a regular action used during normal operations. This is the default value for this column.

  • 2 - Indicates that the action is performed when the cube is first opened.

  • 4 - Indicates that the action is performed as part of a batch operation.

The rowset is sorted on CATALOG_NAME, CUBE_NAME, ACTION_NAME.

The response has the following definition.

       <xsd:element name="root">
         <xsd:complexType>
           <xsd:sequence minOccurs="0" maxOccurs="unbounded">
             <xsd:element name="row" type="row" />
           </xsd:sequence>
         </xsd:complexType>
       </xsd:element>
       <xsd:complexType name="row">
         <xsd:sequence>
           <xsd:element sql:field="CATALOG_NAME" name="CATALOG_NAME" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="SCHEMA_NAME" name="SCHEMA_NAME" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="CUBE_NAME" name="CUBE_NAME" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="ACTION_NAME" name="ACTION_NAME" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="ACTION_TYPE" name="ACTION_TYPE" 
                            type="xsd:int" minOccurs="0" />
           <xsd:element sql:field="COORDINATE" name="COORDINATE" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="COORDINATE_TYPE" name="COORDINATE_TYPE" 
                            type="xsd:int" minOccurs="0" />
           <xsd:element sql:field="ACTION_CAPTION" name="ACTION_CAPTION" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="DESCRIPTION" name="DESCRIPTION" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="CONTENT" name="CONTENT" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="APPLICATION" name="APPLICATION" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="INVOCATION" name="INVOCATION" 
                            type="xsd:int" minOccurs="0" />
         </xsd:sequence>
       </xsd:complexType>