Edit this page

measures Array |Object

The configuration of measures. An string array which values are interpreted as the name of the measures to be loaded. Measures can be defined as a list of objects with 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

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

measures.values Array

An string array which values are interpreted as the name of the measures to be loaded.

Example - set the measures

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

measures.axis String (default: columns)

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

Example - set the measures axis

<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"
  }
});
dataSource.fetch();
</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