Kpi Element (ASSL)

Defines a key performance indicator (KPI) within a Cube element or a Perspective element.

Syntax

<Kpis>
   <Kpi> <!-- ancestor: Cube -->
            <Name>...</Name>
      <ID>...</ID>
      <Description>...</Description>
      <Translations>...</Translations>
      <DisplayFolder>...</DisplayFolder>
      <AssociatedMeasureGroupID>...</AssociatedMeasureGroupID>
      <Value>...</Value>
            <Goal>...</Goal>
      <Status>...</Status>
      <Trend>...</Trend>
      <TrendGraphic>...</TrendGraphic>
      <StatusGraphic>...</StatusGraphic>
      <CurrentTimeMember>...</CurrentTimeMember>
      <Annotations>...</Annotations>
   </Kpi>
   <!-- or -->
   <Kpi xsi:type="PerspectiveKpi">...</Kpi> <!-- ancestor: Perspective -->
   </Kpi>
</Kpis>

Element Characteristics

Characteristic

Description

Data type and length

Ancestor or Parent

Data Type

CubeNone

PerspectivePerspectiveKpi

Default value

None

Cardinality

0-n: Optional element that can occur more than once.

Element Relationships

Relationship

Element

Parent elements

Kpis

Child elements

Ancestor or Parent

Child elements

CubeAnnotations, AssociatedMeasureGroupID, CurrentTimeMember, Description, DisplayFolder, Goal, ID, Name, Status, StatusGraphic, Translations, Trend, TrendGraphic, Value

PerspectiveNone

Remarks

The corresponding elements in the Analysis Management Objects (AMO) object model are Kpi and PerspectiveKpi.

See Also

Reference

Objects (ASSL)

Help and Information

Getting SQL Server 2005 Assistance