FastCube .NET

Current version: 2021.1.5 Date: Oct 20, 2022 Changes...

Changes List

                            Current Version
- Fixed error with null reference exception on empty filter submit

2022.1
- Fixed error with representing Time values if no display format is set

2021.1
+ Added FastReport.BG extension for FastCube 
+ Added ListDataSet component which allows to load data to cube using standard DataBindings
+ Added "Copy" menu item to the context menu of XAxisZone and YAxisZone of the SliceGrid component. The menu item copies the caption of the selected node to clipboard.
+ Paste from clipboard operation in a popup list executes search operation
+ Double click in the popup filter of a dimension executes SliceGrid positioning to the clicked item
- Fix "Weighted arithmetic mean" calculation

2020.2
+ Mono package and demo
* Refactoring: moved FastReport dependency to a separate project FastReport.Olap.Report
* Expression editor shows item names instead of captions
- Expression errors does not raise Exceptions
- ExpressionHighlight errors does not raise Exceptions
- Fixed move to group error
- Fixed chart data representation in some locales
- Fixed "List of values" aggregate calculation
- Fixed "Median" aggregate calculation

2020.1
+ Added ASP.Net Core support
+ Added ability to save slice and cube to Dropbox, Google Drive, FTP, FastReport Cloud
+ Added cell highlight option compared with average value (AverageHighlight).
+ Added most/least N cell highlight option (TopHighlight).
+ Added repeatable/unique cell highlight option (UniqueHighlight).
+ Added cell highlight based on expressions (ExpressionHighlight).
+ Added negative value settings for ContinuousHighlight with Kind = ContinuousHighlightKind.BarChart
+ Added ContinuousHighlight.LoadPreset() method which simplifies highlight setup from the program code and allows to load predefined highlight options.
* Moved Highlight classes to the FastReport.Olap.Highlight namespace.
* Major refactoring of the ContinousHighlight with breaking of the compatibility: 
  Before: ContinuousHighlightValueType enum had BoundByRow, BoundByCol, PercentByRow, PercentByCol, PercentileByRow, PercentileByCol elements.
  Now: Those elements replaced by Bound, Percent and Percentile elements. Added new enum HighlightScanDirection and the approptiate property ScanDirection 
  common for all Highlight types with the Auto, Rows and Columns elements. New saves wont correctly work in the old version and in the current version of FastCube VCL 2.
  Effect: Highlight setup simplification due to reduced combobox lists. Auto element suit for most cases and does not break highlight (as before)
  after "Measures" field move from the rows to the columns and vice versa.
* Export menu is merged with Save menu in SliceGridToolBar and CubeGridToolBar.
- Fixed error with "copy to clipboard" operation of the SliceGrid data zone cells.
- Fixed error with the chart building.
- Fixed error with closing passed stream inside the Cube.Save(Stream) method.
- Fixed error with export to XLS format

2019.4
+ Added expression support. Expressions allows to perform simple calculations based on measure and dimension values and functions.
+ Information form replaced with Options form. Form allows set Language and add .Net Assemblies.
+ Added methods PopupWindow.ExpandAll(), PopupWindow.CollapseAll(), property CustomGrid.AutoExpandPopups (true by default) which defines
  whether to expand/collapse all PopupWindow automatically on show.
+ Added an ability to set own context menu (ContextMenuStrip) for grid zones.
+ Added DisplayFormat for dimensions. Use AxisField.DisplayFormat to get/set format value or Dimension Editor.
+ Added property AxisContainer.BindCaptionWidth, Slice.BindCaptionWidth to bind field caption width with it content in axis.
+ Added Range.IgnoreCase property to ignore case for text compare. Added appropriate checkbox to range editor.
+ Added clear buttons to the measure editor form.
+ Added axis menu item to delete measure when clicked on measure header.
- Fixed errors with dimension values access from script.


2019.3
+ Added FastCube.Core package to work in console and ASP.Net applications
+ Added date split to half year
+ Added SliceGrid.StatusZone.FloatFormat and SliceGrid.StatusZone.IntegerFormat. Use them to change format of values in StatusBar.
+ Added group creation by condition in code (Group.CreateGroupByRange) and and in SliceGrid menu
+ Groupping and filtering through the axes context menu now handles selection
+ Added ZoneRestrictions.DontShowDropDown item
+ Added designer serialization for SliceGrid and CubeGrid zones
- Fixed error with cell detail
- Fixed error with loading of empty cube.

2019.2
+ Added Cube.SaveExtras to allow saving of Filters and Charts together with cube.
+ Added Config.CubeSettings.StringEncoding to allow load of VCL cubes with Ansi string fields. Set it to appropriate encoding before loading cubes.
+ Added BeforeProgress event to grids
+ Added more items to CubeGrid context menu
+ Added property CubeGrid.FilterManager
+ Added classes UniqueValuesFieldFilterDataProvider, CubeFilterPopup and FilterOrderedRecordSet
* Significantly speedup Excel2007 export for big tables, reduced memory use
* Slice clear resets "Measures" field caption
- Fixed progress form localization
- Fixed localization errors
- Fixed typo in CheckState.Intermediate

Beta 3
+ Add Russian localization
+ Added support for fields drop into AxisZone
+ Code refactoring on visual and non visual parts, added FastCube.Core package
+ Added property TDimensions.DetailValue: Variant - current detail value for totals calculation in script based on sub-total values
+ Added methods Slice.SetTotalPosition(TotalPosition totalPosition) and AxisContainer.SetTotalPosition(TotalPosition totalPosition) to set all totals of slice/axis to one state
+ Added method ContinuousHighlight.SetImageReverseOrder to reverse icons order
* Several slice methods raised Exception with non-active cube. Now we check the cube condition before the action.
- Fixed exception for grid size <= 0
- Fixed error in cube append feature

Beta 2
+ Added script feature
+ Added cube append feature from files, streams and DataSets
+ Implemented measure property ChangeNullToZero
+ Added comments for variety of classes, properties and methods
* Fixed cube file format to properly support unique values memory layout of FastCube .Net (FastCube VCL also supports these format changes now)
- Fixed various errors and glitches here and there