XmlaStore

A Store that provides access to an OLAP cube according to 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 your OLAP server's URL, the database name and the name of the cube whose data the PivotGrid widget should display.

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

The XmlaStore currently supports only Microsoft Analysis Services. Refer to the Multidimensional Modeling MSDN tutorial for comprehensive information about Microsoft Analysis Services OLAP tool. 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 using a widget as an ASP.NET MVC Control, 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.