What's new in PivotDataTool 1.2.4
Dec 12, 2015
- Added PivotTable.PreserveGroupOrder option: when enabled sort by value reorders rows/columns only inside groups.
- now PivotData works in lazy totals mode by default (this is backward-compatible change)
- added SortAsComparer for defining explicit order of pivot table rows or columns
- fixed NaturalSortKeyComparer for case when dimension has keys of different types: in this case it fallbacks to compare string equivalents of the keys
- added NaturalSortKeyComparer.ReverseInstance
New in PivotDataTool 1.2.3 (Dec 12, 2015)
- moved SliceQuery from extensions (PivotData Toolkit) to NReco.PivotData assembly. SliceQuery can be used for querying data cube in linq-style.
- PivotTable class: added PivotData property for accessing underlying data cube, added SortRowKeys/SortColumnKeys overloads for specifying measure index (for pivot tables with several measures)
- Overloaded ToString in IAggregatorFactory implementations (used for getting human-readable measure names)
- now NReco.PivotData.dll is a signed (strongly named) assembly
New in PivotDataTool 1.2.1 (Dec 12, 2015)
- added PivotData.CopyTo for custom merge/slice cube operations
- added PivotTableMD class for creating n-dimensional (n>2) pivot table views
- added overloads for PivotData/PivotTable that accept custom comparers of dimension keys
- changed LazyTotals mode behaviour: now accessing grand-total value doesn't force calculation of all sub-totals (reason out-of-memory exception for large cubes)
- a lot of other minor changes/fixes
- introduced IPivotTable interface
- improved PivotData performance and decreased memory consumption
- Public API wasn't changed and 1.2.1 assumed to be backward compatible with 1.2.0.
- Special thanks to Colin (XLcubed.com) for code changes used in this release.
New in PivotDataTool 1.2.0 (Dec 12, 2015)
- fixed issue with PivotData.Merge behavior (totals)
- fixed issue with PivotData.ProcessData in lazy totals mode
- added fast Serialize/Deserialize methods for PivotDataState
- added Slice method for PivotData (reduce dimensions / filter data)
- significantly improved performance and decreased memory consumption (Key class is no longer used for wrapping key objects)
- added CsvDemo example (aggregates data from csv file)
- Note: PivotData API was changed (again!) and your code might need some (minor!) changes for migrating from 1.0.x/1.1.0.
New in PivotDataTool 1.1.0 (Dec 12, 2015)
- dimension keys are sorted by default
- added lazy totals calculation mode
- added CompositeAggregator (enables ability to use several aggregators at once)
- now PivotData dimensions are determined by single key
- added PivotTable 2D view (slice) for PivotData. Supports: several dimensions for table rows/columns, sort row/columns by table values.
- Note: PivotData API was changed and your code might need some minor changes for migrating from 1.0.x.
New in PivotDataTool 1.0.1 (Dec 12, 2015)
- added serializable PivotDataState + save/load routines
- added min/max aggregators
New in PivotDataTool 1.0 (Dec 12, 2015)
- optimized totals calculation in batch processing model
- merge operation for map/reduce usage scenario (parallel/distributed cube calculation)
- basic set of aggregators: avg, count, count uniq / list uniq