OLAP Data Source

Documentation

The PivotGrid supports OLAP services (MS SQL Server Analysis Services). This allows you to deliver solutions that can easily analyze millions of data rows within your app. In this demo, the PivotGrid uses XmlaStore to connect the widget to a sample remote OLAP service. The Field Chooser is configured to show the search box to speed up choosing the required field.

See more Hide details

Prev Demo Next Demo

Was this demo helpful?

Thank you!

Send Feedback

Thank you!
We appreciate your feedback.

jQuery

Angular

Vue

React

AngularJS

ASP.NET Core

ASP.NET MVC

<div class="long-title"><h3>Sales Statistics</h3></div> @(Html.DevExtreme().PivotGrid() .AllowSortingBySummary(true) .AllowSorting(true) .AllowFiltering(true) .AllowExpandAll(true) .Height(570) .ShowBorders(true) .Export(e => e.Enabled(true).FileName("Adventure Works")) .FieldChooser(fc => fc.AllowSearch(true)) .DataSource(d => d .Fields(fields => { fields.Add() .DataField("[Product].[Category]") .Area(PivotGridArea.Row); fields.Add() .DataField("[Product].[Subcategory]") .Area(PivotGridArea.Row) .HeaderFilter(hf => hf.AllowSearch(true)); fields.Add() .DataField("[Ship Date].[Calendar Year]") .Area(PivotGridArea.Column); fields.Add() .DataField("[Ship Date].[Month of Year]") .Area(PivotGridArea.Column); fields.Add() .DataField("[Measures].[Customer Count]") .Area(PivotGridArea.Data); }) .Store(s => s.Xmla() .Url("https://demos.devexpress.com/Services/OLAP/msmdpump.dll") .Catalog("Adventure Works DW Standard Edition") .Cube("Adventure Works") ) ) )

using DevExtreme.MVC.Demos.Models.SampleData; using Newtonsoft.Json; using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Mvc; namespace DevExtreme.MVC.Demos.Controllers { public class PivotGridController : Controller { public ActionResult OLAPDataSource() { return View(); } } }

.long-title h3 { font-family: 'Segoe UI Light', 'Helvetica Neue Light', 'Segoe UI', 'Helvetica Neue', 'Trebuchet MS', Verdana; font-weight: 200; font-size: 28px; text-align: center; margin-bottom: 20px; }