OLAP Cube

• Dec 25, 2023

An OLAP cube is a multi-dimensional dataset that allows data mining and analysis. DevExtreme provides the PivotGrid control to display data from an OLAP cube. You can call the DataSource() method as shown in the following code to access the OLAP cube. The lambda expression passed to this method configures the XmlaStore data store.

Razor C#

@(Html.DevExtreme().PivotGrid()
    .DataSource(ds => ds
        .Store(s => s
            .Xmla()
            .Url("http://my-web-srv01/OLAP/msmdpump.dll")
            .Catalog("AdventureWorksDW2012")
            .Cube("Adventure Works")
        )
    )
)

Razor VB

@(Html.DevExtreme().PivotGrid() _
    .DataSource(Function(ds) ds _
        .Store(Function(s) s _
            .Xmla() _
            .Url("http://my-web-srv01/OLAP/msmdpump.dll") _
            .Catalog("AdventureWorksDW2012") _
            .Cube("Adventure Works")
        )
    )
)

View Demo