dataSource kendo.data.PivotDataSourceV2
The data source of the widget. Configured via the dataSource option.
Changes of the data source will be reflected in the widget.
Assigning a new data source would have no effect. Use the setDataSource method instead.
Example - get reference to the widget data source
<div id="pivotgrid"></div>
<script>
$("#pivotgrid").kendoPivotGridV2({
height: 550,
dataSource: {
type: "xmla",
columns: [{ name: "[Date].[Calendar]", expand: true }, { name: "[Geography].[City]" } ],
rows: [{ name: "[Product].[Product]" }],
measures: ["[Measures].[Internet Sales Amount]"],
transport: {
connection: {
catalog: "Adventure Works DW 2008R2",
cube: "Adventure Works"
},
read: 'https://demos.telerik.com/olap/msmdpump.dll'
}
}
});
//get reference to the widget data source
var dataSource = $("#pivotgrid").data("kendoPivotGridV2").dataSource;
</script>