DevExtreme React - XmlaStore API

The XmlaStore is a store that provides an interface for accessing an OLAP cube according to the XMLA standard.

import XmlaStore from "devextreme-react/xmla-store"

The XmlaStore is used in the PivotGridDataSource which, in turn, is used in the PivotGrid UI component.

App.js
  • // ...
  • import XmlaStore from 'devextreme/ui/pivot_grid/xmla_store';
  • import PivotGridDataSource from 'devextreme/ui/pivot_grid/data_source';
  •  
  • const store = new XmlaStore({
  • url: 'http://my-web-srv01/OLAP/msmdpump.dll',
  • catalog: 'AdventureWorksDW2012',
  • cube: 'Adventure Works'
  • });
  •  
  • // ===== or inside the PivotGridDataSource =====
  • const pivotGridDataSource = new PivotGridDataSource({
  • store: {
  • type: 'xmla',
  • url: 'http://my-web-srv01/OLAP/msmdpump.dll',
  • catalog: 'AdventureWorksDW2012',
  • cube: 'Adventure Works'
  • },
  • // Other PivotGridDataSource properties go here
  • });
  •  
  • class App extends React.Component {
  • // ...
  • }
  • export default App;

The XmlaStore currently supports only the Microsoft Analysis Services OLAP tool. Refer to the Multidimensional Modeling tutorial for more information on it. To learn how to configure HTTP access to Analysis Services on IIS, see this article.

NOTE
The XmlaStore is immutable. You cannot change its configuration at runtime. However, you can use its methods to manipulate it.

Props

This section describes properties that configure the XmlaStore.

Name Description
beforeSend

Specifies a function that customizes the request before it is sent to the server.

catalog

Specifies the database (or initial catalog) that contains the OLAP cube to use.

cube

Specifies the name of the OLAP cube to use from the catalog.

url

Specifies the OLAP server's URL.