Pivot Table Component can connect to OLAP cubes via XMLA protocol. XMLA is XML for Analysis - an industry standard for data access in analytical systems, such as OLAP and Data Mining.
The following business intelligence software works well with the Pivot Table Component:
Both Microsoft Analysis Services and Pentaho Analysis Services data sources are fully supported by the Pivot Table Component. If connected to such a data source, the Pivot Table Component delegates all data management and calculations to the server-side.
This method will greatly increase your application's performance if you are dealing with large data volumes. In such case it could take a long time for a client browser to recalculate all the data. It works much faster when request server-side data recalculation and then simply display the received result.