PivotGrid HtmlHelper Overview

The Telerik UI PivotGrid HtmlHelper for ASP.NET Core is a server-side wrapper for the Kendo UI PivotGrid widget.

The PivotGrid represents multidimensional data in a cross-tabular format.

Getting Started

The PivotGrid for ASP.NET Core supports Ajax data-binding to HTTP accessible OLAP cube. For more information on the OLAP concepts, refer to the Kendo UI for jQuery articles on:

Kendo UI for jQuery provides an OLAP service dll that can be used for testing and is hosted at https://demos.telerik.com/olap/msmdpump.dll. To see the responses, the service needs to be queried and cannot be opened directly in the browser.

The PivotGrid for ASP.NET Core also supports Ajax data-binding to flat data. It creates a client-side cube which allows the categorization of the flat data. For runnable examples, refer to:

Basic Configuration

The following examples demonstrate how to configure the PivotGrid for ASP.NET Core for Ajax binding to an Adventure Works cube that is hosted on https://demos.telerik.com/olap/msmdpump.dll.

  1. Create a new ASP.NET Core application. If you have the Telerik UI for ASP.NET Core Visual Studio Extensions installed, create a Telerik UI for ASP.NET Core application. Name the application KendoPivotGrid. If you decide not to use the Telerik UI for ASP.NET Core Visual Studio Extensions, follow the steps from the introductory article to add Telerik UI for ASP.NET Core to the application.
  2. Add a PivotGrid to the Index view.

        @(Html.Kendo().PivotGrid()
            .Name("pivotgrid")
            .DataSource(dataSource => dataSource.
                Xmla()
                .Columns(columns => {
                    columns.Add("[Date].[Calendar]").Expand(true);
                    columns.Add("[Geography].[City]");
                })
                .Rows(rows => rows.Add("[Product].[Product]"))
                .Measures(measures => measures.Values(new string[]{"[Measures].[Internet Sales Amount]"}))
                .Transport(transport => transport
                    .Connection(connection => connection
                        .Catalog("Adventure Works DW 2008R2")
                        .Cube("Adventure Works"))
                    .Read(read => read
                        .Url("https://demos.telerik.com/olap/msmdpump.dll")
                        .DataType("text")
                        .ContentType("text/xml")
                        .Type(HttpVerbs.Post)
                    )
                )
            )
        )
    
  3. Build and run the application.

See Also

In this article
Not finding the help you need? Improve this article