RadarCube for VCL

Powerful OLAP components for Delphi and RAD Studio. Many features and great perfomance. Can work with any relational database to build a multidimensional cube or connect to the MS Analysis Services server.

Try for free

Features

Look to the future

All OLAP components can work with flat dimensions. Flat dimensions, a single table as the data source. The dawn of the OLAP analysis. Developers' algorithms far from perfection, no analytical experience, mid of the nineties. Past century.

But the time goes forward. The Star schema: a fact table, several dimension tables. De facto, it is a standard for those who does not need more. But the step forward was made, and the question was asked: Is it possible to use dimension tables with the hierarchy structure during the OLAP analysis? Except for "Yes", OLAP developers had no other answers. In that way, hierarchy dimensions appeared and with them - new long-expected opportunities for the OLAP analysts.

The next step, no less logical, is the snowflake schema in the data warehouse. It is logically to band together the fields Year, Month and Day, or Products and Products Categories. For the OLAP developers these are the multilevel dimensions.

Fortunately, RadarCube involves all aforesaid hierarchy types taking into consideration their differences. Moreover, RadarCube allows working with them not only separately but in complex making it possible unprecedented: building the multilevel dimensions, each level of which can contain its own hierarchy. If someone will ask you: Why so complicated? Just answer: It's not complicated but naturally. There are 5000 members in your hierarchy, then why so much? It is better to group 4980 not relevant members in the group More, and then your report will become clearer to your investors. And to place the group More next to the rest of the 20 members - it is so natural, right?

Key features: Desktop version. Cube definition

  • Support of the following data sources:
    • A single table or query of any database (any TDataSet successor, no BDE required);
    • o Several tables or queries of any database organized into the "star" or "snowflake" schema (any TDataSet successors, no BDE required);
  • Support a set of aggregation functions, such as Sum, Count, Distinct Count, Min, Max, biased or unbiased variance, median and so on. Supports custom aggregation functions.
  • Support of numbers, strings and dates as measure values.
  • Support of measure grouping.
  • Support of all cube structure elements of Enterprise OLAP servers (dimensions, hierarchies, hierarchy levels and their relations). You can build the cube in the Desktop OLAP, and then, when increasing the size of tables, to port the Desktop cube into the MS Analysis cube, at that the logical structure of the cube will remain unchanged.
  • Support of hierarchies of three types:
    • Parent-child hierarchies;
    • Multilevel hierarchies;
    • Mixed from both previous types.
  • An ability to create calculated measures, dimensions, hierarchies and hierarchy levels based on the data both as the fact table rows and all dimension tables rows related to it with the foreign keys.
  • An ability to create additional calculated measures, using both the information from the fact table and values of the aggregated cube cells.
  • Support of calculated members of dimensions or hierarchies.
  • Support of dimension or hierarchy attributes which store additional information about dimension or hierarchy members.
  • Support of supersaturated cubes when one cube cell holds two or more values from the fact table.

Key features: MSAS version. Cube definition

  • Support of the Microsoft Analysis Server 2000 or above.
  • Support of all cube structure elements of MS AS (dimensions, hierarchies, hierarchy groups, measure groups, hierarchy levels and hierarchy attributes)
  • Support of hierarchies of four types:
    • Parent-child hierarchies;
    • Attribute hierarchies;
    • Parent-child hierarchies;
    • Multilevel hierarchies;
    • Mixed from both previous types.
  • An ability to create additional calculated measures on the client or server side, using both the information from the fact table and values of the aggregated cube cells.
  • Support of additional calculated members of hierarchies on the client or server side.

Key features: Data visualization

  • Unicode support.
  • An ability to display many measures in the Grid simultaneously.
  • Interactive drill-down support of all types of hierarchies separately for every grid cell.
  • Support of "Undo" and "Redo" actions during the OLAP analysis.
  • Support of saving and restoring the current OLAP slice.
  • Support of member grouping on any hierarchy level without changing the hierarchy levels structure.
  • Support of sorting on any level of hierarchy or dimension separately. Ability of overriding any sorting method.
  • Support of ascending or descending sorting based on any column value in the OLAP grid.
  • Support of filtering any set of hierarchy members with or without applying these filters in the OLAP calculations.
  • Support of the auto filtering of the hierarchy members depending on their values in the grid. An ability for selection some major/minor members, either according to their rank or on the Pareto principle.
  • An ability to display in the grid not only the values of the measures but a percent value regarding totals, subtotals, or grand totals. An ability to create your own context-sensitive rules on measure display (for example, a cumulative sum of measure values for time dimensions, and just its value for all other cases).
  • The auto image drawing in any grid cell, the auto picture positioning in a cell, depending on the parameters assigned by a programmer.
  • A complete data output control, a feature for the arbitrary drawing in the grid cells.
  • Support of the custom drawing on the grid cells.
  • Support of the custom popup menus in the grid.
  • Support of the drag-n-drop of measures or hierarchy members within the grid.
  • Auto wrapping of the cell contents depending on its width. Auto sizing of the column width with auto wrapping for the very "long" cells of the grid.
  • An ability to edit OLAP data directly in the grid ("writeback" support).
  • Allows to display the current slice as a diagram (any TChart successor). Support of Drill-down actions in the chart. The source code of the charting component comes for free.
  • Allows to copy the selected grid area into the clipboard. Support all common office clipboard 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. Exports to the RaveReport, ReportBuilder, FastReport are coming soon. Also supports direct drawing on printer Canvas.
  • Easy localization. It is possible to localize the evaluation version as well.