NEW Added ability to import numbers with a comma as a thousand separator from CSV files.
NEW Accelerator SSAS Now, when SSAS is used with Flexmonster Accelerator, the drill-through view displays only the properties which are available in the slice. Now, the Field List is also available for the drill-through view when using SSAS with Flexmonster Accelerator.
NEW Accelerator SSAS A new property showAllFieldsDrillThrough was added to options object. By default, it has value false which enables prefiltering the drill-through view columns when using SSAS with Flexmonster Accelerator. If set as true, the drill-through view will display all the available columns when using SSAS with Flexmonster Accelerator.
NEW Now, datachanged event is triggered when the editing was finished by clicking outside Flexmonster's container.
NEW Now, it is possible to set the drillThrough slice property in the global object. That allows pre-configuring the default list of columns that will be shown in the drill-through view.
NEW Now, the Excel formulas are also escaped when exporting to CSV.
FIX The issue with adding an unnecessary single quote to Excel export file was fixed.
FIX The issue with the year/quarter/month/day type in the flat view was fixed.
FIX The issue with long labels in the filter was fixed.
FIX Message "No measures to display." was updated to "No measures to display. Add at least one measure in the Field List.". Also, it was added to localization files.
FIX The issue with editing date string columns in the flat table was fixed.
FIX The issue with showing the Field List button in the drill-through view was fixed.
NEW Now updateHandler of the getData() API call is triggered also when a number format is changed.
NEW SSAS Filtering added to the drill-through view.
NEW Now, when the showHeaders option parameter is set to false, the column resizer is placed on the second row.
FIX The issue with filtering and grand total percent in the formula was fixed.
FIX The issue with the "max" aggregation and negative values was fixed.
FIX The issue with showing empty cells instead of zeroes for "count" aggregation was fixed.
FIX The issue with resetting measure's format when formatting with the Toolbar was fixed.
FIX The issue with exporting to Excel when the starting layout is the chart's layout was fixed.
FIX The issue with opening filters in the flat table was fixed.
FIX exportTo() method with destinationType: "plain" was improved to return result.data in the following types:
stringstringUint8ArrayHTMLCanvasElementjsPDF objectNEW Now, a requestHeader property is available as a part of export options property. It can be used for saving the export files on the server.
NEW Now, grandTotalCaption is also supported for calculated measures.
NEW A new toolbar property was added to Flexmonster API as a reference to the Toolbar instance to be able to call its functions on the page from outside of Flexmonster Pivot.
NEW Accelerator Now requestHeader is also available for the cube data sources such as Mondrian and SSAS (with Accelerators only).
FIX Progress message about loaded KB of CSV/OCSV/JSON files was fixed.
FIX The issue with scrolling with the key buttons was fixed.
FIX The issue with exporting "$0" strings to Excel in IE browser was fixed.
FIX Data Compressor The issue with TIME type was fixed.
FIX Accelerator SSAS Additional improvements for large data loading.
NEW A new option property dateTimezoneOffset was added. It allows setting the timezone for the following data types: "date", "year/month/day" and "year/quarter/month/day".
NEW A new property useCustomizeCellForData was added for Excel export.
FIX The issue with "year/quarter/month/day" data type was fixed.
FIX The issue with deselecting fields on the flat table when there are fields in the filters area was fixed.
FIX The issue with fullscreen mode in Chrome and Firefox on macOS was fixed.
FIX The issue with drag and drop fields on the flat table with a large number of columns was fixed.
FIX The issue with drag and drop fields order was fixed.
FIX An extra \n when copying selected cells data was removed.
FIX Accelerator SSAS The optimization for large data sets was made.
NEW The recordId parameter of Cell Data Object is available for all table forms: compact pivot table, classic pivot table and flat table.
NEW A new beautifyFloatingPoint formatting property was added. It allows showing numbers like 1.560000000000001 either as 1.56 or 1.560000000000001.
NEW Accelerator SSAS Added support for Azure Analysis Services for Flexmonster Accelerator.
NEW Accelerator SSAS Now drillThroughMaxRows property is supported for SSAS Accelerator.
FIX Accelerator The issue with empty data set when loading multiple instances was fixed.
FIX The issue with right-click on the filters area was fixed.
FIX Chart type names were replaced with more common ones. "bar_stack" was renamed to "stacked_column". "bar_line" was renamed to "column_line". Old names are working in terms of backward compatibility.
FIX The issue with formulas parser was fixed.