Patent ID: 7313559

Claim:
A computer readable medium having stored thereon computer-executable instructions, that, when executed by a computer, cause the computer to perform steps comprising: generating a data cube that comprises at least three dimensions, one of the dimensions being a first dimension that represents a first hierarchy comprising a first plurality of levels, the first plurality of levels comprising a root level, at least one intermediate level, and a leaf level; responsive to a command, splitting the first dimension into two dimensions by: dividing the first hierarchy into a first sub-hierarchy and a second sub-hierarchy, whereby the root level of the first hierarchy becomes a root level of the first sub-hierarchy, a single one of the intermediate levels of the first hierarchy becomes both a leaf level of the first sub-hierarchy and a root level of the second sub-hierarchy, and the leaf level of the first hierarchy becomes a leaf level of the second sub-hierarchy; adjusting the first dimension such that the first dimension represents only the first sub-hierarchy rather than the complete first hierarchy; and adding an additional dimension to the data cube to represent the second sub-hierarchy; and populating the data cube with data according to each dimension of the data cube including the additional dimension; receiving a query that requests a portion of the data populated within the data cube including the additional dimension; processing the query; and displaying query results to a user.