A system and method for analytically modeling data organized according to
non-referred attributes is disclosed. Data stored in a first and a second
relational data table is analytically modeled in a data cube. The first
table organizes a first type according to a first attribute. The second
table organizes a second type according to the first attribute and a
second attribute. A first measure is modeled according to the first type
of the first table. A first dimension is modeled according to the first
attribute of the first and second tables. A second dimension is modeled
according to the second attribute of the second table. The first measure
is tied to the first dimension according to the first attribute of the
first table to allow the first measure to be analyzed by the first
dimension according to the first attribute. The first measure is tied to
the second dimension by, for each entry of the first dimension,
allocating the entry to each entry of the second dimension in a
predetermined manner.