Cross-Functional Analysis By Time

To allow for cross-functional analysis by time, different Facts were joined to the time dimension using canonical date. For example, Invoice Amount from Invoice Fact and Payment Amount from Invoice Installment Fact can be analyzed using Gregorian Calendar Time Dimension. Role-playing Time Dimensions can also be used to perform cross-functional analysis. For example, GL Accounting Date in Financials can be used to reconcile the amounts between Accounts Payable and Accounts Receivable, SubLedger Accounting, and General Ledger.