expandColumn

Expands a column 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.

Parameters

path Array

The path that 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 -->

<script>
var dataSource = new kendo.data.PivotDataSource({
  type: "xmla",
  columns: [{ name: "[Date].[Calendar]", expand: true }, { name: "[Product].[Category]" } ],
  rows: [{ 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.expandColumn(["[Date].[Calendar].[Calendar Year].&[2005]"]);

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

dataSource.read();
</script>