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

OLAP Multiple KPI

ErrorTo run this demo, you should have data providers used for Analysis Services connections installed on your system.
See OLAP Requirements and Limitations for details.

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.

Collapse/Expand
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

Your Next Great ASP.NET App Starts Here

Get started today and download your 30-day trial of ASP.NET Controls and Libraries (includes 30 days of free technical support).
All demos ship with full source code and are included in the DevExpress ASP.NET distribution. Refer to the Demos and Sample Applications topic to learn more.

DevExpress ASP.NET Controls and Libraries ship as part of DevExpress Universal, DXperience and ASP.NET Subscriptions and are backed by a 60 day unconditional money-back guarantee.
To learn more and obtain pricing information, visit the Compare Features and Pricing webpage. For immediate assistance, contact us by Email at info@devexpress.com or by phone at +1 (818) 844-3383 between 7:30am and 4:30pm Pacific Time.