A system and method for analytically modeling data from different measure
groups onto a single cube are disclosed. The single cube preferably
includes a first measure associated with a first measure group with a
first set of corresponding dimensions. The single cube preferably also
includes a second measure associated with a second measure group with a
second set of corresponding dimensions. The single cube preferably also
includes each dimension in both the first and second set of dimensions.
Each measure is preferably tied to each corresponding dimension according
to data in an underlying relational data table. Each measure is
preferably tied to each non-corresponding dimension according to an
approximation.