HierCube Library 5.11.0

In category

DB-Aware Components > Other > OLAP

Description

HierCube Library is a set of components for using by software developers, and designed to create fast, comfortable, and powerful OLAP-applications.

HierCube library has its own OLAP-engine made using MOLAP-principle. It allows to form OLAP-views "on-the-fly", not wasting time and memory for intermediate calculations. And for all that the performance of calculating almost doesn't depend on capacity of the cube and depth of hierarchical dimensions. For example the engine processes the fact table holding one million of records for less than a single second. HierCube library doesn't require any OLAP server.

Main features:

• Unicode support
• Supports hierarchical dimensions described by "Parent-Child" relations. Both "balanced" and "unbalanced" hierarchies are supported. No restrictions for the amount of hierarchical levels.
• Supports "snowflake" schema.
• An ability to edit fact table data directly in OLAP-view.
• An ability to show several summaries and several aggregate function at the same time. To compare the values of neighbor cells or calculate cumulative sums can be used sub-functions.
• Calculated dimensions and range-based dimensions. An ability to use a summary as one of the cube dimensions.
• Three types of calculated summaries:
• Calculated from the fact table records
• Calculated using user formulas
• Calculated using user defined aggregate functions.
• Supports dimension attributes. Any field from the dimension table may be read from the fact table as a separate attribute of dimension and used later to describe dimension members more fully.
• Supports supersaturated cubes when one cube cell hold two or more values from the fact table.
• Using all MOLAP advantages with no problems, related with calculating of "sparse" cubes ("database explosion" and "cube sparsity"). HierCube works easy with hundreds of dimensions and, so solves tasks beyond of the strength of most of industrial OLAP-servers. There are no restrictions for the maximum cube capacity.
• High performance and very modest memory requirements: algorithms of calculating "on the fly" allow to process the fact table holding a million of records in a single second (excluding the time of data fetching).
• Works with any successor of standard TDataSet component, no BDE required. Works with unidirectional datasets (that "remember" only current database record) and datasets that "do not know" the full record count of an executed query.
• Supports saving to and reading from any component derived from TStream (including TFileStream). Allows to save the "history of analysis" (in other word different slices of the same cube) and switch between them later.
• Allows to fetch new data from the fact table or full refresh without closing the cube (at that the grid keeps the current slice).
• Supports user groups, sorting, filtering by dimension members. Can filter by any combination of dimension members in any dimension.
• Allows to display the current slice as a diagram (any TChart successor). Source code of the charting component are distributed free.
• Allows to copy the selected grid area into clipboard in different formats.
• Allows to export grid data to many formats: MS Excel (using OLE or directly to XLS-file), HTML, PDF, WMF, RTF, TXT, BMP, XML for Analysis, XML Spreadsheet, ReportBuilder, FastReport, RaveReport. Also supports direct drawing on printer Canvas.
• Easy localization. It is possible to localize the evaluation version as well.
• Supporting OS: Windows 2000 and above.

Informations

• Status: Trial (work while IDE is running)
• Source: SW
• Price: $159
• Source price: $279
• Exe demo: included
• Size: 17 666 091kB

Platforms:

• C++ Builder 2010
• C++ Builder 2006
• C++ Builder 2007
• CBuilder 2009
• C++ Builder 5
• C++ Builder 6
• C++ Builder XE3 64-b
• C++ Builder XE
• C++ Builder XE2
• C++ Builder XE3
• C++ Builder XE4
• C++ Builder XE5
• C++ Builder XE6
• C++ Builder XE7
• C++ Builder XE8
• Delphi 2005 (VCL)
• Delphi 2006 (Win32)
• Delphi 2007 (VCL)
• Delphi 2009
• Delphi 2010
• Delphi 5
• Delphi 6
• Delphi 7
• Delphi XE
• Delphi XE 2
• Delphi XE3
• Delphi XE4
• Delphi XE5
• Delphi XE6
• Delphi XE2 64-bit
• Delphi XE7
• Delphi XE8

Downloads

• C++ Builder 2010 , C++ Builder 2006 , C++ Builder 2007 , CBuilder 2009 , C++ Builder 5 , C++ Builder 6 , C++ Builder XE3 64-b , C++ Builder XE , C++ Builder XE2 , C++ Builder XE3 , C++ Builder XE4 , C++ Builder XE5 , C++ Builder XE6 , C++ Builder XE7 , C++ Builder XE8 , Delphi 2005 (VCL) , Delphi 2006 (Win32) , Delphi 2007 (VCL) , Delphi 2009 , Delphi 2010 , Delphi 5 , Delphi 6 , Delphi 7 , Delphi XE , Delphi XE 2 , Delphi XE3 , Delphi XE4 , Delphi XE5 , Delphi XE6 , Delphi XE2 64-bit , Delphi XE7 , Delphi XE8