Fact and Dimension Group Usage by Target Table
A fact or dimension group is a business grouping used to organize related tables.
-
A fact group usually represents measurable business activity, such as invoices, payments, balances, purchases, expenses, or project costs.
-
A dimension group usually represents descriptive business information, such as customers, suppliers, products, employees, ledgers, locations, accounts, or projects.
This matrix shows where each fact/dimension group filter is used in relation to the inline dataset configuration. It helps users understand which target tables are associated with each group and which tables may be impacted based on the parameter value provided for that group. This is useful for reviewing load configuration, validating table coverage, analyzing dependencies, and understanding how data is organized across analytical target tables.
You can refer this and make the configuration changes for the fact or dimension group level assignments for the parameters.
Fact or Dimension Group to Target Table Association Matrix
| SL NO | MODULE NAME | GROUP CODE | DIMENSION/FACT NAME |
|---|---|---|---|
|
1 |
EBS_COMMON |
APTERM_DIM |
W_AP_TERMS_DS |
|
2 |
EBS_COMMON |
BALSEG_DIM |
W_BAL_SEGMENT_HIER_PS |
|
3 |
EBS_COMMON |
BALSEG_DIM |
W_BAL_SEGMENT_HIER_PS_PE |
|
4 |
EBS_COMMON |
BALSEG_DIM |
W_BALANCING_SEGMENT_D |
|
5 |
EBS_COMMON |
BALSEG_DIM |
W_BALANCING_SEGMENT_D_PE |
|
6 |
EBS_COMMON |
BUSNLOC_DIM |
W_BUSN_LOCATION_D |
|
7 |
EBS_COMMON |
BUSNLOC_DIM |
W_BUSN_LOCATION_D_PE |
|
8 |
EBS_COMMON |
BUSNLOC_DIM |
W_BUSN_LOCATION_DS_TL |
|
9 |
EBS_COMMON |
CHLTYPE_DIM |
W_CHNL_TYPE_D |
|
10 |
EBS_COMMON |
CHLTYPE_DIM |
W_CHNL_TYPE_D_PE |
|
11 |
EBS_COMMON |
CHLTYPE_DIM |
W_CHNL_TYPE_DS |
|
12 |
EBS_COMMON |
COSTCTR_DIM |
W_COST_CENTER_D_PE |
|
13 |
EBS_COMMON |
COSTCTR_DIM |
W_COST_CENTER_HIER_PS |
|
14 |
EBS_COMMON |
COSTCTR_DIM |
W_COST_CENTER_HIER_PS_PE |
|
15 |
EBS_COMMON |
CUSTACCT_DIM |
W_CUSTOMER_ACCOUNT_D |
|
16 |
EBS_COMMON |
CUSTACCT_DIM |
W_CUSTOMER_ACCOUNT_D_PE |
|
17 |
EBS_COMMON |
CUSTLOC_DIM |
W_CUSTOMER_LOC_D |
|
18 |
EBS_COMMON |
CUSTLOC_DIM |
W_CUSTOMER_LOC_D_PE |
|
19 |
EBS_COMMON |
EMPLOYEE_DIM |
W_EMPLOYEE_D |
|
20 |
EBS_COMMON |
EMPLOYEE_DIM |
W_EMPLOYEE_D_PE |
|
21 |
EBS_COMMON |
EMPLOYEE_DIM |
W_EMPLOYEE_DS |
|
22 |
EBS_COMMON |
GLSEG_DIM |
W_GL_SEGMENT_D |
|
23 |
EBS_COMMON |
GLSEG_DIM |
W_GL_SEGMENT_D_PE |
|
24 |
EBS_COMMON |
GLSEG_DIM |
W_GL_SEGMENT_HIER_PS |
|
25 |
EBS_COMMON |
GLSEG_DIM |
W_GL_SEGMENT_HIER_PS_PE |
|
26 |
EBS_COMMON |
INDUSTRY_DIM |
W_INDUSTRY_DH |
|
27 |
EBS_COMMON |
INDUSTRY_DIM |
W_INDUSTRY_DH_PE |
|
28 |
EBS_COMMON |
INDUSTRY_DIM |
W_INDUSTRY_DHS |
|
29 |
EBS_COMMON |
INTORG_DIM |
W_INT_ORG_DS_TL |
|
30 |
EBS_COMMON |
INTORG_DIM |
W_ORA_INT_ORG_DH_PS |
|
31 |
EBS_COMMON |
INTORG_DIM |
W_ORA_INT_ORG_DH_PS_PE |
|
32 |
EBS_COMMON |
INVPROD_DIM |
W_INVENTORY_PRODUCT_D |
|
33 |
EBS_COMMON |
INVPROD_DIM |
W_INVENTORY_PRODUCT_D_PE |
|
34 |
EBS_COMMON |
INVPROD_DIM |
W_ORA_INVITEM_CATEGORY_TMP |
|
35 |
EBS_COMMON |
LEDGER_DIM |
W_LEDGER_DS |
|
36 |
EBS_COMMON |
NAT_ACCT_DIM |
W_NATURAL_ACCOUNT_D |
|
37 |
EBS_COMMON |
NAT_ACCT_DIM |
W_NATURAL_ACCOUNT_D_PE |
|
38 |
EBS_COMMON |
NAT_ACCT_DIM |
W_NATURAL_ACCOUNT_HIER_PS |
|
39 |
EBS_COMMON |
NAT_ACCT_DIM |
W_NATURAL_ACCOUNT_HIER_PS_PE |
|
40 |
EBS_COMMON |
PARTY_DIM |
W_ORA_PARTY_ORGDH_PS |
|
41 |
EBS_COMMON |
PARTY_DIM |
W_PARTY_ORG_D |
|
42 |
EBS_COMMON |
PARTY_DIM |
W_PARTY_ORG_D_PE |
|
43 |
EBS_COMMON |
PARTY_DIM |
W_PARTY_ORG_DH |
|
44 |
EBS_COMMON |
PARTY_DIM |
W_PARTY_ORG_DH_PE |
|
45 |
EBS_COMMON |
PARTYPER_DIM |
W_PARTY_PER_D |
|
46 |
EBS_COMMON |
PARTYPER_DIM |
W_PARTY_PER_D_PE |
|
47 |
EBS_COMMON |
PAYMETHOD_DIM |
W_PAYMENT_METHOD_DS |
|
48 |
EBS_COMMON |
POSHIER_DIM |
W_POSITION_D_PE |
|
49 |
EBS_COMMON |
POSHIER_DIM |
W_POSITION_DH |
|
50 |
EBS_COMMON |
PRODCAT_DIM |
W_PROD_CAT_DH_DEL |
|
51 |
EBS_COMMON |
PRODCAT_DIM |
W_PROD_CAT_DH_PE |
|
52 |
EBS_COMMON |
PRODCAT_DIM |
W_PROD_CAT_DHS |
|
53 |
EBS_COMMON |
PRODUCT_DIM |
W_ORA_ITEM_CATEGORY_TMP |
|
54 |
EBS_COMMON |
PRODUCT_DIM |
W_PRODUCT_CATALOG_D |
|
55 |
EBS_COMMON |
PRODUCT_DIM |
W_PRODUCT_CATALOG_D_PE |
|
56 |
EBS_COMMON |
PRODUCT_DIM |
W_PRODUCT_D |
|
57 |
EBS_COMMON |
PRODUCT_DIM |
W_PRODUCT_D_PE |
|
58 |
EBS_COMMON |
PROJECT_DIM |
W_PROJECT_DS_TL |
|
59 |
EBS_COMMON |
PROJECT_DIM |
W_PROJECT_ROLE_DS |
|
60 |
EBS_COMMON |
REASON_DIM |
W_REASON_DS |
|
61 |
EBS_COMMON |
STATUS_DIM |
W_STATUS_DS |
|
62 |
EBS_COMMON |
SUPACCT_DIM |
W_SUPPLIER_ACCOUNT_D |
|
63 |
EBS_COMMON |
SUPACCT_DIM |
W_SUPPLIER_ACCOUNT_D_PE |
|
64 |
EBS_COMMON |
TASK_DIM |
W_TASK_DS_TL |
|
65 |
EBS_COMMON |
TIME_DIM |
W_ENT_PERIOD_D |
|
66 |
EBS_COMMON |
TIME_DIM |
W_ENT_QTR_D |
|
67 |
EBS_COMMON |
TIME_DIM |
W_ENT_WEEK_D |
|
68 |
EBS_COMMON |
TIME_DIM |
W_ENT_YEAR_D |
|
69 |
EBS_COMMON |
TRXSRC_DIM |
W_XACT_SOURCE_DS |
|
70 |
EBS_COMMON |
TRXTYPE_DIM |
W_XACT_TYPE_DS |
|
71 |
EBS_COMMON |
USER_DIM |
W_USER_D |
|
72 |
EBS_COMMON |
USER_DIM |
W_USER_D_PE |
|
73 |
EBS_AP |
APHOLDS_FG |
W_AP_HOLDS_F |
|
74 |
EBS_AP |
APHOLDS_FG |
W_AP_HOLDS_F_PE |
|
75 |
EBS_AP |
APTRANS_FG |
W_AP_XACT_F |
|
76 |
EBS_AP |
APTRANS_FG |
W_AP_XACT_F_PE |
|
77 |
EBS_AP |
APTRANS_FG |
W_AP_XACT_FS |
|
78 |
EBS_AR |
ARTRANS_FG |
W_AR_XACT_F |
|
79 |
EBS_AR |
ARTRANS_FG |
W_AR_XACT_F_PE |
|
80 |
EBS_AR |
ARTRANS_FG |
W_AR_XACT_FS |
|
81 |
EBS_AR |
ARTRANS_FG |
W_ORA_AR_XACTS_F_TMP |
|
82 |
EBS_AR |
FINPROFL_FG |
W_CUSTOMER_FIN_PROFL_F |
|
83 |
EBS_AR |
FINPROFL_FG |
W_CUSTOMER_FIN_PROFL_F_PE |
|
84 |
EBS_AR |
PRJCNTRCT_DIM |
W_CONTRACT_HDR_DS_TL |
|
85 |
EBS_EE |
EXPCRDTCRD_FG |
W_EXPENSE_CC_F |
|
86 |
EBS_EE |
EXPCRDTCRD_FG |
W_EXPENSE_CC_F_PE |
|
87 |
EBS_EE |
EXPOVERVIEW_FG |
W_EXPENSE_F |
|
88 |
EBS_EE |
EXPOVERVIEW_FG |
W_EXPENSE_F_PE |
|
89 |
EBS_EE |
EXPVIOLATION_FG |
W_EXPENSE_VIOLATION_F |
|
90 |
EBS_EE |
EXPVIOLATION_FG |
W_EXPENSE_VIOLATION_F_PE |
|
91 |
EBS_FA |
ASTBAL_FG |
W_FA_BALANCE_F_PE |
|
92 |
EBS_FA |
ASTXACT_FG |
W_FA_XACT_F |
|
93 |
EBS_FA |
ASTXACT_FG |
W_FA_XACT_F_PE |
|
94 |
EBS_PR |
TERR_DIM |
W_TERR_D |
|
95 |
EBS_PR |
TERR_DIM |
W_TERR_D_PE |
|
96 |
EBS_PROC |
PONNEG_FG |
W_NEG_INVITATIONS_F |
|
97 |
EBS_PROC |
PONNEG_FG |
W_NEG_INVITATIONS_F_PE |
|
98 |
EBS_PROC |
PONNEG_FG |
W_NEG_LINES_F |
|
99 |
EBS_PROC |
PONNEG_FG |
W_NEG_LINES_F_PE |
|
100 |
EBS_PROC |
PONRESP_FG |
W_NEG_AWARDS_F |
|
101 |
EBS_PROC |
PONRESP_FG |
W_NEG_AWARDS_F_PE |
|
102 |
EBS_PROC |
PONRESP_FG |
W_NEG_RESPONSES_F |
|
103 |
EBS_PROC |
PONRESP_FG |
W_NEG_RESPONSES_F_PE |
|
104 |
EBS_PROC |
PROCPO_FG |
W_ORA_PURCH_AGREEMENT_PS |
|
105 |
EBS_PROC |
PROCPO_FG |
W_PURCH_COST_F_PE |
|
106 |
EBS_PROC |
PROCPO_FG |
W_PURCH_SCHEDULE_LINE_F |
|
107 |
EBS_PROC |
PROCPO_FG |
W_PURCH_SCHEDULE_LINE_F_PE |
|
108 |
EBS_PROC |
PROCPO_FG |
W_PURCH_SCHEDULE_LINE_FS |
|
109 |
EBS_PROC |
PROCPO_FG |
W_PURCH_VARIANCE_XACT_F |
|
110 |
EBS_PROC |
PROCPO_FG |
W_PURCH_VARIANCE_XACT_F_PE |
|
111 |
EBS_PROC |
PROCPURCY_FG |
W_PURCH_CYCLE_LINE_TMP |
|
112 |
EBS_PROC |
PROCPURRCPT_FG |
W_PURCH_RCPT_F |
|
113 |
EBS_PROC |
PROCPURRCPT_FG |
W_PURCH_RCPT_F_PE |
|
114 |
EBS_PROC |
PROCPURRCPT_FG |
W_PURCH_RCPT_FS |
|
115 |
EBS_PROC |
PROCPURRCPT_FG |
W_PURCH_RCPT_TMP |
|
116 |
EBS_PROC |
PROCPURREQ_FG |
W_PURCH_RQSTN_LINE_F |
|
117 |
EBS_PROC |
PROCPURREQ_FG |
W_PURCH_RQSTN_LINE_F_PE |
|
118 |
EBS_PROC |
PROCPURREQ_FG |
W_PURCH_RQSTN_LINE_FS |
|
119 |
EBS_PROC |
PROCPURREQ_FG |
W_RQSTN_LINE_COST_F |
|
120 |
EBS_PROC |
PROCPURREQ_FG |
W_RQSTN_LINE_COST_F_PE |
|
121 |
EBS_PROC |
PROCPURREQ_FG |
W_RQSTN_LINE_COST_FS |
|
122 |
EBS_PROC |
PURAGG_FG |
W_PURCH_AGREEMENT_HEADER_F |
|
123 |
EBS_PROC |
PURAGG_FG |
W_PURCH_AGREEMENT_HEADER_F_PE |
|
124 |
EBS_PROC |
PURAGG_FG |
W_PURCH_AGREEMENT_LINE_F |
|
125 |
EBS_PROC |
PURAGG_FG |
W_PURCH_COST_F |
|
126 |
EBS_PROC |
SPEND_FG |
W_AP_INV_DIST_F |
|
127 |
EBS_PROC |
SPEND_FG |
W_AP_INV_DIST_F_PE |
|
128 |
EBS_PROC |
SPEND_FG |
W_PURCH_AGREEMENT_LINE_F_PE |
|
129 |
EBS_PROJECTS |
PRJBILLING_FG |
W_PROJ_INVOICE_LINE_F |
|
130 |
EBS_PROJECTS |
PRJBILLING_FG |
W_PROJ_INVOICE_LINE_F_PE |
|
131 |
EBS_PROJECTS |
PRJBILLING_FG |
W_PROJ_INVOICE_LINE_FS |
|
132 |
EBS_PROJECTS |
PRJBILLING_FG |
W_PROJ_INVOICE_LINE_FS_1 |
|
133 |
EBS_PROJECTS |
PRJBUDGET_FG |
W_PROJ_BUDGET_F |
|
134 |
EBS_PROJECTS |
PRJBUDGET_FG |
W_PROJ_BUDGET_F_PE |
|
135 |
EBS_PROJECTS |
PRJCIP_FG |
W_PROJ_CIP_DTL_F |
|
136 |
EBS_PROJECTS |
PRJCIP_FG |
W_PROJ_CIP_DTL_F_PE |
|
137 |
EBS_PROJECTS |
PRJCIP_FG |
W_PROJ_CIP_HDR_F |
|
138 |
EBS_PROJECTS |
PRJCIP_FG |
W_PROJ_CIP_HDR_F_PE |
|
139 |
EBS_PROJECTS |
PRJCOST_FG |
W_PROJ_COST_A |
|
140 |
EBS_PROJECTS |
PRJCOST_FG |
W_PROJ_COST_LINE_F |
|
141 |
EBS_PROJECTS |
PRJCOST_FG |
W_PROJ_COST_LINE_FS |
|
142 |
EBS_PROJECTS |
PRJCOST_FG |
W_PROJ_COST_LINE_TMP |
|
143 |
EBS_PROJECTS |
PRJCRSCHRG_FG |
W_PROJ_COST_LINE_F_PE |
|
144 |
EBS_PROJECTS |
PRJCRSCHRG_FG |
W_PROJ_CROSS_CHARGE_DIST_F |
|
145 |
EBS_PROJECTS |
PRJFRCST_FG |
W_PROJ_FORECAST_F |
|
146 |
EBS_PROJECTS |
PRJFRCST_FG |
W_PROJ_FORECAST_F_PE |
|
147 |
EBS_PROJECTS |
PRJFUNDING_FG |
W_PROJ_FUNDING_HDR_F |
|
148 |
EBS_PROJECTS |
PRJFUNDING_FG |
W_PROJ_FUNDING_HDR_F_PE |
|
149 |
EBS_PROJECTS |
PRJFUNDING_FG |
W_PROJ_FUNDING_LINE_F |
|
150 |
EBS_PROJECTS |
PRJFUNDING_FG |
W_PROJ_FUNDING_LINE_F_PE |
|
151 |
EBS_PROJECTS |
PRJFUNDING_FG |
W_PROJ_RETENTION_F |
|
152 |
EBS_PROJECTS |
PRJFUNDING_FG |
W_PROJ_RETENTION_F_PE |
|
153 |
EBS_PROJECTS |
PRJGLRECNCL_FG |
W_PA_LINKAGE_INFORMATION_TMP |
|
154 |
EBS_PROJECTS |
PRJREVN_FG |
W_PROJ_REVENUE_A |
|
155 |
EBS_PROJECTS |
PRJREVN_FG |
W_PROJ_REVENUE_HDR_F |
|
156 |
EBS_PROJECTS |
PRJREVN_FG |
W_PROJ_REVENUE_HDR_F_PE |
|
157 |
EBS_PROJECTS |
PRJREVN_FG |
W_PROJ_REVENUE_LINE_F |
|
158 |
EBS_PROJECTS |
PRJREVN_FG |
W_PROJ_REVENUE_LINE_F_PE |
|
159 |
EBS_PROJECTS |
PRJRSRCMGMT_FG |
W_ORA_PROJ_RSRC_TMP |
|
160 |
EBS_PROJECTS |
PRJRSRCMGMT_FG |
W_PROJ_RSRC_RQRMNT_F_PE |
|
161 |
EBS_PROJECTS |
PRJRSRCMGMT_FG |
W_PROJ_RSRC_UTILIZATION_F |
|
162 |
EBS_PROJECTS |
PRJRSRCMGMT_FG |
W_PROJ_RSRC_UTILIZATION_F_PE |
|
163 |
EBS_SLA |
SLAJRNLS_FG |
W_SLA_XACT_FS |