A Store that provides access to an OLAP cube using the XMLA standard.

Included in: dx.web.js, dx.viz-web.js, dx.all.js
Export: default


To create an XmlaStore instance, specify the URL of your OLAP server, the database name and the name of the cube whose data should be displayed by the PivotGrid widget.

var store = new DevExpress.data.XmlaStore({
    url: "http://my-web-srv01/OLAP/msmdpump.dll",
    catalog: "AdventureWorksDW2012",
    cube: "Adventure Works"

For now, XmlaStore supports only Microsoft Analysis Services. The comprehensive information about Microsoft Analysis Services OLAP tool is presented in the Multidimensional Modeling MSDN tutorial. To learn how to configure HTTP access to analysis services on IIS, refer to the Configure HTTP Access to Analysis Services on IIS 8.0 article.

When configuring a widget using ASP.NET MVC Wrappers, declare the XmlaStore using the syntax shown in the following example. This example configures the PivotGrid widget.

Razor C#
Razor VB
    .DataSource(ds => ds
        .Store(s => s.Xmla()
            .Cube("Adventure Works")
@(Html.DevExtreme().PivotGrid() _
        Return ds.Store(Function(s)
                Return s.Xmla() _
                        .Url("http://my-web-srv01/OLAP/msmdpump.dll") _
                        .Catalog("AdventureWorksDW2012") _
                        .Cube("Adventure Works")
                End Function)
    End Function)


This section describes the configuration options used to configure the XmlaStore.

Name Description

A function used to customize a web request before it is sent.


The name of the database associated with the Store.


The cube name.


The HTTP address to an XMLA OLAP server.