KPI in EJ 1 ASP.NET Core PivotClient
24 May 2019 / 2 minutes to read
Key Performance Indicators (KPI) are business metrics that help to figure out 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 the 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 client. You can enable the KPI in pivot client by setting the
enable-kpi property to true.
<ej-pivot-client id="PivotClient1" title="OLAP Browser" enable-kpi="true"> <e-data-source catalog="Adventure Works DW 2008 SE" cube="Adventure Works" data="//bi.syncfusion.com/olap/msmdpump.dll"> <e-pivot-rows> <e-row-field field-name="[Customer].[Customer Geography]"></e-row-field> </e-pivot-rows> <e-pivot-columns> <e-column-field field-name="[Product].[Product Categories]"></e-column-field> </e-pivot-columns> <e-pivot-values> <e-value-field axis="Column"> <e-measures> <e-measure-items field-name="[Measures].[Internet Sales Amount]"></e-measure-items> <e-measure-items field-name="[Measures].[Growth in Customer Base Trend]"></e-measure-items> <e-measure-items field-name="[Measures].[Growth in Customer Base Status]"></e-measure-items> </e-measures> </e-value-field> </e-pivot-values> </e-data-source> </ej-pivot-client>