There are a few ways to add data to use with OLAP.
You can set the datasource via the PivotEngine's itemsSource property.
let engine = wjOlap.PivotEngine(); engine.itemsSource = data;
In the above example,
data is an array of JSON objects with the same property names. After binding to the PivotEngine, you can begin taking advantage of the pivoting features.
When you need a direct connection OLAP data on the server, you need an alternate approach. Wijmo supports connections to OLAP cubes also. provide the URL to the PivotEngine's itemsSource.
You can connect to:
To connect, just provide the URL of the Service to the PivotEngine's itemsSource. All of the operations performed on the data, will be executed on the server.
const url = 'https://www.grapecity.com/componentone/demos/aspnet/c1webapi/latest/api/dataengine/'; let engine = wjOlap.PivotEngine(); engine.itemsSource = url;
The steps above demonstrate simply how to add your data. To view the data and do something meaningful, you need to use the UI components included in wijmo.olap. This includes the PivotPanel, PivotGrid, and PivotChart.
Continue to the next guide to learn more about viewing your data in these components.