摘要 |
The present invention relates to a system and method for preparing Excel-based analysis reports, which involve processing basic data stored in a database and preparing analysis reports or a screen on the basis of the Excel program. The system comprises: a DB object generating unit which takes, as an input, an SQL sentence for querying a database from a user, and generates a DB object for the SQL sentence; a cache-generating unit, which generates a pivot table cache on the basis of the DB object; a display object preparing unit which provides the user with an Excel object preparing tool, and receives, from the user, an Excel display object prepared by the user, wherein data referenced by the Excel display object are dependent on the pivot table cache; and a meta-information generating unit, which generates meta-information for a report, containing the Excel display object and the DB object. According to the above-described system and method for preparing Excel-based analysis reports, users may prepare reports using a display system of the Excel program which is well-known to office workers. Thus, users may easily extract necessary information from the data stored in the database, and easily prepare reports and online analytical processing (OLAP) screens having various formats. |