The vCube add-in is a simple yet very powerful query generator that provides unsurpassed ad-hoc analysis capabilities when querying relational data marts from within Microsoft Excel. These queries are built by placing various dimension labels in different spreadsheet cells. These labels can either be keyed-in by the user or they can be inserted using a member selection wizard that facilitates navigation within the various dimensions and hierarchies composing the virtual cube.
The add-in will then parse the sheet and determine what data elements are requested by the user according to the layout of the aforementioned dimension member labels. This very flexible approach allows the easy creation of countless different report layouts since every dimension can be positioned as either, a page, a column or a row dimension depending on the type of analysis being performed by the user. Furthermore, the vCube add-in treats the facts contained within the underlying relational data mart as another dimension, which bring an extra level of flexibility that even some OLAP products do not provide.
Structure navigation featuresThe current release of vCube allows the following functions: