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
The GetOLAPKPIList method
is used to obtain the list of KPIs defined in the OLAP cube. KPI values are obtained using the
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
Individual KPI images can be obtained via the
Note: To use KPI images, the ASPxPivotGrid object must exist in the controls hierarchy on the page.