Patent ID: 7523124

Claim:
A method to format data received from a data warehouse comprising: receiving an analysis instruction; retrieving data with a communication interface from the data warehouse based on the analysis instruction, wherein the data is stored in a computer memory; creating with a data formatter a hierarchical directory file path structure, a first hierarchical directory file path, a second hierarchical directory file path and a third hierarchical directory file path; associating a mapping file with a fact table, the mapping file stored by an organizer in the first hierarchical directory file path, the fact table comprising a primary key associated by the organizer with a dimension table, the dimension table associated with a dimension mapping file stored in the second hierarchical directory file path, the dimension table further comprising a dimension key associated by the organizer with a data file stored in the third hierarchical directory file path; and initiating a data query with a warehouse extractor via sequential navigation from the first hierarchical directory file path, to the second hierarchical directory file path, to the third hierarchical directory file path.