Kpi Element (ASSL)

 

Applies To: SQL Server 2016 Preview

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

  
<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>  

CharacteristicDescription
Data type and lengthSee the table below.
Default valueNone
Cardinality0-n: Optional element that can occur more than once.
Ancestor or ParentData Type
CubeNone
PerspectivePerspectiveKpi
RelationshipElement
Parent elementsKpis
Child elementsSee the table below.
Ancestor or ParentChild elements
CubeAnnotations, AssociatedMeasureGroupID, CurrentTimeMember, Description, DisplayFolder, Goal, ID, Name, Status, StatusGraphic, Translations, Trend, TrendGraphic, Value
PerspectiveNone

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

Objects (ASSL)

Community Additions

ADD
Show: