Using RAMSETCUBE you could manage the metadata of a Data Warehouse also for Mondrian-Pentaho(TM) projects, with a real flexible approach, reducing cycle times for changes, through a secure and user friendly environment. The cube designer techniques offered by RamsetCube permit to manage all the areas of a project maintaining a clear and full vision of relations between objects.
Metadata can be structured by creating or importing tables and relations. In the first case Ramsetcube will send the necessary sql queries against the database, in the second case a logical model will be created to track data. The two criteria can coexist in the same project. During definition of entities, Ramsetcube provides to set up "snowflake" and "star" schemas to be used in cubes. This depends on how data are structured in your DW. Tables with a field code and one to one relations can be defined by the logical model without using trees. This approach makes void the use of hierarchical structures where not essential. As far as concerned time dimensions, they are created just by assigning flags. The role of a level in time dimension is indicated in the XML, due to MDX functions. Trees represent hierarchical models that can be adopted by many cubes at the same time. This is different from other conceptions by which it’s necessary to declare hierarchies for each cube. A cube can also be related with a branch of a tree. This reduce redundancy of duplicated structures. Aggregate tables are built in the same logical object and related to their cube by using a matrix. This allow you to define "lost" and "collapsed" dimensions in a simple and intuitive way, reaching synthesis and control over the project.
ramsetcube is a free software application from the Databases & Tools subcategory, part of the Business category.
The app is currently available in English and it was last updated on 2007-09-02. The program can be installed on Win98, WinNT 3.x, WinNT 4.x, Windows2000, WinXP.
ramsetcube (version 10) has a file size of 4.17 KB and is available for download from our website.
Just click the green Download button above to start. Until now the program was downloaded 128 times.
We already checked that the download link to be safe, however for your own protection we recommend that you scan the downloaded software with your antivirus.