DevExtreme jQuery/JS - OLAP Cube

An OLAP cube is a multi-dimensional dataset that allows data mining and analysis. DevExtreme provides the PivotGrid UI component to display data from an OLAP cube.

To access an OLAP cube, implement the XmlaStore: specify the OLAP server's url, the catalog that contains the OLAP cube that you access, and the cube.

Wrap the XmlaStore into a PivotGridDataSource. This component enables you to group, sort, filter, and perform other data shaping operations on the store's data. Bind the PivotGrid to this PivotGridDataSource:

index.js
  • $(function() {
  • var adventureWorksStore = new DevExpress.data.XmlaStore({
  • url: "https://my-web-srv01/OLAP/msmdpump.dll",
  • catalog: "AdventureWorksDW2012",
  • cube: "Adventure Works"
  • });
  •  
  • var adventureWorksDataSource = new DevExpress.data.PivotGridDataSource({
  • store: adventureWorksStore
  • });
  •  
  • $("#pivotGridContainer").dxPivotGrid({
  • dataSource: adventureWorksDataSource
  • });
  • });