SYSTEM AND METHOD FOR CROSS ATTRIBUTE ANALYSIS AND MANIPULATION IN ONLINE ANALYTICAL PROCESSING (OLAP) AND MULTI-DIMENSIONAL PLANNING APPLICATIONS BY DIMENSION SPLITTING

摘要

A system (400) for cross attribute analysis for sales data in a multi-dimensional planning system. The system (400) includes a set of processing modules (416) that performs cross attribute analysis and manipulation in online analytical processing (OLAP) and multi-dimensional planning applications (436) dimension splitting. A number of processing module are utilized to perform the required processing. The system (400) includes 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, and a multi-dimensional data viewing module for displaying a set of multi-dimensional data set according to the hierarchical data structure in a multi-dimensional spreadsheet. A single dimension corresponds to an attribute of the data contained within the hierarchical data structure.