Expands a row tuple member that has children.

The path has to include the unique member names until the significant (the one that needs to be expanded) member is reached.


path Array

The path which uniquely specifies the tuple member that needs to be expanded.

Example - expand the second-level tuple member

<!-- Real life demo: https://docs.telerik.com/kendo-ui/web/pivotgrid/how-to/expand-multiple-dimensions -->

var dataSource = new kendo.data.PivotDataSource({
  type: "xmla",
  rows: [{ name: "[Date].[Calendar]", expand: true }, { name: "[Product].[Category]" } ],
  columns: [{ name: "[Geography].[City]" }],
  measures: ["[Measures].[Reseller Freight Cost]"],
  transport: {
    connection: {
        catalog: "Adventure Works DW 2008R2"
    read: "https://demos.telerik.com/olap/msmdpump.dll"
  schema: {
    type: "xmla"

dataSource.one("dataBound", function() {
    //Expand CY 2005 - first dimension
    dataSource.expandRow(["[Date].[Calendar].[Calendar Year].&[2005]"]);

    //Expand All Products under CY 2015 - second dimension
    dataSource.expandRow(["[Date].[Calendar].[Calendar Year].&[2005]","[Product].[Category].[All Products]"]);

In this article
Not finding the help you need? Improve this article