PivotCube VCL is a set of visual components for OLAP analysis and reporting
FEATURE:
Tree-like (Hierarchical) dimensions
This feature allows working with not only linear dimensions, but with hierarchical dimensions as well. We call them “ Tree-like” because they are built like standard hierarchical structures – trees, good known to all Windows users (structure of directories is built like trees). So you can easily build dimensions which structure is branched like Windows directories and the quantity of nodes and leafs of the tree is unlimited. Both nodes and leafs can be embedded into nodes without any limitations up to 255 nested levels. End-user can easy build(define) own hierarchies for any dimension at runtime, save these hirarchies into Slice file and restore them when it needed. In that manner he can define various hierarchies for same dimension. For examle, dimension Ware can be structured by Ware-type or Ware-manufacturer etc.
Extended set of statistical functions support.
To use this feature you need to build supersaturated cube. But before start building you need to set PivotCube.ExtendedMode to True. If one cube cell holds many values from the fact table - calculations of statistical functions get complicated. But nevertheless PivotCube provides calculations based on full data set without simplifying transformation of data. This allows calculating True function values regarding current filter sets. Unique thing of this feature is exact PivotCube calculations in contrary to calculations based on simplifying statistical formulas. So with PivotCube you always get True calculations as a result.