Patent ID: 7257596

Claim:
A method for analyzing direct marketing subscription information comprising: receiving a plurality of direct marketing subscription information, wherein the direct marketing subscription information is not structured hierarchically; archiving the plurality of direct marketing subscription information into a repository; retrieving from the repository a plurality of selected direct marketing subscription information; transforming the plurality of selected direct marketing subscription information into a plurality of transition table format information; populating a facts database with the transition table format information to produce at least one of a plurality of facts tables with a summarization of the transition table format information, wherein the facts tables are structured hierarchically; denormalizing the summarization of the transition table format information to produce a plurality of denormalized information, wherein denormalizing comprises propagating information from one table to another, wherein each of the tables is at a different level of a hierarchical structure based on the hierarchy of the facts tables; and providing a report based upon the denormalized information, wherein the report is provided to a user via a browser application.