Skip to content

nreco/pivotdata

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

18 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

NReco.PivotData NuGet Release

OLAP library that implements:

  • in-memory multidimensional dataset (PivotData class)
  • OLAP operations: roll-up, slice and dice (SliceQuery class)
  • pivot table data model with efficient totals/sub-totals calculation (PivotTable class)

Official component page: PivotData Toolkit for .NET

Documentation

Examples

  • CsvDemo: how to aggregate data from CSV file
  • DynamicFormulaMeasure: how to define formula-based measure dynamically (with a user-entered string expression)
  • DynamicListGrouping: group objects by multiple fields and calculate aggregates
  • ExcelPivotTable: generates Excel PivotTable by PivotData's PivotTable
  • ParallelCube: how to perform parallel aggregation (use all CPU cores) and merge all results into one resulting cube
  • PivotTableMvc: MVC example that renders simple pivot table / charts (without PivotData Toolkit components)
  • QueryCube: how to make OLAP queries with SliceQuery class: slice, dice, filter, roll-up, calculate derived dimensions and measures

Who is using this?

NReco.PivotData is in production use at SeekTable.com and PivotData microservice. NReco.PivotData is a pre-requisite for PivotData Toolkit components.

License

Copyright 2015-2023 Vitaliy Fedorchenko

Distributed under the PivotData OLAP library FREE license (see src/LICENSE): NReco.PivotData can be used for free only in non-SaaS apps with one single-server production deployment. In all other cases commercial license is required (can be purchased here).