Patent ID: 7275022

Claim:
A method implemented at least in part by a computer, the method in combination with first and second tables of data, the first table organizing a first type according to a first attribute and a second attribute, and a second table organizing a second type according to the first attribute, the method comprising: modeling a measure according to the second type of the second table; modeling a first dimension according to the first attribute of the first and second tables; modeling a second dimension according to the second attribute of the first table; tying the measure to the first dimension according to the first attribute of the second table to allow the measure to access data for the first dimension according to the first attribute; tying the measure to the second dimension by, for each entry of the first dimension, allocating a value of the measure for the entry of the first dimension by: identifying each row in the first table within which a value of the first attribute matches a value of the entry of the first dimension, the first table including no data for the measure; identifying a value of the second attribute within each identified row in the first table; identifying each entry in the second dimension for which a value of the entry of the second dimension matches an identified value of the second attribute; and allocating at least a portion of the value of the measure for the entry of the first dimension to at least one of each identified entry of the second dimension; and generating and displaying a data cube that comprises the measure and the first and second dimensions, the data cube being used for analytically modeling data from at least the first and second tables.