Edit this page

measures

Get 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();
console.log(measures);// [{ name: "[Measures].[Internet Order Lines Count]" }]
</script>

measuresAxis

Get the name of the axis on which 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();
console.log(axis); // "rows"
</script>
Is this article helpful? Yes / No
Thank you for your feedback!

Give article feedback

Tell us how we can improve this article

close
Dummy