APPLIES TO:SQL Server Analysis ServicesAzure Analysis Services
Describes the key performance indicators (KPIs) within a database.
The MDSCHEMA_KPIS rowset contains the following columns.
|Column name||Type indicator||Description|
|CATALOG_NAME||DBTYPE_WSTR||The source database.|
|CUBE_NAME||DBTYPE_WSTR||The parent cube for the KPI.|
|MEASUREGROUP_NAME||DBTYPE_WSTR||The associated measure group for the KPI.
You can use this column to determine the dimensionality of the KPI. If "<NULL>", the KPI will be dimensioned by all measure groups.
The default value is "<NULL>".
|KPI_NAME||DBTYPE_WSTR||The name of the KPI.|
|KPI_CAPTION||DBTYPE_WSTR||A label or caption associated with the KPI. Used primarily for display purposes. If a caption does not exist, KPI_NAME is returned.|
|KPI_DESCRIPTION||DBTYPE_WSTR||A human-readable description of the KPI.|
|KPI_DISPLAY_FOLDER||DBTYPE_WSTR||A string that identifies the path of the display folder that the client application uses to show the member. The folder level separator is defined by the client application. For the tools and clients supplied by Analysis Services, the backslash (\) is the level separator. To provide multiple display folders, use a semicolon (;) to separate the folders.|
|KPI_VALUE||DBTYPE_WSTR||The unique name of the member in the measures dimension for the KPI Value.|
|KPI_GOAL||DBTYPE_WSTR||The unique name of the member in the measures dimension for the KPI Goal.
Returns NULL if there is no Goal defined.
|KPI_STATUS||DBTYPE_WSTR||The unique name of the member in the measures dimension for the KPI Status.
Returns NULL if there is no Status defined.
|KPI_TREND||DBTYPE_WSTR||The unique name of the member in the measures dimension for the KPI Trend.
Returns NULL if there is no Trend defined.
|KPI_STATUS_GRAPHIC||DBTYPE_WSTR||The default graphical representation of the KPI.|
|KPI_TREND_GRAPHIC||DBTYPE_WSTR||The default graphical representation of the KPI.|
|KPI_WEIGHT||DBTYPE_WSTR||The unique name of the member in the measures dimension for the KPI Weight.|
|KPI_CURRENT_TIME_MEMBER||DBTYPE_WSTR||The unique name of the member in the time dimension that defines the temporal context of the KPI.
Returns NULL if there is no Time member defined.
|KPI_PARENT_KPI_NAME||DBTYPE_WSTR||The name of the parent KPI.|
|SCOPE||DBTYPE_I4||The scope of the KPI. The KPI can be a session KPI or global KPI.
This column can have one of the following values:
|ANNOTATIONS||DBTYPE_WSTR||(Optional) A set of notes, in XML format.|
This schema rowset is not sorted.
The MDSCHEMA_KPIS rowset can be restricted on the columns listed in the following table.
|Column name||Type indicator||Restriction State|
|CUBE_SOURCE||DBTYPE_UI2||(Optional) Default restriction is a value of 1. A bitmap with one of the following valid values: