Skip to content

nreco/pivotdata

master
Switch branches/tags

Name already in use

A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Are you sure you want to create this branch?
Code

Latest commit

 

Git stats

Files

Permalink
Failed to load latest commit information.
Type
Name
Latest commit message
Commit time
 
 
src
 
 
 
 
 
 
 
 

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-2022 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).