100% runtime managed code.
Requires no OLAP-servers to work. It's possible to install the Library on any web site with ASP.NET support.
An ability to create any multidimensional cube at the time when application is running. Cubes may be created dynamically on the base of any queries from different tables.
Easy settings. The component doesn't require disk space to hold temporary OLAP-data.
Calculation "on the fly".
Comfortable interacting. Users may perform all operations no need to use intricate expressions of MDX-language.
Automatic updating of OLAP-cube in background mode. Users are still able to work with the cube while it's being updated, so they will not even notice that something's happening until the cube updating has finished.
Supports user groups, sorting, filtering by dimension members. Can filter by any combination of dimension members in any dimension.
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 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 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.
Can use DataSet objects or any other classes supporting IDbCommand interface (for example SqlCommand, OleDbCommand, or OracleCommand).
Programming control of the cube on any of .NET languages: creating cube in run time, access to statistical information, full control of cube updates and actions of users.
Can save "the history of analysis" (or history of views) with the ability to switch between the saved stages of analysis.
Allows to export grid data to many formats: MS Excel (XLS-file), HTML, PDF, WMF, RTF, TXT, BMP, XML for Analysis, XML Spreadsheet.
Easy localization. It is possible to localize the evaluation version as well.
Supporting platforms:
Server: NET Framework 1.1 or higher
Client: Microsoft Internet Explorer 5.5 or higher |
