For creating OLAP Software time-proved and natural VCL OLAP Elements. Works using a data source such as a fact table, which makes it more comfortable to configure block construction. Supports composite (multilevel) and hierarchical measurements. Complete Unicode innovative export skills and support.
- Supports hierarchical dimensions described by "Parent-Child" relations. The two"balanced" and"unbalanced" hierarchies are encouraged—no limitations to the amount.
- Supports "snowflake" schema.
- A capability to edit fact table data directly in OLAP-view.
- An ability to show several summaries and many aggregate functions in precisely the same moment. Compute sums to evaluate the values of neighbor cells can be utilized sub-functions.
- Calculated measurements and range-based measurements. An ability to use a list.
- Three Kinds of calculated summaries:
- Calculated in the table records
- Calculated using consumer formulas
- It is calculated using user-defined aggregate works.
- Supports dimension features. Any area from the measurement table could be read as a distinct attribute of measurement by the table and used to explain dimension members more completely.
- Supports supersaturated cubes when one cube cell holds a couple of values in the table.
- We are employing all MOLAP benefits without any issues associated with calculating "sparse" cubes ("database explosion" and"cube sparsity"). HierCube thus solves tasks beyond almost all of the industrial OLAP-servers' potency and works simply with hundreds of measurements. There are no limitations to the maximum cube capacity.
- High performance and minimal memory requirements: calculations of calculating"on the fly" let to process the table carrying a million documents in one minute (excluding the time of information fetching).
- Works with almost any successor of regular TDataSet part, no BDE is needed. Works with unidirectional datasets (which"recall" only existing database document ) and datasets which"don't understand" that the complete listing count of an executed query.
- Supports saving to and reading from some other part derived from TStream (such as TFileStream). Allows to keep the"background of investigation" (in other words, different pieces of the identical block ) and switch between them afterward.
- Allows fetching new data in the table or complete refresh without shutting the block (at the grid retains the current slice).
- Supports user groups, sorting, filtering by dimension members. Can filter by any combination of dimension members in any dimension.
- Enables copying the chosen grid space into clipboard in various formats.
- Enables exporting grid information to a Lot of formats: MS Excel (using OLE or straight to XLS-file), HTML, PDF, WMF, RTF, TXT, BMP, XML for Analysis, XML Spreadsheet, RaveReport, , FastReport. Additionally supports drawing printer Canvas.
- Easy localization. It's possible to localize the test version.