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>
Feel free to share topic-related thoughts here.
If you have technical questions, please create a support ticket in the DevExpress Support Center.
Thank you for the feedback!
If you have technical questions, please create a support ticket in the DevExpress Support Center.