Effective OLAP components for VCL-developers
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.
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