Introduction
AI Components & Features
Contribution
Knowledge Base
PivotDataSource

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

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

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

measures.valuesArray

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

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

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

$("#pivot").kendoPivotGrid({
  dataSource: dataSource
});
</script>
In this article
measuresmeasures.valuesmeasures.axis
Not finding the help you need?
Contact Support