3 Relationship Diagram

Overview

This chapter provides diagrams that define the logical relationship of a Fact table with different dimension tables. Refer to the Tables section for information regarding the join conditions between the Fact tables and dimensions.

Relationship Diagram Details

Assets

DW_FA_ASSET_FINANCIALS_CF

This data model represents the DW_FA_ASSET_FINANCIALS_CF relationships with Dimensions.

DW_FA_SLA_TRANSACTIONS_CF

This data model represents the DW_FA_SLA_TRANSACTIONS_CF relationships with Dimensions.

Expenses

DW_EMPLOYEE_EXPENSE_CF

This data model represents the DW_EMPLOYEE_EXPENSE_CF relationships with Dimensions.

Figure 3-1 ER_DW_EMPLOYEE_EXPENSE_CF

General Ledger

DW_GL_BALANCE_CA

This data model represents the DW_GL_BALANCE_CA relationships with Dimensions.

Figure 3-2 DW_GL_Balance_CA

Description of "Figure 3-2 DW_GL_Balance_CA"

DW_GL_BALANCE_CF

This data model represents the DW_GL_BALANCE_CA relationships with Dimensions.

Figure 3-3 DW_GL_BALANCE_CF

Description of "Figure 3-3 DW_GL_BALANCE_CF"

DW_GL_BUDGET_BALANCE_CF

This data model represents the DW_GL_BUDGET_BALANCE_CF relationships with Dimensions.

DW_GL_BUDGET_CF

This data model represents the DW_GL_BUDGET_CF relationships with Dimensions.

Description of the illustration er_dw_gl_budget_cf.svg

DW_GL_BUDGET_F

This data model represents the DW_GL_BUDGET_F relationships with Dimensions.

Figure 3-4 DW_GL_BUDGET_F

Description of "Figure 3-4 DW_GL_BUDGET_F"

DW_GL_BUDGET_BALANCE_CF

This data model represents the DW_GL_BUDGET_BALANCE_CF relationships with Dimensions.

DW_GL_JOURNAL_CA

This data model represents the DW_GL_JOURNAL_CA relationships with Dimensions.

Figure 3-5 ER_DW_GL_JOURNAL_CA

Description of "Figure 3-5 ER_DW_GL_JOURNAL_CA"

DW_GL_JOURNAL_CF

This data model represents the DW_GL_JOURNAL_CF relationships with Dimensions.

Figure 3-6 ER_DW_GL_JOURNAL_CF

Description of "Figure 3-6 ER_DW_GL_JOURNAL_CF"

DW_GL_VARIANCE_CF

This data model represents the DW_GL_VARIANCE_CF relationships with Dimensions.

DW_GL_SLA_RECON_CF

This data model represents the DW_GL_SLA_RECON_CF relationships with Dimensions.

Payables

DW_AP_HOLDS_CF

This data model represents the DW_AP_HOLDS_CF relationships with Dimensions.

Figure 3-7 ER_DW_AP_HOLDS_CF

Description of "Figure 3-7 ER_DW_AP_HOLDS_CF"

DW_AP_SLA_AGING_INVOICE_CA

This data model represents the DW_AP_SLA_AGING_INVOICE_CA relationships with Dimensions.

DW_AP_SLA_AGING_SUPPLIER_CA

This data model represents the DW_AP_SLA_AGING_SUPPLIER_CA relationships with Dimensions.

DW_AP_SLA_EXPENSE_DIST_CF

This data model represents the DW_AP_SLA_EXPENSE_DIST_CF relationships with Dimensions.

DW_AP_SLA_INVOICE_SCHEDULE_CF

This data model represents the DW_AP_SLA_INVOICE_SCHEDULE_CF relationships with Dimensions.

DW_AP_SLA_LIAB_PMT_CA

This data model represents the DW_AP_SLA_LIAB_PMT_CA relationships with Dimensions.

DW_AP_SLA_LIAB_PMT_CF

This data model represents the DW_AP_SLA_LIAB_PMT_CF relationships with Dimensions.

DW_AP_SLA_LIABILITY_DIST_CF

This data model represents the DW_AP_SLA_LIABILITY_DIST_CF relationships with Dimensions.

DW_AP_SLA_PAYMENTS_CF

This data model represents the DW_AP_SLA_PAYMENTS_CF relationships with Dimensions.

Projects

DW_PROJECT_COST_CF

This data model represents the DW_PROJECT_COST_CF relationships with Dimensions.

DW_PROJECT_SLA_COST_CF

This data model represents the DW_PROJECT_SLA_COST_CF relationships with Dimensions.

Purchasing

DW_AGREEMENT_CF

This data model represents the DW_AGREEMENT_CF relationships with Dimensions.

DW_INVOICE_SPEND_CF

This data model represents the DW_INVOICE_SPEND_CF relationships with Dimensions.

DW_PURCHASE_ORDER_CF

This data model represents the DW_PURCHASE_ORDER_CF relationships with Dimensions.

DW_RCV_SHIPMENTS_CF

This data model represents the DW_RCV_SHIPMENTS_CF relationships with Dimensions.

DW_REQUISITION_CF

This data model represents the DW_REQUISITION_CF relationships with Dimensions.

Receivables

DW_AR_SLA_ADJUSTMENTS_CF

This data model represents the DW_AR_SLA_ADJUSTMENTS_CF relationships with Dimensions.

DW_AR_SLA_AGING_CUSTOMER_CA

This data model represents the DW_AR_SLA_AGING_CUSTOMER_CA relationships with Dimensions.

DW_AR_SLA_AGING_INVOICE_CA

This data model represents the DW_AR_SLA_AGING_INVOICE_CA relationships with Dimensions.

DW_AR_AGING_RCPT_CUSTOMER_CA

This data model represents the DW_AR_AGING_RCPT_CUSTOMER_CA relationships with Dimensions.

DW_AR_AGING_RECEIPT_CA

This data model represents the DW_AR_AGING_RECEIPT_CA relationships with Dimensions.

DW_AR_SLA_APPLICATIONS_CF

This data model represents the DW_AR_SLA_APPLICATIONS_CF relationships with Dimensions.

DW_AR_SLA_CREDITMEMO_CF

This data model represents the DW_AR_SLA_CREDITMEMO_CF relationships with Dimensions.

DW_AR_SLA_REVENUE_CF

This data model represents the DW_AR_SLA_REVENUE_CF relationships with Dimensions.

DW_AR_SLA_SCHEDULES_CF

This data model represents the DW_AR_SLA_SCHEDULES_CF relationships with Dimensions.

DW_AR_SLA_TRANSACTIONS_CF

This data model represents the DW_AR_SLA_TRANSACTIONS_CF relationships with Dimensions.

Subledger Accounting

DW_GL_SLA_RECON_CF

This data model represents the DW_GL_SLA_RECON_CF relationships with Dimensions.