DevExtreme jQuery - XmlaStore Options

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:
Name Type Description
url

String

The request URL.
method

String

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

Object

The request headers.
xhrFields

Object

Native XMLHttpRequest object properties.
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

See Also

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"
            })
        });
    }
}