Flexmonster supports OLAP cubes created in both tabular and multidimensional modes. 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 Elasticsearch and Flexmonster Pivot to analyze data directly in the browser.
The key feature is that there is no need to load all the raw data into the pivot table to build the cube – a multi-dimensional representation of the data. Flexmonster sends a sequence of queries to get the summarized data from Elasticsearch.
For more details read our guide: Connecting to Elasticsearch.
Pivot table component supports the following 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:
In Flexmonster component you can easily:
Using CSV data source you can indicate how data will be interpreted by Pivot table component. Check our guides:
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: