measures

Gets or sets the measures configuration.

Parameters

val Array

The measures configuration. Accepts the same values as the measures option.

Returns

Array—The current measures configuration.

Example - set the measures

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

dataSource.measures(["[Measures].[Internet Order Lines Count]"]);
</script>

Example - get the measures

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

var measures = dataSource.measures();
/* The result can be observed in the DevTools(F12) console of the browser. */
console.log(measures);// [{ name: "[Measures].[Internet Order Lines Count]" }]
</script>

measuresAxis

Gets the name of the axis on which the measures are displayed.

Returns

String—The axis name.

Example - set the measures

<script>
var dataSource = new kendo.data.PivotDataSource({
  type: "xmla",
  measures: {
      values: ["[Measures].[Internet Order Lines Count]", "[Measures].[Days Current Quarter to Date]"],
      axis: "rows"
  },
  transport: {
    connection: {
        catalog: "Adventure Works DW 2008R2",
        cube: "Adventure Works"
    },
    read: "https://demos.telerik.com/olap/msmdpump.dll"
  },
  schema: {
    type: "xmla"
  }
});

var axis = dataSource.measuresAxis();
/* The result can be observed in the DevTools(F12) console of the browser. */
console.log(axis); // "rows"
</script>