DevExtreme Angular - 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-angular/ui/xmla-store"
Type: DxXmlaStoreTypes.default

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

TypeScript
  • import XmlaStore from "devextreme/ui/pivot_grid/xmla_store";
  • import PivotGridDataSource from "devextreme/ui/pivot_grid/data_source";
  • // ...
  • export class AppComponent {
  • store: XmlaStore;
  • pivotGridDataSource: PivotGridDataSource;
  • constructor () {
  • this.store = new XmlaStore({
  • url: "http://my-web-srv01/OLAP/msmdpump.dll",
  • catalog: "AdventureWorksDW2012",
  • cube: "Adventure Works"
  • });
  •  
  • // ===== or inside the PivotGridDataSource =====
  • this.pivotGridDataSource = new PivotGridDataSource({
  • store: {
  • type: "xmla",
  • url: "http://my-web-srv01/OLAP/msmdpump.dll",
  • catalog: "AdventureWorksDW2012",
  • cube: "Adventure Works"
  • },
  • // Other PivotGridDataSource options go here
  • });
  • }
  • }

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.

See Also

Properties

This section describes options 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.