Patent ID: 7305408

Claim:
A system, comprising; a hierarchy processing module for aggregating data up a hierarchical data structure; a dimension splitting module for creating pseudo-hierarchical data structures from data within the hierarchical data structure, the dimension splitting module providing cross attribute analysis and manipulation in online analytical processing and multi-dimensional planning applications, the dimension splitting module creating, for members of a single level of a dimension, one or more attribute dimensions based on values of attributes of several types, wherein the attributes are valid for the members of the single level of the dimension, and the single level and any lower levels of the single level are inactive, a dimension corresponding to an attribute of data contained within the hierarchical data structure; and a multi-dimensional data viewing module for displaying a set of multi-dimensional data according to the hierarchical data structure in a multi-dimensional spreadsheet, where dimension splitting includes one or more of, selectively re-arranging one or more data elements in hierarchical organization, selectively re-organizing one or more data elements in hierarchical organization, or selectively relocating one or more data elements in hierarchical organization.