Patent Document ID: 9684703
Application ID: 11115475
Patent Flag: 1

Claim One:
1. A method of constructing a data warehouse that combines data from multiple financial accounting transactional ledgers into a single fact table; including the following steps of: (a) connecting to an Enterprise Resource Planning (ERP) data store that stores the multiple financial accounting transactional ledgers, wherein the multiple financial accounting transactional ledgers are a classification and summarization of financial transactions, and the multiple financial accounting transactional ledgers include General Ledger, legally required for audits, and one or more of the following ledgers: Sales (Accounts Receivable), Purchase (Accounts Payable), Invoice (Order Processing), Inventory, and Fixed Assets; (b) using Structured Query Language (SQL) scripts to extract and combine data from the multiple financial accounting transactional ledgers existing in the ERP data store, including the general ledger, to automatically create and populate a single fact table in the data warehouse which integrates transactional data from the multiple financial accounting transactional ledgers; (c) generating, from the data warehouse, an associated, single physical Online Analytical Processing (OLAP) cube such that the single physical OLAP cube enables cross-functional analysis of data from the multiple financial accounting transactional ledgers; (d) executing stored procedures against the data warehouse to determine various metadata structures required to create or update the single physical OLAP cube to facilitate analysis and reporting of the data, wherein the stored procedures take as parameters a list of new fields to be added to the data warehouse, and the stored procedures loop through the list of new fields and add each field in the list into appropriate tables in a star schema in the data warehouse.