New to Kendo UI for jQuery? Start a free 30-day trial

Rows

configuration

The configuration of the row axis members. An array of JavaScript objects or strings. A JavaScript objects are interpreted as rows descriptors. Strings are interpreted as the hierarchical name of the member.

rows

Array

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

rows.expand

Boolean

If set to true, the member will be expanded.

<script>
var dataSource = new kendo.data.PivotDataSource({
  type: "xmla",
  columns: [{ name: "[Date].[Calendar]", expand: true }],
  transport: {
    connection: {
        catalog: "Adventure Works DW 2008R2",
        cube: "Adventure Works"
    },
    read: "https://demos.telerik.com/service/v2/olap/msmdpump.dll"
  },
  schema: {
    type: "xmla"
  }
});
dataSource.fetch();
</script>

rows.name

String

The hierarchical name of the rows.

<script>
var dataSource = new kendo.data.PivotDataSource({
  type: "xmla",
  rows: [{ name: "[Date].[Calendar]", expand: false }],
  transport: {
    connection: {
        catalog: "Adventure Works DW 2008R2",
        cube: "Adventure Works"
    },
    read: "https://demos.telerik.com/service/v2/olap/msmdpump.dll"
  },
  schema: {
    type: "xmla"
  }
});
dataSource.fetch();
</script>