measures Array|Object

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.

Example - set the measures

<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/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.

Example - set the measures

<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/olap/msmdpump.dll"
  },
  schema: {
    type: "xmla"
  }
});

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

measures.axis String (default: columns)

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.

Example - set the axis of the measures

<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/olap/msmdpump.dll"
  },
  schema: {
    type: "xmla"
  }
});

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