columns Array
The configuration of the column axis members. An array of JavaScript objects or strings. A JavaScript objects are interpreted as column descriptors. Strings are interpreted as the hierarchical name of the member.
Example - set the columns
<script>
var dataSource = new kendo.data.PivotDataSource({
type: "xmla",
columns: ["[Date].[Calendar]"],
transport: {
connection: {
catalog: "Adventure Works DW 2008R2",
cube: "Adventure Works"
},
read: "https://demos.telerik.com/olap/msmdpump.dll"
},
schema: {
type: "xmla"
}
});
dataSource.fetch();
</script>
columns.expand Boolean
If set to true
, the member will be expanded.
Example - set the column as 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/olap/msmdpump.dll"
},
schema: {
type: "xmla"
}
});
dataSource.fetch();
</script>
columns.name String
The hierarchical name of the column.
Example - set the column name
<script>
var dataSource = new kendo.data.PivotDataSource({
type: "xmla",
columns: [{ name: "[Date].[Calendar]", expand: false }],
transport: {
connection: {
catalog: "Adventure Works DW 2008R2",
cube: "Adventure Works"
},
read: "https://demos.telerik.com/olap/msmdpump.dll"
},
schema: {
type: "xmla"
}
});
dataSource.fetch();
</script>