9 Mar 20181 minute to read

A key performance indicator (KPI) demonstrates the progress of an enterprise when meeting its business goals.

The different indicators available in KPI are:

  • KPI Value: A physical measure or a calculated measure.
  • KPI Goal: Defines the target for the measure.
  • KPI Status: Evaluates the current status of the value compared to the goal.
  • KPI Trend: Evaluates the current trend of the value compared to the goal.

The “KpiElements” class in OLAP base library holds the KPI name, and when its object is added to an OLAP report, you can view the resultant information in the pivot grid.

  • HTML
  • <ej:pivotGrid id="PivotGrid1">
    <ej:pivotGrid-dataSource catalog="Adventure Works DW 2008 SE" cube="Adventure Works" data="//">
    <ej:pivotGrid-dataSource-row fieldName="[Date].[Fiscal]"></ej:pivotGrid-dataSource-row>
    <ej:pivotGrid-dataSource-column fieldName="[Product].[Product Categories]"></ej:pivotGrid-dataSource-column>
    <ej:pivotGrid-dataSource-value axis="columns">
    <ej:pivotGrid-dataSource-value-measure fieldName="[Measures].[Internet Sales Amount]"></ej:pivotGrid-dataSource-value-measure>
    <ej:pivotGrid-dataSource-value-measure fieldName="[Measures].[Growth in Customer Base Trend]"></ej:pivotGrid-dataSource-value-measure>