| Feature | MS Analysis Services | Pentaho Mondrian | Elasticsearch | Databases | CSV | JSON |
|---|---|---|---|---|---|---|
| – Grid | ||||||
| Virtual grid that supports rendering and scrolling thousands of rows | ||||||
| Sort rows/columns | ||||||
| Sort values | ||||||
| Drill-through | ||||||
| Expand/collapse values | ||||||
| Drill up & down | ||||||
| Drag & drop fields on the grid | ||||||
| Columns/rows resize on the grid | ||||||
| Grand totals and subtotals | ||||||
| Compact pivot table | ||||||
| Classic pivot table | ||||||
| Flat table | ||||||
| Editing cells | ||||||
| Add several fields to columns | ||||||
| Add several fields to rows | ||||||
| Select string field as a value (count, distinct count) | ||||||
| Select cells | ||||||
| Copy selected cells | ||||||
| Keyboard shortcuts to navigate on the grid | ||||||
| Highlight rows/columns | ||||||
| – Filter | ||||||
| Filter by members’ names using checkbox | ||||||
| Filter by members’ names using search input box | ||||||
| Value Filter | ||||||
| Value Filter (Top X records) | ||||||
| Value Filter (Bottom X records) | ||||||
| Date Filter | ||||||
| Label Filter | ||||||
| Number Filter | ||||||
| Time Filter | ||||||
| Report filter | ||||||
| – Fields | ||||||
| UI for adding and editing calculated values | ||||||
| Drag n drop dimensions in the Field List | ||||||
| Displaying dimension folders in the Field List | ||||||
| Displaying hierarchy levels in the Field List | ||||||
| Search in the Field List | ||||||
| Expand All in the Field List | ||||||
| The Field List in drill-through view | ||||||
| – Aggregation functions | ||||||
| “sum” | ||||||
| “count” | ||||||
| “distinctcount” | ||||||
| “average” | ||||||
| “median” | ||||||
| “product” | ||||||
| “min” | ||||||
| “max” | ||||||
| “runningtotals” | ||||||
| “stdevp” (Population Standard Deviation) | ||||||
| “stdevs” (Sample Standard Deviation) | ||||||
| “percent” | ||||||
| “percentofcolumn” | ||||||
| “percentofrow” | ||||||
| “index” | ||||||
| “difference” | ||||||
| “%difference” | ||||||
| – Charts | ||||||
| Column | ||||||
| Bar | ||||||
| Line | ||||||
| Scatter | ||||||
| Pie | ||||||
| Bar stack | ||||||
| Bar line | ||||||
| Drillable/expandable axis and legend | ||||||
| Drill-through for charts | ||||||
| Interactive filtration for charts | ||||||
| Tooltips on charts | ||||||
| Split view (showing grid and charts simultaneously) | ||||||
| – Toolbar | ||||||
| Save the report | ||||||
| Open the report | ||||||
| Conditional formatting | ||||||
| Number formatting | ||||||
| Connect to data source | ||||||
| Switch between grid and charts | ||||||
| Fullscreen mode | ||||||
| – Export | ||||||
| Report printing | ||||||
| Export reports to HTML | ||||||
| Export to MS Excel | ||||||
| Export to PDF | ||||||
| Export reports to CSV | ||||||
| Export reports to PNG | ||||||
| Add custom headers/footers (PDF, HTML, Print) | ||||||
| – Options | ||||||
| Use formatting defined in the cube | ||||||
| Type of view: “grid”, “charts” or both | ||||||
| Attribute Hierarchies | ||||||
| Customizing appearance using CSS | ||||||
| Multilingual localization | ||||||
| Date and time patterns | ||||||
| – Connection | ||||||
| via XMLA | ||||||
| via Accelerator | ||||||
| via Compressor | ||||||
| – Integration with charting libraries | ||||||
| Highcharts | ||||||
| FusionCharts | ||||||
| Google Charts | ||||||
| Any charting library | ||||||
| – Integration | ||||||
| jQuery | ||||||
| AngularJS | ||||||
| Angular | ||||||
| React | ||||||
| Webpack | ||||||
| RequireJS | ||||||
| TypeScript | ||||||
| ASP.NET | ||||||
| JSP | ||||||
| PhoneGap |
| Feature | MS Analysis Services | Pentaho Mondrian | Elasticsearch | Databases | CSV | JSON |
|---|---|---|---|---|---|---|
| – General options | ||||||
| Show/hide toolbar | ||||||
| Set type of view: “grid”, “charts” or both | ||||||
| Show/hide the Field List | ||||||
| Open/close the Field List | ||||||
| Show/hide the aggregation selection control | ||||||
| Show/hide “Add calculated value” option in UI | ||||||
| Enable/disable editing cells | ||||||
| Show grand totals on the top or on the bottom for flat view | ||||||
| Enable/disable the drill through feature | ||||||
| Configure slice in drill through | ||||||
| Show/hide the Field List in drill through | ||||||
| Show/hide member properties for OLAP | ||||||
| Show/hide the sorting controls | ||||||
| Set date and time patterns | ||||||
| Enable a default slice for the component | ||||||
| Sorting type for hierarchies’ members: “asc”, “desc” or “unsorted” | ||||||
| Apply the format defined in the cube | ||||||
| Selecting sublevels from multilevel hierarchy | ||||||
| KPIs | ||||||
| Multidimensional mode support | ||||||
| Tabular mode support | ||||||
| Build multilevel hierarchy based on simple data | ||||||
| Subqueries for server-side filtering | ||||||
| Different field separators for CSV | ||||||
| Global options for all reports | ||||||
| Customizing toolbar | ||||||
| Customizing context menu | ||||||
| Define custom sort for members | ||||||
| Expand/collapse all nodes from API | ||||||
| Show an alert pop-up window with a custom message | ||||||
| – Grid options | ||||||
| Set grid type: “compact” or “classic” | ||||||
| Set grid type: “flat” | ||||||
| Set grid title | ||||||
| Show/hide filters | ||||||
| Show/hide spreadsheet headers | ||||||
| Show/hide totals | ||||||
| Show/hide grand totals in rows/columns/both | ||||||
| Show/hide hierarchy captions | ||||||
| Show/hide reports filtering cells on the grid | ||||||
| Define layout for report filters | ||||||
| – Chart options | ||||||
| Set chart type | ||||||
| Set chart title | ||||||
| Show/hide filters | ||||||
| Show/hide multiple measures on charts | ||||||
| Select the range of values on the charts automatically | ||||||
| Show/hide chart legend | ||||||
| Show/hide all the labels in Pie сhart | ||||||
| Show/hide dropdowns with measures | ||||||
| Show the warning if data is too big for charts |
| addCalculatedMeasure | adds calculated measure |
| addCondition | adds a conditional formatting rule |
| alert | shows an alert pop-up window with a custom message |
| clear | clears the component’s data and view |
| clearFilter | clears the filter applied previously to the specified hierarchy |
| clearXMLACache | requests Microsoft Analysis Services to clear the cache |
| closeFieldsList | closes the Field List |
| collapseAllData | collapses all nodes and drills up all levels of all hierarchies |
| collapseData | collapses all nodes of the specified hierarchy |
| connectTo | connects to the data source without cleaning the report |
| customizeCell | allows customizing of separate cells |
| customizeContextMenu | allows customizing context menu |
| dispose | prepares the pivot table instance to be deleted with the browser’s garbage collection |
| expandAllData | expands all nodes and drills down all levels of all hierarchies |
| expandData | expands all nodes of the specified hierarchy |
| exportTo | exports grid or chart to CSV, HTML, PDF, Image or Excel format |
| getAllConditions | returns a list of conditional formatting rules of the report |
| getAllHierarchies | returns a list of all available hierarchies |
| getAllMeasures | returns a list of all available measures |
| getCell | returns information about cell by row and column indexes |
| getColumns | returns a list of hierarchies selected in the report slice for columns |
| getCondition | returns a conditional formatting rule by id |
| getData | retrieves the data for integration with 3rd party charting libraries |
| getFilter | returns the filtered members for the specified hierarchy |
| getFormat | returns Format Object of a default number format or the number format for the specified measure |
| getMeasures | returns a list of the selected measures in the report |
| getMembers | returns a list of members for the specified hierarchy |
| getOptions | returns Options Object with component’s options |
| getReportFilters | returns a list of hierarchies selected in the report slice for Report Filters |
| getReport | returns Report Object which describes the current report |
| getRows | returns a list of hierarchies selected in the report slice for rows |
| getSelectedCell | returns information about selected cell |
| getSort | returns the sort type which is applied to the hierarchy |
| getXMLACatalogs | obtains a list of all available catalogs on a given data source |
| getXMLACubes | obtains a list of all available cubes on a given data source |
| getXMLADataSources | obtains a list of all data sources by given URL for XMLA connect |
| getXMLAProviderName | returns dataSourceType for given proxyUrl |
| load | loads report JSON file from the specified URL |
| off | removes JS handlers for specified event |
| on | sets a JS function for the specified event |
| open | opens local report file |
| openFieldsList | opens the Field List |
| openFilter | opens the filter pop-up window for the specified hierarchy |
| prints the content of the grid or chart via OS print manager | |
| refresh | redraws the component |
| removeAllCalculatedMeasures | removes all calculated measures |
| removeAllConditions | removes all conditional formatting rules |
| removeCalculatedMeasure | removes the calculated measure by measure unique name |
| removeCondition | removes the conditional formatting rule by id |
| removeSelection | removes a selection from cells on the grid |
| runQuery | runs a query with specified rows, columns, measures and reportFilters from Slice Object and displays the result data |
| save | saves your current report to a specified location |
| setFilter | sets the filter for the specified hierarchy |
| setFormat | sets a default number format or the number format for the specified measure |
| setOptions | sets the component’s options |
| setReport | sets a report to be displayed in the component |
| setSort | sets the sort type to the specified hierarchy |
| showCharts | switches to the charts view and shows the chart of the specified type |
| showGrid | switches to the grid view |
| showGridAndCharts | switches to the grid and charts view and shows the chart of the specified type |
| sortingMethod | sets custom sorting for hierarchy members |
| sortValues | sorts values in a specific row or column in the pivot table |
| updateData | updates data for the report without cleaning the report |