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.vue
  • <template>
  • <DxPivotGrid
  • :data-source="adventureWorksDataSource"
  • />
  • </template>
  •  
  • <script>
  • import 'devextreme/dist/css/dx.light.css';
  •  
  • import DxPivotGrid from 'devextreme-vue/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
  • });
  •  
  • export default {
  • components: {
  • DxPivotGrid
  • },
  • data() {
  • return {
  • adventureWorksDataSource
  • }
  • }
  • }
  • </script>