PivotConfigurator Overview

The Kendo UI PivotConfigurator represents an OLAP cube structure and can be used to configure the column and row dimensions along with the measures fields of the PivotGrid.

It is a supplementary widget, which is strongly related to the Kendo UI PivotDataSource component.

Getting Started

Initialize the PivotConfigurator

The following sections demonstrate how to initialize the PivotConfigurator and link it to the PivotGrid.

To create the PivotConfigurator, define a <div> HTML element.

    <!-- Define the HTML div that will hold the PivotConfigurator -->
    <div id="pivotconfigurator">

    <!-- Define the HTML div that will hold the PivotGrid -->
    <div id="pivotgrid">

The following example demonstrates how to further configure the PivotConfigurator.

    $(document).ready(function () {

            configurator: "#pivotconfigurator", //specify the ID of the configurator widget
            height: 550,
            dataSource: {
                type: "xmla",
                transport: {
                    connection: {
                        catalog: "Adventure Works DW 2008R2",
                        cube: "Adventure Works"
                    read: {
                        url: "http://demos.telerik.com/olap/msmdpump.dll",
                        dataType: "text",
                        contentType: "text/xml",
                        type: "POST"
                schema: {
                    type: "xmla"

The code from the previous example results in the following widget.

Figure 1: The PivotConfigurator

Kendo UI PivotConfigurator


Existing Instances

To reference an existing PivotConfigurator instance, use the jQuery.data() method. Once a reference has been established, use the PivotConfigurator API to control its behavior.

The following example demonstrates how to access an existing PivotConfigurator instance.

var pivotconfigurator = $("#pivotconfigurator").data("kendoPivotConfigurator");

See Also

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