4.3.7 List of Dimension Tables

List of ALMBI dimensions impacted by the SCD Procedure are:

• DIM_FCST_RATES_SCENARIO: This table stores all Deterministic Processes with relevant details.

  Figure 4-3 Deterministic Processes

  
  

  

  
  
• DIM_RESULT_BUCKET: This table stores Income Simulation, Liquidity Risk Gap, and Interest Rate Gap Bucket information for each process.

  Figure 4-4 Income Simulation, Liquidity Risk Gap, and Interest Rate Gap Bucket information

  
  

  

  
  
• DIM_ORG_UNIT: This table stores Organization Unit Dimension information.

  Figure 4-5 Organization Unit Dimension information

  
  

  

  
  
• DIM_GL_ACCOUNT: This table stores General Ledger Account information.

  Figure 4-6 General Ledger Account information

  
  

  

  
  
• DIM_COMMON_COA: This table stores Dimensional Attributes of the COMMON_COA dimension.

  Figure 4-7 Dimensional Attributes of the COMMON_COA dimension

  
  

  

  
  
• DIM_PRODUCT: This table stores Dimensional Attributes of the PRODUCT dimension.

  Figure 4-8 Dimensional Attributes of the PRODUCT dimension

  
  

  

  
  
• DIM_PRODUCT_TYPE: This table stores Dimensional Attributes of the PRODUCT_TYPE dimension.

  Figure 4-9 Dimensional Attributes of the PRODUCT_TYPE dimension.

  
  

  

  
  
• DIM_CUSTOMER: This table stores Dimensional Attributes of the CUSTOMER dimension.

  Figure 4-10 Dimensional Attributes of the CUSTOMER dimension

  
  

  

  
  
• DIM_ORG_STRUCTURE: This table stores Dimensional Attributes of the Legal Entity Dimension.

  Figure 4-11 Dimensional Attributes of the Legal Entity Dimension