Patent ID: 7580944

Claim:
A method comprising the steps of: defining a first interface of a logical model architecture comprising one or more dimensions and/or measures; defining a second interface of said logical model architecture comprising metrics, and associations between said metrics and said one or more dimensions and/or measures; defining a third interface of said logical model architecture comprising a plurality of user data requirements corresponding to at least one of said metrics and at least one of said dimensions and/or measures; defining, a first set of transformations of said logical model architecture via a computing device, comprising one or more transformations to map source data items to said one or more dimensions and/or measures of said first interface; defining, a second set of transformations of said logical model architecture via the computing device, each transformation of said second transformation set corresponding to at least one of said user data requirements and communicated to a data repository maintained on a computer-readable storage medium for populating the data repository with data to satisfy said corresponding user data requirement; defining, via the computing device, at least one star graph having nodes, each node corresponding to a star identifying at least one of said dimensions, each of said dimensions identified in said star belonging to a dimension hierarchy, an edge between two nodes representing one or more aggregation operations such that each node corresponds to a level of aggregation for each of said dimensions identified by said star; and traversing the star graph so as to determine said level of aggregation level for a metric corresponding to star.