Available from Virtual Cube Solutions
One of the major differentiators of our solutions lies in the speed at which a virtual cube representation can be designed. The Virtual Cube Designer (VCD) is a wizard that performs the data profiling needed to understand the structure of the star schema used as a source.
A user can either select a preconfigured ODBC data source or provide a valid connect string to establish a connection to the database containing the star schema. From there, he simply has to select the fact and dimension tables. The VCD will then execute a number of data profiling queries that will enable it to understand the structure of the star schema, thus identifying the fact table, the dimension tables, the relationships between facts and dimensions tables as well as the nature of the relationships between the various fields composing the aforementioned dimension tables.
Upon completing this data profiling step, the VCD will be able to detect every possible hierarchy within each dimension as well as the key and description fields of every table within the star schema. This ability greatly diminishes the work that needs to be done by the user since the user's major role consists of confirming (and modifying in some rare instances) the wizard's findings and selecting the elements (hierarchies, fields, etc.) that will be included in the vCube.
Using the VCD, users can also enrich their model by adding hierarchical levels on top of the metrics of the fact table and by adding calculated facts.