摘要 |
A method and apparatus are discussed that allow the user to view advanced data-based pivot tables in spreadsheet or other database accessing programs from any relational database without requiring a server side on-line analytical processing (OLAP) service in place. To obtain this degree of freedom a temporary multidimensional file is created on the local machine that is a snapshot of the data currently in the relational database. The pivot tables then interact with this temporary file to provide the data to the user.
|