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:
- Microsoft SQL Server Analysis Services (2005, 2008)
- Pentaho Analysis Services (Mondrian)
- any other business intelligence software supporting XMLA standard
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.
See also: