DevExtreme jQuery - XmlaStore Options

This section describes properties 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
data

String

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

dataType

String

The expected result's data type.

headers

Object

The request headers.

method

String

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

url

String

The request URL.

xhrFields

Object

Native XMLHttpRequest object properties.

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"
                    }
                }
            })
        });
    }
}
Vue
App.vue
   
<script>
import PivotGridDataSource from 'devextreme/ui/pivot_grid/data_source';
import XmlaStore from 'devextreme/ui/pivot_grid/xmla_store';

const 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'
            }
        }
    })
});

export default {
    // ...
    data() {
        return {
            pivotGridDataSource
        }
    }
}
</script>
React
App.js
// ...
import PivotGridDataSource from 'devextreme/ui/pivot_grid/data_source';
import XmlaStore from 'devextreme/ui/pivot_grid/xmla_store';

const 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'
            }
        }
    })
});

class App extends React.Component {
    // ...
}
export default App;

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"
            })
        });
    }
}
Vue
App.vue
   
<script>
import PivotGridDataSource from 'devextreme/ui/pivot_grid/data_source';
import XmlaStore from 'devextreme/ui/pivot_grid/xmla_store';

const pivotGridDataSource = new PivotGridDataSource({
    // ...
    store: new XmlaStore({
        url: 'https://my-web-srv01/OLAP/msmdpump.dll',
        catalog: 'AdventureWorksDW2012',
        cube: 'Adventure Works'
    })
});

export default {
    // ...
    data() {
        return {
            pivotGridDataSource
        }
    }
}
</script>
React
App.js
// ...
import PivotGridDataSource from 'devextreme/ui/pivot_grid/data_source';
import XmlaStore from 'devextreme/ui/pivot_grid/xmla_store';

const pivotGridDataSource = new PivotGridDataSource({
    // ...
    store: new XmlaStore({
        url: 'https://my-web-srv01/OLAP/msmdpump.dll',
        catalog: 'AdventureWorksDW2012',
        cube: 'Adventure Works'
    })
});

class App extends React.Component {
    // ...
}
export default App;

View Demo