XmlaStore

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
Type: Object

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.

JavaScript
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.

Start Tutorial

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
@(Html.DevExtreme().PivotGrid()
    .DataSource(ds => ds
        .Store(s => s.Xmla()
            .Url("http://my-web-srv01/OLAP/msmdpump.dll")
            .Catalog("AdventureWorksDW2012")
            .Cube("Adventure Works")
        )
    )
)
@(Html.DevExtreme().PivotGrid() _
    .DataSource(Function(ds)
        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)
)

Configuration

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