Force Data Source Reload
The following example demonstrates how to reload the data source of the PivotGrid widget manually, starting from the initial expand state of the widget.
Example
<div id="example">
<div id="forceReadButton">Force DataSource Read</div>
<div id="pivotgrid"></div>
<script>
$(document).ready(function () {
$("#forceReadButton").kendoButton({
click: function() {
var pivot = $("#pivotgrid").data("kendoPivotGrid");
reset(pivot, dataSourceConfig);
}
});
function reset(pivot, config) {
pivot.setDataSource(new kendo.data.PivotDataSource(config));
};
var dataSourceConfig = {
type: "xmla",
rows: [{ name: "[Geography].[City]" }],
measures: ["[Measures].[Reseller Freight Cost]"],
transport: {
connection: {
catalog: "Adventure Works DW 2008R2",
cube: "Adventure Works"
},
read: "//demos.telerik.com/olap/msmdpump.dll"
},
schema: { type: "xmla" },
error: function (e) { alert("error: " + kendo.stringify(e.errors[0])); }
};
var pivotgrid = $("#pivotgrid").kendoPivotGrid({
filterable: true,
sortable: true,
columnWidth: 200,
height: 580,
dataSource: dataSourceConfig
}).data("kendoPivotGrid");
});
</script>
<style>
#forceReadButton {
margin-bottom: 10px;
}
</style>
</div>
See Also
- PivotGrid JavaScript API Reference
- How to Change Data Source Dynamically
- How to Drill Down Navigation Always Starting from Root Tuple
- How to Expand Multiple Column Dimensions
- How to Filter by Using the include Operator
- How to Integrate with Kendo UI Chart
- How to Make the Include fields Window Modal
- How to Modify Measure Tag Captions
- How to Reload PivotGrid Configuration Options
- How to Reset Expand State
- How to Show Tooltip with Data Cell Information
- How to Translate PivotConfigurator Field Items
For more runnable examples on the Kendo UI PivotGrid, browse its How To documentation folder.