This page was generated automatically from The Delphi Super Page archive. If you have any remarks concerning this page please do not hesitate to mail me.
In your mail please do refer to your unique DSP author ID which is 0004095. This helps me to locate your data records in DSP databse.
 
Author/SiteName(Contact)e-mailHome Page
  RainbowSoft (RainbowSoft) [email][Home]

    HierCube library is similar to standard Decision Cube library but has the greater universality and gives some additional opportunities for the analysis of the multidimensional data (OLAP analysis). HierCube library allows: - Working with hierarchical dimensions. - An ability to show several summaries, many aggregate and comparing functions at the same time. - The maximum cube capacity is about 10^18 cells. The cube capacity and the amount of its dimensions do NOT have a influence upon its working speed. - High performance and low memory consumption: the cube with the capacity 10^16 cells (16 dimensions) and 100 000 records in the fact table calculates in 10 seconds. - Works with any successor of standard TDataSet component or load Cube data from saved file. No BDE required. - Hiding/showing any member of any dimension in the cube. - The flexible export to MS Excel, HTML and QuickReport. - Multilanguage support.

 

 

Files

[ HierCubEval420.zip ] [ 8,014,844 bytes ] [ Shareware ] [ No Source ]
[ D5 | D6 | D7 | D2 | C5 | C6 ]
HierCube library is an OLAP-tool that allows to work easy and comfortably with OLAP representations of data warehouses. HierCube library is desktop OLAP engine and can work with any server or local databases. The algorithms realized in HierCube library allow to process database tables consisted of millions of records and tens of dimensions. Though HierCube library is based on MOLAP- technology it's devoid of many of shortcomings of the technology such as "database explosion" or "cube sparsity". HierCube library can work with enormously sparse cubes of capacity of 10^250 cells and more, and so easy solves the tasks that many enterprise OLAP-servers such as OLAP Express and MS AS don't cope with. The main of HierCube library features are: - Working with hierarchical dimensions. It supports both "balanced" and "unbalanced" hierarchy with unlimited hierarchical levels count. - Support of "snowflake" schema. - An ability to edit multidimensional data directly in the grid and update the base fact table in the database. - An ability to show several summaries and aggregate functions at the same time. To compare the function values sub-functions can be used. - An ability to calculate a correlation coefficient of two summaries. - Calculated dimensions and range-based dimensions. An ability to use a summary as a dimension. - Three types of calculated summaries: -- calculated from fact table records; -- calculated by user formulas; -- calculated by user aggregation functions. - Different attributes for dimensions. If you have several fields in a dimension table each of them can be used to describe dimension members. - Supports supersaturated data cubes when one cube cell holds many values from the fact table. NO initial data grouping is performed, so there is no data distortion for statistic calculations. - Though HierCube library is based on MOLAP- technology it's devoid of many of shortcomings of the technology such as "database explosion" or "cube sparsity". HierCube library can work with enormously sparse cubes of capacity of 10^250 cells and more, and so easy solves the tasks that many enterprise OLAP-servers such as OLAP Express and MS AS don't cope with. The maximum cube capacity is unlimited. - Uses the algorithm of calculating of subtotal values and checking the result that brings to naught the possibility of wrong result. - High performance and low memory consumption: because of the unique algorithm of calculating of subtotal values the cube with the capacity 10^18 cells (10 dimensions) and 250 000 records in the fact table calculates in 3 seconds. The cube capacity and the amount of its dimensions do NOT have an influence upon its working speed. See benchmarks for details. - 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. - Works with the file as if it was an ordinary DataSet. This feature allows you to create applications for OLAP-analysis without database connection at all. - A possibility to update the cube downloading new data from the fact table without reactivating the cube. - The custom dimension members grouping, sorting and drilling for different dimensions. - Displaying the current grid situation in the diagram. Source code of diagram component is within free access. - The flexible export to: MS Excel (using OLE or directly to XLS-file), HTML, PDF, WMF, RTF, XML for Excel, XML for Analysis, QuickReport, ReportBuilder, FastReport, RaveReport and printer canvas. - Easy localization
Added: 23-08-2004/31-01-2005   |  Version: 4.20   |  Downloads: 173/169/3
Author:RainbowSoft   RainbowSoft   [Homepage]   [DSP files]

 

1995-2006 Robert M. Czerwinski ( The Delphi Super Page a.k.a. DSP ).
All rights reserved.