Configuration

This section describes options that configure the XmlaStore.

beforeSend

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

Type:

Function

Function parameters:
options:

Object

The request parameters. When jQuery is used, this object can contain jQuery.ajax()-supported fields.

Object structure:
url:

String

The request URL.

method:

String

The request method ("GET", "POST", "PATCH", or "MERGE").

headers:

Object

The request headers.

xhrFields:

Object

data:

String

A query string that contains data to be sent to the server.

dataType:

String

The expected result's data type.

jQuery
JavaScript
var store = new DevExpress.data.XmlaStore({
    url: "https://my-web-srv01/OLAP/msmdpump.dll",
    catalog: "AdventureWorksDW2012",
    cube: "Adventure Works",
    beforeSend: function (e) {  
        e.headers = {
            "Custom Header": "value"
        };
    }
});

var pivotGridDataSource = new DevExpress.data.PivotGridDataSource({
    // ...
    store: store
});
Angular
TypeScript
import PivotGridDataSource from "devextreme/ui/pivot_grid/data_source";
import XmlaStore from "devextreme/ui/pivot_grid/xmla_store";
// ...
export class AppComponent {
    pivotGridDataSource: PivotGridDataSource;
    constructor() {
        this.pivotGridDataSource = new PivotGridDataSource({
            // ...
            store: new XmlaStore({
                url: "https://my-web-srv01/OLAP/msmdpump.dll",
                catalog: "AdventureWorksDW2012",
                cube: "Adventure Works",
                beforeSend: (e) => {
                    e.headers = {
                        "Custom Header": "value"
                    }
                }
            })
        });
    }
}

catalog

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

Type:

String

cube

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

Type:

String

url

Specifies the OLAP server's URL.

Type:

String

This should be the MSMDPUMP.dll URL and usually has the following format: http://<servername>/OLAP/msmdpump.dll.

jQuery
JavaScript
var store = new DevExpress.data.XmlaStore({
    url: "https://my-web-srv01/OLAP/msmdpump.dll",
    catalog: "AdventureWorksDW2012",
    cube: "Adventure Works"
});

var pivotGridDataSource = new DevExpress.data.PivotGridDataSource({
    // ...
    store: store
});
Angular
TypeScript
import PivotGridDataSource from "devextreme/ui/pivot_grid/data_source";
import XmlaStore from "devextreme/ui/pivot_grid/xmla_store";
// ...
export class AppComponent {
    pivotGridDataSource: PivotGridDataSource;
    constructor() {
        this.pivotGridDataSource = new PivotGridDataSource({
            // ...
            store: new XmlaStore({
                url: "https://my-web-srv01/OLAP/msmdpump.dll",
                catalog: "AdventureWorksDW2012",
                cube: "Adventure Works"
            })
        });
    }
}