NEW The "Difference" aggregation "difference" is split into two different aggregations: "Difference of Column" "differenceofcolumn" and "Difference of Row" "differenceofrow". If the deprecated "Difference" aggregation "difference" is used, Flexmonster Pivot will automatically treat it as "Difference of Column" "differenceofcolumn".
NEW The "% Difference" aggregation "%difference" is split into two different aggregations: "% Difference of Column" "%differenceofcolumn" and "% Difference of Row" "%differenceofrow". If the deprecated "% Difference" aggregation "%difference" is used, Flexmonster Pivot will automatically treat it as "% Difference of Column" "%differenceofcolumn".
NEW The "Running Totals" aggregation "runningtotals" is split into two different aggregations: "Running Totals of Column" "runningtotalsofcolumn" and "Running Totals of Row" "runningtotalsofrow". If the deprecated "Running Totals" aggregation "runningtotals" is used, Flexmonster Pivot will automatically treat it as "Running Totals of Column" "runningtotalsofcolumn".
NEW The following aggregations were introduced for the string data type in JSON and CSV data sources:
"percent""percentofcolumn""percentofrow""percentofparentcolumntotal""percentofparentrowtotal""index""differenceofcolumn""differenceofrow""%differenceofcolumn""%differenceofrow""runningtotalsofcolumn""runningtotalsofrow"NEW A new "negativeNumberFormat" property was added to the Format Object.
NEW A new option distinguishNullUndefinedEmpty was added to separate empty values from null and undefined.
NEW Now the flat view shows all levels with year/month/day and year/quarter/month/day date types.
NEW Data Server Now basic Flexmonster Data Server functionality is available as a DLL at NuGet.
NEW Data Server New properties for HTTPS configuration were added.
FIX The sorting issue with hierarchies that have numeric levels was fixed.
FIX custom data source API The exception when only one level of a hierarchy is active was fixed.
FIX custom data source API The issue with expanding hierarchies was fixed.
FIX custom data source API The issue while reading year and month types of levels was fixed.
FIX custom data source API The issue with missed measures in the calculated values was fixed.
FIX custom data source API Support of id's instead of names for members was restored.
FIX custom data source API The incorrect saving of the mapping object to the report after switching between compact, classic, and flat tables was fixed.
FIX Data Server The issue with nulls in the first JSON object was fixed.
FIX The issue with the blank column in the drill-through view was fixed.
FIX The issue with saving inactive calculated values to the Report Object was fixed.
FIX Mapping for CSV is now applied by column names instead of column indexes.
FIX Mapping for CSV is now applied on top of the default structure (so it does not require to enumerate all fields).
FIX The option for hiding subtotals on rows was improved for the compact view (empty rows are hidden).
NEW The following front-end built-in aggregations were introduced for the custom data source API:
"percent""percentofcolumn""percentofrow""percentofparentcolumntotal""percentofparentrowtotal""index""difference""%difference""runningtotals"They will appear automatically for numeric fields if at least one aggregation is supported on the back end, for example, "sum".
NEW The "runningtotals" aggregation was introduced for SSAS and Mondrian data sources.
NEW A new "filters" mapping property was added.
NEW Data Server Now Flexmonster Data Server can be run on HTTPS.
NEW Data Server Now Flexmonster Data Server supports last, current, and next date filters.
FIX The unused properties were removed from /select requests in the custom data source API.
FIX The error handling for the index data source property was improved for the custom data source API.
FIX The issue with inappropriate saving of availableAggregations to the report.slice was fixed.
FIX The options.grid.showEmptyValues option was moved to options.showEmptyValues.
FIX The issue with the numeric value filter not getting applied in the flat form was fixed.
FIX 'Content-Type' header was removed from the GET requests for loading data.
FIX The issue with expanding rows on the classic form was fixed.
FIX custom data source API The issue with hierarchies containing capital letters in level names was fixed.
FIX custom data source API The issue with converting the last, current, and next date filter queries to the between query was fixed.
FIX The issue with "requestHeaders" in custom data source API was fixed.
FIX The issue with the hierarchy's caption was fixed.
FIX The issue with changing drill-through slice was fixed.
FIX The issue with "dimensionUniqueName" in the mapping object was fixed.
FIX Data Server The issue with null members was fixed.
FIX custom data source API The issue with unbalanced hierarchies was fixed.
FIX Now the nullValue property from the Format Object works for the string data types.
NEW Flexmonster Data Server is now available! It significantly reduces the time of data loading and enables analyzing large datasets (read docs).
NEW Multilevel hierarchies are now supported for the custom data source API.
NEW Advanced mapping features for the custom data source API and CSV were added.
NEW The dataSource.withCredentials property is now available for the custom API data source.
NEW Windows authorization is now supported for the Accelerator.
FIX The issue with an odd decimal part for large integers was fixed.
FIX The issue with resetting captions after the updateData() API call was fixed.
FIX The issue with the date value filter was fixed.
FIX The issue with incorrect analyzing data message was fixed.
FIX The default behavior of the rawData property was restored.
FIX The issue with resizing more than one Flexmonster instance was fixed.
FIX The issue with calling the dispose API call for more than one Flexmonster instance was fixed.
FIX Accelerator The issue with blocking error when using an MDX measure was fixed.
FIX The issue with saving files (export, reports) when using Adobe Analytics was fixed.
FIX The exception when using invalid names in a formula for calculated values was fixed.
FIX Validating calculated values was improved to check all names.
FIX For SSAS XMLA connection the issue with duplicating requstHeaders for the first request was fixed.
NEW The "withCredentials" property is now supported for the Flexmonster Accelerator.
FIX The issue with "instanceof Array" check in different frames was fixed.
FIX The issue with empty recordId in the drill-through pop-up window cell was fixed.
FIX The issue with exporting dates with timezones to Excel was fixed.
FIX For custom API data source, handling and sorting of empty numeric/date members were improved.
FIX Gear icon is now hidden in the flat form with grid.showFilter: false option.
FIX Loading empty CSV/JSON data was made consistent.
FIX The issue with the Ctrl+click for multi-column sorting on Linux/Ubuntu was fixed.
FIX The issue with the Ctrl+click for selecting multiple cells on Linux/Ubuntu was fixed.
FIX The issue with the overlapping of a filter icon in header cells on the flat table was fixed.
FIX The issue with missing sort icon for some measures in multi-column sorting mode was fixed.
FIX The issue with scrolling in the Field List on iOS 13 was fixed.
FIX The issue with the sigma icon visibility inside the calculated value editor was fixed. Now the sigma icons which are used to choose the aggregation are available for all items that have more than one aggregation available.
FIX The issue when a word (undefined) is displayed next to the formula name in the calculated values editor was fixed.