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

Overview

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?

License agreement