Example of Dynamic Binding in ASP.NET Core Pivot Table Control

This sample demonstrates how to dynamically load data from multiple data sources in the Pivot Table, including local and remote JSON/CSV files, as well as an OLAP(XMLA) data source via customized toolbar menu options. Additionally, you can save and reload Pivot Table report(s) as JSON files for future analysis.

DEMO

SOURCE

URL

Data Sources

Catalogs

Cubes

This sample showcases how to dynamically load data at runtime. Use the custom toolbar to switch sources or save/load reports.

Open a Data Source:

JSON

Local JSON Data: Toolbar → JSON → Local.
Remote JSON Data: Toolbar → JSON → Remote.

CSV

Local CSV Data: Toolbar → CSV → Local.
Remote CSV Data: Toolbar → CSV → Remote.

OLAP(XMLA)

Use the OLAP(XMLA) option to connect to an OLAP server with dynamic discovery of data sources, catalogs, and cubes.

Load a Pivot Report:

Local JSON Pivot Report: Toolbar → Load Pivot Report → Local JSON.
Remote JSON Pivot Report: Toolbar → Load Pivot Report → Remote JSON.

Save a Pivot Report:

Click the “Save Pivot Report as JSON” toolbar item to download the current configuration (data excluded).

More info: Data Binding and Save/load report.