3.1.4.2.2.1.3.15.1 Columns

The MDSCHEMA_KPIS 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.<250>

CUBE_NAME

xsd:string

Yes

The parent cube for the KPI.

MEASUREGROUP_NAME

xsd:string

The associated measure group for the KPI.

KPI_NAME

xsd:string

Yes

The name of the KPI.

KPI_CAPTION

xsd:string

A label or caption associated with the KPI.

KPI_DESCRIPTION

xsd:string

A description of the KPI.

KPI_DISPLAY_FOLDER

xsd:string

The display folder.

KPI_VALUE

xsd:string

The unique name of the member in the measures dimension for the KPI value.

KPI_GOAL

xsd:string

The unique name of the member in the measures dimension for the KPI goal.

KPI_STATUS

xsd:string

The unique name of the member in the measures dimension for the KPI status.

KPI_TREND

xsd:string

The unique name of the member in the measures dimension for the KPI trend.

KPI_STATUS_GRAPHIC

xsd:string

The default graphical representation of the KPI status.

KPI_TREND_GRAPHIC

xsd:string

The default graphical representation of the KPI trend.

KPI_WEIGHT

xsd:string

The unique name of the member in the measures dimension for the KPI weight.

KPI_CURRENT_TIME_MEMBER

xsd:string

The unique name of the member in the time dimension that defines the temporal context of the KPI.

KPI_PARENT_KPI_NAME

xsd:string

The name of the parent KPI.

ANNOTATIONS

xsd:string

The annotations on the KPI.

SCOPE

xsd:int

The scope of the KPI. The KPI can be a session KPI or global KPI.

This column can have one of the following values:

  • MDKPI_SCOPE_GLOBAL(1) – Global KPI

  • MDKPI_SCOPE_SESSION(2) – Session based KPI

This schema rowset is not sorted.

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="MEASUREGROUP_NAME" name="MEASUREGROUP_NAME" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="KPI_NAME" name="KPI_NAME" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="KPI_CAPTION" name="KPI_CAPTION" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="KPI_DESCRIPTION" name="KPI_DESCRIPTION" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="KPI_DISPLAY_FOLDER" name="KPI_DISPLAY_FOLDER"
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="KPI_VALUE" name="KPI_VALUE" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="KPI_GOAL" name="KPI_GOAL" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="KPI_STATUS" name="KPI_STATUS" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="KPI_TREND" name="KPI_TREND" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="KPI_STATUS_GRAPHIC" name="KPI_STATUS_GRAPHIC" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="KPI_TREND_GRAPHIC" name="KPI_TREND_GRAPHIC" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="KPI_WEIGHT" name="KPI_WEIGHT" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="KPI_CURRENT_TIME_MEMBER" name="KPI_CURRENT_TIME_MEMBER" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="KPI_PARENT_KPI_NAME" name="KPI_PARENT_KPI_NAME" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="ANNOTATIONS" name="ANNOTATIONS" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="SCOPE" name="SCOPE" type="xsd:int" minOccurs="0" />
         </xsd:sequence>
       </xsd:complexType>