MS Analysis Services
Pivot table component offers the connection to Microsoft Analysis Services in two ways: XMLA and Flexmonster Accelerator. XMLA is an industry standard for data access in analytic systems. In case you need advanced features, e.g. faster data transfer, try Flexmonster Accelerator for Microsoft Analysis Services cubes – a special server-side proxy that helps you to increase data loading speed from server to customer’s browser.
Follow our detailed guides on how to work with MS Analysis Services:
You can connect to Mondrian via XMLA or via Flexmonster Accelerator. XMLA is an industry standard but it may take too much time and memory to load and process data. In this case, we recommend Flexmonster Accelerator for Pentaho Mondrian cubes – a special server-side proxy that helps you to increase data loading speed from server to customer’s browser.
Read our step-by-step guides:
Combine icCube and Flexmonster pivot table to analyze data from OLAP cubes. Connection to icCube is provided by XMLA protocol.
For more details read our guide: Connecting to icCube via XMLA.
Pivot table component supports the following databases:
- Microsoft SQL Server
- Other ADO.NET / ODBC / JDBC databases
Our component offers Flexmonster Data Compressor – a special server-side compression tool that helps you to increase data loading speed from the server to the customer’s browser. Flexmonster Compressor is available for .NET, .NET Core, Java and PHP. Follow detailed tutorials for each technology:
CSV data source
In Flexmonster component you can easily:
- build a report based on CSV data source;
- load CSV data from a file;
- add data generated by the server-side script.
Using CSV data source you can indicate how data will be interpreted by Pivot table component. Check our guides:
JSON data source
Our component supports two kinds of JSON format – array of objects, where each object is an unordered set of name/value pairs, and array of arrays, where each sub-array contains ordered values. The first object in JSON array can be used to define data types, captions, group fields under one dimension, hierarchies, etc.
JSON data can easily be loaded from the file. The customer can choose Connect > To local JSON in the toolbar and choose a file from the computer. Also, JSON file can be referred as data source inside of the report.
To display data which already is on your page you can include JSON directly into your code and build a report based on it.
Read more in the following guides: