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:
- 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;
If you have technical questions, please create a support ticket in the DevExpress Support Center.