摘要 |
An electronic spreadsheet system of the present invention includes a Data Modeling module for creating multi-dimensional reports from spreads of information. The module includes a preferred report workspace interface-a Data Modeling Desktop-for receiving a user-specified range of source data from an electronic spreadsheet, which may include 2-D as well as 3-D ranges of source data from a spreadsheet notebook. In response to user inputs, the system assembles a corresponding multi-dimensional report by transforming 2-D or 3-D spreadsheet information into multi-dimensional format. In this manner, users can continue to build spreadsheet models on an ad hoc basis (i.e., without designing complex multi-dimensional data models beforehand). When multi-dimensional reporting is desired, the users need only indicate to the system that the then-existing spreadsheet information (which is not in multi-dimensional format) is to be automatically converted by the system into a corresponding multi-dimensional structure, for further analysis and reporting.
|