HierCube Library is a set of VCL components designed to create fast, handy, and powerful OLAP-applications in different IDE. The library has its own OLAP-engine made using MOLAP-principle, and allows you making OLAP-views "on the fly", not wasting time and memory for intermediate calculations. Calculations performance doesn`t depend on the cube capacity and the depth of hierarchical dimensions. For example, one million records fact table is processed for less than a second. No OLAP server required.
Main features:
- 100% Unicode support
- "Star" or "Snowflake" schemas support
- Hierarchical dimensions of any nesting level, defined with "Parent-Child" relations
- Several flat dimensions grouped into a hierarchical one (composite or multilevel dimension).
- Dimension filters: allows to exclude any members from the current OLAP-view
- Dimension groups: allows to gather any members into a single group during.
- History of OLAP-views: allows "undo", "redo" operations during OLAP-analysis
- Three types of calculated summaries: see data that you really want.
- Different aggregate functions and sub-functions: using different functions to display cube data. Sub-functions display the final result in different ways like displaying % value instead of the function value.
- Supersaturated cubes: no need to group records in the SQL-queries.
- Saving/Restoring: allows to save all cube and/or all OLAP-views in a disk file and restore it back later on.
- Fact table editing: allows to use HierCube library to create cross tabulated tables.
- Displaying current OLAP-slice in a diagram.
- Dimension attributes: displaying additional information given from the dimension table from any member.
- No standard problems of "sparse" multidimensional cubes like "database explosion" or "cube sparsity".
- Vast export functionality: copying to Clipboard, exporting in the most common formats: PDF, RTF, HTML, XLS, CSV, BMP, WMF, and other.
- Easy localization.