DevExtreme jQuery - PivotGridDataSource - store
This option 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 option.Array
Assigning an array to the store option 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 option accepts one of the following values:
"array"
Creates an ArrayStore."local"
Creates a LocalStore."odata"
Creates an ODataStore."xmla"
Creates an XmlaStore.
Each store has options that are detailed in the links above. Declare these options in the store object.
You can also implement custom data access logic as described in the Use CustomStore topic.