DevExtreme React - 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:

App.js
  • import React from 'react';
  •  
  • import 'devextreme/dist/css/dx.light.css';
  •  
  • import PivotGrid from 'devextreme-react/pivot-grid';
  • import XmlaStore from 'devextreme/ui/pivot_grid/xmla_store';
  • import PivotGridDataSource from 'devextreme/ui/pivot_grid/data_source';
  •  
  • const adventureWorksStore = new XmlaStore({
  • url: 'https://my-web-srv01/OLAP/msmdpump.dll',
  • catalog: 'AdventureWorksDW2012',
  • cube: 'Adventure Works'
  • });
  •  
  • const adventureWorksDataSource = new PivotGridDataSource({
  • store: adventureWorksStore
  • });
  •  
  • class App extends React.Component {
  • render() {
  • return (
  • <PivotGrid
  • dataSource={adventureWorksDataSource}
  • />
  • );
  • }
  • }
  • export default App;