DevExtreme jQuery/JS - OLAP Cube
An OLAP cube is a multi-dimensional dataset that allows data mining and analysis. DevExtreme provides the PivotGrid UI component to display data from an OLAP cube.
To access an OLAP cube, implement the XmlaStore: specify the OLAP server's url, the catalog that contains the OLAP cube that you access, and the cube.
Wrap the XmlaStore into a PivotGridDataSource. This component enables you to group, sort, filter, and perform other data shaping operations on the store's data. Bind the PivotGrid to this PivotGridDataSource:
index.js
- $(function() {
- var adventureWorksStore = new DevExpress.data.XmlaStore({
- url: "https://my-web-srv01/OLAP/msmdpump.dll",
- catalog: "AdventureWorksDW2012",
- cube: "Adventure Works"
- });
- var adventureWorksDataSource = new DevExpress.data.PivotGridDataSource({
- store: adventureWorksStore
- });
- $("#pivotGridContainer").dxPivotGrid({
- dataSource: adventureWorksDataSource
- });
- });
Feel free to share topic-related thoughts here.
If you have technical questions, please create a support ticket in the DevExpress Support Center.
Thank you for the feedback!
If you have technical questions, please create a support ticket in the DevExpress Support Center.