DevExtreme jQuery - PivotGridDataSource - store
This property accepts one of the following:
Store instance
An XmlaStore, ArrayStore, LocalStore, ODataStore, or CustomStore instance.Store configuration object
An XmlaStore, ArrayStore, LocalStore, or ODataStore configuration object. Make sure to set the type property.Array
Assigning an array to the store property automatically creates an ArrayStore in the PivotGridDataSource.
jQuery
$(function() {
var pivotGridDataSource = new DevExpress.data.PivotGridDataSource({
store: new DevExpress.data.XmlaStore({
// XmlaStore instance
})
// ===== or =====
store: {
type: "xmla",
// XmlaStore configuration object
}
});
$("#pivotGridContainer").dxPivotGrid({
dataSource: pivotGridDataSource
});
});Angular
import PivotGridDataSource from "devextreme/ui/pivot_grid/data_source";
import XmlaStore from "devextreme/ui/pivot_grid/xmla_store";
import { DxPivotGridModule } from "devextreme-angular";
// ...
export class AppComponent {
pivotGridDataSource: PivotGridDataSource;
constructor() {
this.pivotGridDataSource = new PivotGridDataSource({
store: new XmlaStore({
// XmlaStore instance
})
// ===== or =====
store: {
type: "xmla",
// XmlaStore configuration object
}
});
}
}
@NgModule({
imports: [
// ...
DxPivotGridModule
],
// ...
})
<dx-pivot-grid
[dataSource]="pivotGridDataSource">
</dx-pivot-grid>See the Use CustomStore topic for information on how to implement custom data access logic.
type
This property accepts one of the following values:
"array"
Creates an ArrayStore. View Demo"local"
Creates a LocalStore."odata"
Creates an ODataStore.
Each store has properties that are detailed in the links above. Declare these properties in the store object.
You can also implement custom data access logic as described in the Use CustomStore topic.