Ramsetcube Ramsetcube is an OLAP tool to create metadata in Mondrian, taking tracks of the entire project.
Architecture Ramsetcube Architecture is based on ETC-metadata model which is different from EC-metadata model. In the first case olap cubes are relationated to trees by external assignments, in the second case cubes are designed also by declaring trees.
More specifically:
*E: where create or import entities and their descriptions *T: where define trees *C: where define cubes
Matrix definitions Ramsetcube uses a matrix representation by which declaring the aggregate tables of a cube. A matrix is a rectangular array of cells. Columns correspond to aggregate tables and rows to cube axis. The "lost" and "collapsed" dimensions are created by flagging cells into the matrix, for this reason an aggregate table remains in the same logical object.
Relations between trees and cubes Trees are joined to cubes into two different type of relations the "logical" and the "physical" one:
*Physical: When there is a direct relation between cube and a child of its tree *Logical : When there is an indirect relation between a cube and the parent of its tree through a physical relation. This modular approach permits to change the logical model with consequent autoupdates in cubes structures.
|