Abstract: The 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 and method takes an SQL sentence for a database from a user; generates a DB object for the sentence; generates a pivot table cache on the basis of the DB object; and receives an Excel™ display object prepared by the user, wherein data referenced by the Excel™ display object are dependent on the pivot table cache; and generates meta-information for a report, containing the Excel™ display object and the DB object. According to the invention, users may prepare reports using the Excel™ well-known to office workers. Thus, users may easily extract necessary information from the database, and prepare reports and online analytical processing (OLAP) screens having various formats.