Feature | JSON | CSV | FDS (databases, JSON, and CSV) | MongoDB | MS Analysis Services | Custom data source API | Elasticsearch |
---|---|---|---|---|---|---|---|
– Grid | |||||||
Virtual grid that supports rendering and scrolling thousands of rows | |||||||
Sort rows/columns | |||||||
Sort values | |||||||
Drill-through view | |||||||
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 | |||||||
Flat table multi-column sorting | |||||||
Editing cells | |||||||
Add several fields to columns | |||||||
Add several fields to rows | |||||||
Add several fields to measures | |||||||
Add the same field with different aggregations to measures | |||||||
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 the drill-through view | * | ||||||
– Aggregation functions | |||||||
“sum” | |||||||
“count” | |||||||
“distinctcount” | |||||||
“average” | |||||||
“median” | |||||||
“product” | |||||||
“min” | |||||||
“max” | |||||||
“stdevp” (Population Standard Deviation) | |||||||
“stdevs” (Sample Standard Deviation) | |||||||
“percent” | |||||||
“percentofcolumn” | |||||||
“percentofrow” | |||||||
“percentofparentcolumntotal” | |||||||
“percentofparentrowtotal” | |||||||
“index” | |||||||
“differenceofcolumn” | |||||||
“differenceofrow” | |||||||
“%differenceofcolumn” | |||||||
“%differenceofrow” | |||||||
“runningtotalsofcolumn” | |||||||
“runningtotalsofrow” | |||||||
– Charts | |||||||
Column | |||||||
Bar | |||||||
Line | |||||||
Scatter | |||||||
Pie | |||||||
Stacked column | |||||||
Column line | |||||||
Drillable/expandable axis and legend | |||||||
Drill-through view 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 (Export and Print) | |||||||
– Options | |||||||
Use formatting defined in the cube | |||||||
Type of view: “grid”, “charts” or both | |||||||
Attribute Hierarchies | |||||||
Customizing appearance using CSS | |||||||
Accessibility support | |||||||
Multilingual localization | |||||||
Date and time patterns | |||||||
– Connection | |||||||
via XMLA | |||||||
via The Accelerator | |||||||
– Security and Authentication | |||||||
withCredentials | |||||||
Request headers | |||||||
Windows authentication | |||||||
Using roles | |||||||
HTTPS configuration | |||||||
Custom authorization | |||||||
– Integration with charting libraries | |||||||
Highcharts | |||||||
amCharts | |||||||
FusionCharts | |||||||
Google Charts | |||||||
Any charting library | |||||||
– Integration | |||||||
Angular | |||||||
React | |||||||
Vue 2 | |||||||
Vue 3 | |||||||
Django | |||||||
Jupyter Notebook | |||||||
React Native | |||||||
Blazor | |||||||
AngularJS | |||||||
TypeScript | |||||||
R Shiny | |||||||
jQuery | |||||||
Ionic | |||||||
Electron.js | |||||||
Webpack | |||||||
RequireJS |
* Available when connecting to SSAS via Flexmonster Accelerator
Feature | JSON | CSV | FDS (databases, JSON, and CSV) | MongoDB | MS Analysis Services | Custom data source API | Elasticsearch |
---|---|---|---|---|---|---|---|
– 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 the slice in the drill-through view | * | ||||||
Show/hide the Field List in the drill-through view | * | ||||||
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 | |||||||
Create multiple fields from one field | |||||||
Define available aggregations for all fields of a certain type | |||||||
Subqueries for server-side filtering | |||||||
Different field separators for CSV | |||||||
Global options for all reports | |||||||
Share 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 |
* Available when connecting to SSAS via Flexmonster Accelerator
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 |
collapseCell | collapses a specific node on the grid and charts |
collapseData | collapses all nodes of the specified hierarchy |
connectTo | connects to the data source without cleaning the report |
customizeAPIRequest | allows customizing the request before it is sent to a server |
customizeCell | allows customizing of separate cells |
customizeChartElement | allows customizing separate chart elements in Flexmonster Charts |
customizeContextMenu | allows customizing context menu |
dispose | prepares the pivot table instance to be deleted with the browser’s garbage collection |
drillDownCell | drills down a specific hierarchy level on the grid and charts |
drillUpCell | drills up a specific hierarchy level on the grid and charts |
expandAllData | expands all nodes and drills down all levels of all hierarchies |
expandCell | expands a specific node on the grid and charts |
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 |
getAllHierarchiesAsync | the async equivalent of getAllHierarchies
|
getAllMeasures | returns a list of all available measures |
getAllMeasuresAsync | the async equivalent of getAllMeasures
|
getCell | returns information about cell by row and column indexes |
getColumns | returns a list of hierarchies selected in the report slice for columns |
getColumnsAsync | the async equivalent of getColumns
|
getCondition | returns a conditional formatting rule by id |
getFilter | returns the filtered members for the specified hierarchy |
getFlatSort | returns an array of objects defining the sorting on the flat grid |
getFormat | returns the FormatObject of a default number format or the number format for the specified measure |
getMeasures | returns a list of the selected measures in the report |
getMeasuresAsync | the async equivalent of getMeasures
|
getMembers | returns a list of members for the specified hierarchy |
getMembersAsync | the async equivalent of getMembers
|
getOptions | returns the OptionsObject with component’s options |
getReportFilters | returns a list of hierarchies selected in the report slice for Report Filters |
getReportFiltersAsync | the async equivalent of getReportFilters
|
getReport | returns the ReportObject which describes the current report |
getRows | returns a list of hierarchies selected in the report slice for rows |
getRowsAsync | the async equivalent of getRows
|
getSelectedCell | returns information about selected cell |
getSort | returns the sort type which is applied to the hierarchy |
getTableSizes | returns table sizes that are set for the component |
getXMLACatalogs | obtains a list of all available catalogs on a given data source |
getXMLACatalogsAsync | the async equivalent of getXMLACatalogs
|
getXMLACubes | obtains a list of all available cubes on a given data source |
getXMLACubesAsync | the async equivalent of getXMLACubes
|
getXMLADataSources | obtains a list of all data sources by given URL for XMLA connect |
getXMLADataSourcesAsync | the async equivalent of getXMLADataSources
|
getXMLAProviderName | returns dataSourceType for given proxyUrl |
getXMLAProviderNameAsync | the async equivalent of getXMLAProviderName
|
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 |
openCalculatedValueEditor | opens the calculated value pop-up window editor |
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 report filters from the SliceObject and displays the result data |
save | saves your current report to a specified location |
scrollToColumn | scrolls the grid to the specified column |
scrollToRow | scrolls the grid to the specified row |
setFilter | sets the filter for the specified hierarchy |
setFlatSort | sets the flat table multi-column sorting |
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 |
setTableSizes | sets table sizes for the component |
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 |
sortFieldsList | sets custom sorting for Field List items |
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 |