Show theme settings Shopping cart Download trialFree Trial
Change Theme Settings
Change Theme Settings
Show All Themes

OLAP Multiple KPI

KPI Name Value Goal Status Trend
Internet Revenue$29,358,677.22$29,358,677.22NeutralNo Change

This demo demonstrates how to obtain OLAP KPI values from the server and display them outside the ASPxPivotGrid control in a table.

In this demo, we have created an invisible ASPxPivotGrid object. The GetOLAPKPIList method is used to obtain the list of KPIs defined in the OLAP cube. KPI values are obtained using the GetOLAPKPIValue method. Finally we display these values in a table.

Since KPI supports graphic representation for its Status and Trend values, we replaced these values with images. OLAP supports 12 graphic sets such as shapes, smiley faces, traffic lights, etc. In this demo, we display images defined on the server. To get these images, call the GetOLAPKPIServerGraphic method. Individual KPI images can be obtained via the GetKPIImage method.

Note: To use KPI images, the ASPxPivotGrid object must exist in the controls hierarchy on the page.

Local Copy of this Demo
To inspect the source code for this demo on your machine, you must first install our components via the DevExpress Component Installer.
You can open a local copy of this online demo directly from this webpage (if using v20.2.8, 21.1.4 or higher).
Open CS Solution
Open VB Solution
The source code files for this demo are installed (by default) in the following directories:
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\CS\ASPxPivotGridDemos
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\VB\ASPxPivotGridDemos