1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
  2. Donation with Paypal!!!

    Go to your paypal account and send directly donation to [email protected]

    1 month - 10 $ - Standart VIP

    6 months - 20 $- Standart VIP

    1 year - 30 $- Standart VIP

    2 years - 50 $- Standart VIP

    Gold member for life - 150 $- Standart VIP

    High Vip (Standart VIP include) group please send PM or email to [email protected] for info

    After Donation please send email to [email protected]

  3. Donation Ways 2020


    Paysend
  4. Telegram
Dismiss Notice

Donation with Paypal!!!

Go to your paypal account and send directly donation to [email protected]

1 month - 10 $ - Standart VIP

6 months - 20 $- Standart VIP

1 year - 30 $- Standart VIP

2 years - 50 $- Standart VIP

Gold member for life - 150 $- Standart VIP

High Vip (Standart VIP include) group please send PM or email to [email protected] for info

After Donation please send email to [email protected]

Dismiss Notice
For open hidden message no need write thanks, thank etc. Enough is click to like button on right side of thread.

HierCube v4.5.7 FullSource+Demos+Help

Discussion in 'Delphi Components,Freeware, Open Source' started by AdminDF, Nov 30, 2013.

  1. AdminDF
    Online

    AdminDFAdminDF is a Verified Member Delphifan Staff Member DF Staff

    Main features:
    100% 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. See the list of supported functions on the footnote.
    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). See benchmarks page 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.
    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, RaveReport, ReportBuilder, FastReport. Also supports direct drawing on printer Canvas.
    Easy localization. It is possible to localize the evaluation version as well.
    Supporting OS: Windows 2000 or above.
    Lets review the features which distinguish HierCube library from other products of the same category, not paying attention to standard OLAP-functions like Rotating, Drilling, etc.


    Hierarchical dimensions support. HierCube library supports all types of hierarchical dimensions possible in Data Warehouses. It's possible to combine several flat dimensions into single hierarchical one (support of "snowflake" schema). Also you can define a hierarchical dimension using "Parent-Child" relation in the dimension table. At this time the library is the only "desktop" product supporting "snowflake" schema.


    [​IMG]


    [glow=red,2,300]Download[/glow]
     
    [email protected] likes this.
  2. whitewarriortr
    Offline

    whitewarriortr DF Junior DF Donator

    Teşekkürler.
    Thanks.
     
  3. saedi_mehdi
    Offline

    saedi_mehdi DF Junior

    Teşekkürler.
     
  4. AdminDF
    Online

    AdminDFAdminDF is a Verified Member Delphifan Staff Member DF Staff

    you can write english ;)
     
  5. NikoDelphi
    Offline

    NikoDelphi DF Member

    thanks!
     
  6. arnold99
    Offline

    arnold99arnold99 is a Featured Member DF Junior DF Payment Group

    thanks
     
  7. oespiao
    Offline

    oespiao DF Member

    RE:

    Hiercube for XE3???
     
  8. gnal
    Offline

    gnal DF Member

    RE:

    very thanks
     

Share This Page