I am trying to create a data warehouse from scratch starting with Trial Balance reporting in a multidimensional form.
The tables I have in my staging area are:
-General Ledger Accounts (Account Balances with daily snapshots of closing balances)
-General Trans Accounts (Detailed transaction linked at the line level indicating debit and credit values)
-Business Entity (Details of each line of business linked to chart of account sub_prod_id)
-Chart of Accounts
-GL Mapping (GL Codes mapped to Chart of Accounts)