New to Kendo UI for jQuery? Start a free 30-day trial

Measures

configuration

The configuration of measures. A string array whose values are interpreted as the name of the measures that will be loaded. Measures can be defined as a list of objects with the name and type fields.

[{
    name: "[Measures].[_Internet Current Quarter Sales Performance Status]",
    type: "status"
}]

The type value can be defined to status or trend to render kpiStatusTemplate or kpiTrendTemplate. If type is not defined, then the dataCellTemplate will be used.

measures

Array|Object

<div id="pivot"></div>

<script>
var dataSource = new kendo.data.PivotDataSource({
  type: "xmla",
  measures: ["[Measures].[Reseller Freight Cost]"],
  transport: {
    connection: {
        catalog: "Adventure Works DW 2008R2",
        cube: "Adventure Works"
    },
    read: "https://demos.telerik.com/service/v2/olap/msmdpump.dll"
  },
  schema: {
    type: "xmla"
  }
});

$("#pivot").kendoPivotGrid({
  dataSource: dataSource
});
</script>

measures.axis

String

The name of the axis on which the measures will be displayed. The supported values are the rows or columns. This option is applicable if multiple measures are used.

Default: columns

<div id="pivot"></div>

<script>
var dataSource = new kendo.data.PivotDataSource({
  type: "xmla",
  measures: {
      values: ["[Measures].[Internet Revenue Trend]", "[Measures].[Internet Revenue Status]"],
      axis: "rows"
  },
  transport: {
    connection: {
        catalog: "Adventure Works DW 2008R2",
        cube: "Adventure Works"
    },
    read: "https://demos.telerik.com/service/v2/olap/msmdpump.dll"
  },
  schema: {
    type: "xmla"
  }
});

$("#pivot").kendoPivotGrid({
  dataSource: dataSource
});
</script>

measures.values

Array

A string array whose values are interpreted as the name of the measures that will be loaded.

<div id="pivot"></div>

<script>
var dataSource = new kendo.data.PivotDataSource({
  type: "xmla",
  measures: {
      values: ["[Measures].[Reseller Freight Cost]"]
  },
  transport: {
    connection: {
        catalog: "Adventure Works DW 2008R2",
        cube: "Adventure Works"
    },
    read: "https://demos.telerik.com/service/v2/olap/msmdpump.dll"
  },
  schema: {
    type: "xmla"
  }
});

$("#pivot").kendoPivotGrid({
  dataSource: dataSource
});
</script>