Tabular Model - General Ledger

Contents

Usage/Purpose

Main analysis scenarios are:

Fact Tables

Model Table DW Source view (SQL Server) BI Access View Referenced Information Source Recommended Access Type
GL ANALYSIS MEASURESFACT_TRANS_BAL_SET_AM_CONF_TMFACT_GL_TRANSACTION_BI, FACT_GL_BALANCE_BI, FACT_GL_PERIOD_BUDGET_BI, FACT_PLAN_TRANS_VALID_BIFACT_GL_TRANSACTION, FACT_GL_BALANCE, FACT_GL_PERIOD_BUDGET, FACT_PLAN_TRANS_VALIDData Mart
BUSINESS PLANNING MEASURESFACT_PLAN_TRANS_VALID_TMFACT_PLAN_TRANS_VALID_BIFACT_PLAN_TRANS_VALIDData Mart

 Corresponding Information Sources are described below. Detailed infomation about Information Sources can be found in About Information Sources

The GL model has two main end user sources that support standard GL analysis as well as detailed analysis of planning and budgeting:

  1. GL ANALYSIS
    Based on the following Information Sources that are used to retrieve transaction data based on GL Balance Set Configuration and GL Balance Set Configuration for Analysis Models.
    1. FACT_GL_TRANSACTION
      Contributes with General Ledger transactions. Supports some transaction level attributes for traceability.
    2. FACT_GL_BALANCE
      Contributes with opening balances from GL Balance in Financials.
    3. FACT_PLAN_TRANS_VALID
      Contributes with valid Business Planning transactions that typically represents budgeting, forecasting and planning.
    4. FACT_GL_PERIOD_BUDGET
      Contributes with GL budget transactions.
  2. BUSINESS PLANNING
    This source is puerly meant to support detail analysis of planning and budgeting and is based on the following Information Sources;
    1. FACT_PLAN_TRANS_VALID
      Valid Business Planning transactions that typically represents budgeting, forecasting and planning.

Dimension Tables

Model Table DW Source view (SQL Server) BI Access View Referenced Information Source Recommended Access Type
ACCOUNTDIM_ACCOUNT_FINANCIALS_TMDIM_ACCOUNT_BIDIM_ACCOUNTOn Line
ACCOUNTING PERIODDIM_ACCOUNTING_PERIOD_BIDIM_ACCOUNTING_PERIOD_BIDIM_ACCOUNTING_PERIODOn Line
CODE BDIM_CODE_B_TMDIM_CODE_B_BIDIM_CODE_BOn Line
CODE CDIM_CODE_C_TMDIM_CODE_C_BIDIM_CODE_COn Line
CODE DDIM_CODE_D_TMDIM_CODE_D_BIDIM_CODE_DOn Line
CODE EDIM_CODE_E_TMDIM_CODE_E_BIDIM_CODE_EOn Line
CODE GDIM_CODE_G_TMDIM_CODE_G_BIDIM_CODE_GOn Line
CODE HDIM_CODE_H_TMDIM_CODE_H_BIDIM_CODE_HOn Line
CODE IDIM_CODE_I_TMDIM_CODE_I_BIDIM_CODE_IOn Line
CODE JDIM_CODE_J_TMDIM_CODE_J_BIDIM_CODE_JOn Line
VOUCHER TYPEDIM_VOUCHER_TYPE_BIDIM_VOUCHER_TYPE_BIDIM_VOUCHER_TYPEOn Line
COMPANYDIM_COMPANY_BIDIM_COMPANY_BIDIM_COMPANYOn Line
CURRENCY CODEDIM_CURRENCY_CODE_TMDIM_CURRENCY_CODE_BIDIM_CURRENCY_CODEOn Line
ACCOUNTING PROJECTDIM_ACCOUNTING_PROJECT_BIDIM_ACCOUNTING_PROJECT_BIDIM_ACCOUNTING_PROJECTOn Line
REPORTING PERIODDIM_REPORTING_PERIOD__TM, alt DIM_BI_TIME_BI combined with DIM_RDP_COMPANY_PERIOD_BI to DIM_BI_TIME_TMDIM_RDP_COMPANY_PERIOD_BIDIM_RDP_COMPANY_PERIODOn Line
CODE FDIM_CODE_F_TMDIM_CODE_F_BIDIM_CODE_FOn Line
REPORTING FROM CURRENCYDIM_CURRENCY_CODE_XRATE_TMDIM_CURRENCY_CODE_BI, LUP_REP_CURR_RATE_TCDIM_CURRENCY_CODE_XRATEOn Line
REPORTING FROM CURRENCY 2DIM_CURRENCY_CODE_XRATE_TMDIM_CURRENCY_CODE_BI, LUP_REP_CURR_RATE_TCDIM_CURRENCY_CODE_XRATEOn Line
CODE B ATTRIBUTE 1DIM_ACC_ATTR_1_CODE_B_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_1_CODE_BOn Line
ACCOUNT ATTRIBUTE 1DIM_ACC_ATTR1_ACCOUNT_TMDIM_ACC_ATTR_BIA, LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_1_ACCOUNTOn Line
CURRENCY CODE X-RATE 1DIM_CURRENCY_CODE_XRATE_TM DIM_CURRENCY_CODE_BI, LUP_REP_CURR_RATE_TCDIM_CURRENCY_CODE_XRATEOn Line
RATE TYPE X-RATE 1DIM_CURRENCY_RATE_TYPE_XRATE_TMDIM_CURRENCY_RATE_TYPE_BI, LUP_REP_CURR_RATE_TYPE_TCDIM_CURRENCY_RATE_TYPE_XRATEOn Line
X-RATES 1FACT_CURRENCY_RATES_PERIODXRATEDIM_BI_TIME_BI, DIM_RPD_COMPANY_PERIOD_BI, LUP_REPORTING_PERIOD_TC, DIM_CURRENCY_CODE_BI, DIM_CURRENCY_RATE_TYPE_BI, LUP_REP_CURR_RATE_TYPE_TCFACT_CURRENCY_RATES_PERIODXRATEData Mart
X-RATES 2FACT_CURRENCY_RATES_PERIODXRATEDIM_BI_TIME_BI, DIM_RPD_COMPANY_PERIOD_BI, LUP_REPORTING_PERIOD_TC, DIM_CURRENCY_CODE_BI, DIM_CURRENCY_RATE_TYPE_BI, LUP_REP_CURR_RATE_TYPE_TCFACT_CURRENCY_RATES_PERIODXRATEData Mart
RATE TYPE X-RATE 2DIM_CURRENCY_RATE_TYPE_XRATE_TMDIM_CURRENCY_RATE_TYPE_BI, LUP_REP_CURR_RATE_TYPE_TCDIM_CURRENCY_RATE_TYPE_XRATEOn Line
CURRENCY CODE X-RATE 2DIM_CURRENCY_CODE_XRATE_TM DIM_CURRENCY_CODE_BI, LUP_REP_CURR_RATE_TCDIM_CURRENCY_CODE_XRATEOn Line
CODE C ATTRIBUTE 1DIM_ACC_ATTR_1_CODE_C_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_1_CODE_COn Line
CODE D ATTRIBUTE 1DIM_ACC_ATTR_1_CODE_D_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_1_CODE_DOn Line
CODE E ATTRIBUTE 1DIM_ACC_ATTR_1_CODE_E_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_1_CODE_EOn Line
CODE F ATTRIBUTE 1DIM_ACC_ATTR_1_CODE_F_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_1_CODE_FOn Line
CODE G ATTRIBUTE 1DIM_ACC_ATTR_1_CODE_G_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_1_CODE_GOn Line
CODE I ATTRIBUTE 1DIM_ACC_ATTR_1_CODE_I_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_1_CODE_IOn Line
CODE H ATTRIBUTE 1DIM_ACC_ATTR_1_CODE_H_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_1_CODE_HOn Line
CODE J ATTRIBUTE 1DIM_ACC_ATTR_1_CODE_J_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_1_CODE_JOn Line
CODE B ATTRIBUTE 2DIM_ACC_ATTR_2_CODE_B_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_2_CODE_BOn Line
CODE C ATTRIBUTE 2DIM_ACC_ATTR_2_CODE_C_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_2_CODE_COn Line
CODE D ATTRIBUTE 2DIM_ACC_ATTR_2_CODE_D_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_2_CODE_DOn Line
CODE E ATTRIBUTE 2DIM_ACC_ATTR_2_CODE_E_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_2_CODE_EOn Line
CODE G ATTRIBUTE 2DIM_ACC_ATTR_2_CODE_G_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_2_CODE_GOn Line
CODE F ATTRIBUTE 2DIM_ACC_ATTR_2_CODE_F_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_2_CODE_FOn Line
CODE H ATTRIBUTE 2DIM_ACC_ATTR_2_CODE_H_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_2_CODE_HOn Line
CODE I ATTRIBUTE 2DIM_ACC_ATTR_2_CODE_I_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_2_CODE_IOn Line
CODE J ATTRIBUTE 2DIM_ACC_ATTR_2_CODE_J_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_2_CODE_JOn Line
CODE B ATTRIBUTE 3DIM_ACC_ATTR_3_CODE_B_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_3_CODE_BOn Line
CODE C ATTRIBUTE 3DIM_ACC_ATTR_3_CODE_C_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_3_CODE_COn Line
CODE D ATTRIBUTE 3DIM_ACC_ATTR_3_CODE_D_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_3_CODE_DOn Line
CODE E ATTRIBUTE 3DIM_ACC_ATTR_3_CODE_E_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_3_CODE_EOn Line
CODE F ATTRIBUTE 3DIM_ACC_ATTR_3_CODE_F_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_3_CODE_FOn Line
CODE H ATTRIBUTE 3DIM_ACC_ATTR_3_CODE_H_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_3_CODE_HOn Line
CODE G ATTRIBUTE 3DIM_ACC_ATTR_3_CODE_G_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_3_CODE_GOn Line
CODE I ATTRIBUTE 3DIM_ACC_ATTR_3_CODE_I_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_3_CODE_IOn Line
CODE J ATTRIBUTE 3DIM_ACC_ATTR_3_CODE_J_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_3_CODE_JOn Line
CODE B ATTRIBUTE 4DIM_ACC_ATTR_4_CODE_B_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_4_CODE_BOn Line
CODE C ATTRIBUTE 4DIM_ACC_ATTR_4_CODE_C_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_4_CODE_COn Line
CODE E ATTRIBUTE 4DIM_ACC_ATTR_4_CODE_E_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_4_CODE_EOn Line
CODE D ATTRIBUTE 4DIM_ACC_ATTR_4_CODE_D_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_4_CODE_DOn Line
CODE F ATTRIBUTE 4DIM_ACC_ATTR_4_CODE_F_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_4_CODE_FOn Line
CODE G ATTRIBUTE 4DIM_ACC_ATTR_4_CODE_G_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_4_CODE_GOn Line
CODE H ATTRIBUTE 4DIM_ACC_ATTR_4_CODE_H_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_4_CODE_HOn Line
CODE J ATTRIBUTE 4DIM_ACC_ATTR_4_CODE_J_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_4_CODE_JOn Line
CODE I ATTRIBUTE 4DIM_ACC_ATTR_4_CODE_I_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_4_CODE_IOn Line
CODE B ATTRIBUTE 5DIM_ACC_ATTR_5_CODE_B_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_5_CODE_BOn Line
CODE C ATTRIBUTE 5DIM_ACC_ATTR_5_CODE_C_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_5_CODE_COn Line
CODE D ATTRIBUTE 5DIM_ACC_ATTR_5_CODE_D_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_5_CODE_DOn Line
CODE E ATTRIBUTE 5DIM_ACC_ATTR_5_CODE_E_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_5_CODE_EOn Line
CODE F ATTRIBUTE 5DIM_ACC_ATTR_5_CODE_F_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_5_CODE_FOn Line
CODE G ATTRIBUTE 5DIM_ACC_ATTR_5_CODE_G_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_5_CODE_GOn Line
CODE H ATTRIBUTE 5DIM_ACC_ATTR_5_CODE_H_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_5_CODE_HOn Line
CODE I ATTRIBUTE 5DIM_ACC_ATTR_5_CODE_I_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_5_CODE_IOn Line
CODE J ATTRIBUTE 5DIM_ACC_ATTR_5_CODE_J_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_5_CODE_JOn Line
ACCOUNT ATTRIBUTE 2DIM_ACC_ATTR2_ACCOUNT_TMDIM_ACC_ATTR_BIA, LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_2_ACCOUNTOn Line
ACCOUNT ATTRIBUTE 3DIM_ACC_ATTR3_ACCOUNT_TMDIM_ACC_ATTR_BIA, LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_3_ACCOUNTOn Line
ACCOUNT ATTRIBUTE 4DIM_ACC_ATTR4_ACCOUNT_TMDIM_ACC_ATTR_BIA, LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_4_ACCOUNTOn Line
ACCOUNT ATTRIBUTE 5DIM_ACC_ATTR5_ACCOUNT_TMDIM_ACC_ATTR_BIA, LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_5_ACCOUNTOn Line
CODE MDIM_CODE_M_TMDIM_CODE_M_BIDIM_CODE_MOn Line
CODE NDIM_CODE_N_TMDIM_CODE_N_BIDIM_CODE_NOn Line
CODE ODIM_CODE_O_TMDIM_CODE_O_BIDIM_CODE_OOn Line
CODE PDIM_CODE_P_TMDIM_CODE_P_BIDIM_CODE_POn Line
CODE QDIM_CODE_Q_TMDIM_CODE_Q_BIDIM_CODE_QOn Line
CODE RDIM_CODE_R_TMDIM_CODE_R_BIDIM_CODE_ROn Line
CODE SDIM_CODE_S_TMDIM_CODE_S_BIDIM_CODE_SOn Line
CODE TDIM_CODE_T_TMDIM_CODE_T_BIDIM_CODE_TOn Line
COUNTER PART ONEDIM_COUNTER_PART_ONE_TMDIM_COUNTER_PART_ONE_BIDIM_COUNTER_PART_ONEOn Line
COUNTER PART TWODIM_COUNTER_PART_TWO_TMDIM_COUNTER_PART_TWO_BIDIM_COUNTER_PART_TWOOn Line
PLANNING UNITDIM_PLANNING_UNIT_TMDIM_PLANNING_UNIT_BIDIM_PLANNING_UNITOn Line
BUSINESS PLANNINGFACT_PLAN_TRANS_VALID_TMFACT_PLAN_TRANS_VALID_BIFACT_PLAN_TRANS_VALIDData Mart
BUSINESS PLANDIM_BUSINESS_PLAN_TMDIM_BUSINESS_PLAN_BIDIM_BUSINESS_PLANOn Line
BUSINESS PLAN RLS
GL COMPANY RLS
PLANNING UNIT RLS

Configurations

Refer to Technical Documentation for more information.

Limitations

Refer to Technical Documentation for more information.

Relationships

The following table lists the relationships between tables and columns in the model.

Relationship: Table (column) - Table (column)
GL ANALYSIS (dim_reporting_date_id) - REPORTING PERIOD (ID)
GL ANALYSIS (dim_accounting_period_id) - ACCOUNTING PERIOD (ID)
GL ANALYSIS (dim_company_id) - COMPANY (ID)
GL ANALYSIS (dim_currency_code_id) - CURRENCY CODE (ID)
GL ANALYSIS (dim_accounting_project_id) - ACCOUNTING PROJECT (ID)
GL ANALYSIS (dim_account_id) - ACCOUNT (ID)
GL ANALYSIS (dim_code_b_id) - CODE B (ID)
X-RATES 1 (CURRENCY_RATE_DATE_ID) - REPORTING PERIOD (ID)
X-RATES 1 (TOCURRENCY) - CURRENCY CODE X-RATE 1 (Currency Code X-Rate 1)
X-RATES 1 (CURRENCY_RATE_TYPE_KEY) - RATE TYPE X-RATE 1 (Rate Type Code X-Rate 1)
X-RATES 1 (FROMCURRENCY) - REPORTING FROM CURRENCY (Currency Code)
GL ANALYSIS (Company Base Currency) - REPORTING FROM CURRENCY (Currency Code)
X-RATES 2 (CURRENCY_RATE_DATE_ID) - REPORTING PERIOD (ID)
X-RATES 2 (CURRENCY_RATE_TYPE_KEY) - RATE TYPE X-RATE 2 (Rate Type Code X-Rate 2)
X-RATES 2 (FROMCURRENCY) - REPORTING FROM CURRENCY 2 (Currency Code)
X-RATES 2 (TOCURRENCY) - CURRENCY CODE X-RATE 2 (Currency Code X-Rate 2)
GL ANALYSIS (Company Base Currency) - REPORTING FROM CURRENCY 2 (Currency Code)
GL ANALYSIS (dim_code_c_id) - CODE C (ID)
GL ANALYSIS (dim_code_d_id) - CODE D (ID)
GL ANALYSIS (dim_code_e_id) - CODE E (ID)
GL ANALYSIS (dim_code_f_id) - CODE F (ID)
GL ANALYSIS (dim_code_g_id) - CODE G (ID)
GL ANALYSIS (dim_code_h_id) - CODE H (ID)
GL ANALYSIS (dim_code_j_id) - CODE I (ID)
GL ANALYSIS (dim_code_j_id) - CODE J (ID)
GL ANALYSIS (dim_voucher_type_id) - VOUCHER TYPE (ID)
GL ANALYSIS (dim_code_b_id) - CODE B ATTRIBUTE 1 (ID)
GL ANALYSIS (dim_account_id) - ACCOUNT ATTRIBUTE 1 (ID)
GL ANALYSIS (dim_code_b_id) - CODE B ATTRIBUTE 2 (ID)
GL ANALYSIS (dim_code_b_id) - CODE B ATTRIBUTE 3 (ID)
GL ANALYSIS (dim_code_b_id) - CODE B ATTRIBUTE 4 (ID)
GL ANALYSIS (dim_code_b_id) - CODE B ATTRIBUTE 5 (ID)
GL ANALYSIS (dim_account_id) - ACCOUNT ATTRIBUTE 2 (ID)
GL ANALYSIS (dim_account_id) - ACCOUNT ATTRIBUTE 3 (ID)
GL ANALYSIS (dim_account_id) - ACCOUNT ATTRIBUTE 4 (ID)
GL ANALYSIS (dim_account_id) - ACCOUNT ATTRIBUTE 5 (ID)
GL ANALYSIS (dim_code_c_id) - CODE C ATTRIBUTE 1 (ID)
GL ANALYSIS (dim_code_c_id) - CODE C ATTRIBUTE 2 (ID)
GL ANALYSIS (dim_code_c_id) - CODE C ATTRIBUTE 3 (ID)
GL ANALYSIS (dim_code_c_id) - CODE C ATTRIBUTE 4 (ID)
GL ANALYSIS (dim_code_c_id) - CODE C ATTRIBUTE 5 (ID)
GL ANALYSIS (dim_code_d_id) - CODE D ATTRIBUTE 1 (ID)
GL ANALYSIS (dim_code_d_id) - CODE D ATTRIBUTE 2 (ID)
GL ANALYSIS (dim_code_d_id) - CODE D ATTRIBUTE 3 (ID)
GL ANALYSIS (dim_code_d_id) - CODE D ATTRIBUTE 4 (ID)
GL ANALYSIS (dim_code_d_id) - CODE D ATTRIBUTE 5 (ID)
GL ANALYSIS (dim_code_e_id) - CODE E ATTRIBUTE 1 (ID)
GL ANALYSIS (dim_code_e_id) - CODE E ATTRIBUTE 2 (ID)
GL ANALYSIS (dim_code_e_id) - CODE E ATTRIBUTE 3 (ID)
GL ANALYSIS (dim_code_e_id) - CODE E ATTRIBUTE 4 (ID)
GL ANALYSIS (dim_code_e_id) - CODE E ATTRIBUTE 5 (ID)
GL ANALYSIS (dim_code_f_id) - CODE F ATTRIBUTE 1 (ID)
GL ANALYSIS (dim_code_f_id) - CODE F ATTRIBUTE 2 (ID)
GL ANALYSIS (dim_code_f_id) - CODE F ATTRIBUTE 3 (ID)
GL ANALYSIS (dim_code_f_id) - CODE F ATTRIBUTE 4 (ID)
GL ANALYSIS (dim_code_f_id) - CODE F ATTRIBUTE 5 (ID)
GL ANALYSIS (dim_code_g_id) - CODE G ATTRIBUTE 1 (ID)
GL ANALYSIS (dim_code_g_id) - CODE G ATTRIBUTE 2 (ID)
GL ANALYSIS (dim_code_g_id) - CODE G ATTRIBUTE 3 (ID)
GL ANALYSIS (dim_code_g_id) - CODE G ATTRIBUTE 4 (ID)
GL ANALYSIS (dim_code_g_id) - CODE G ATTRIBUTE 5 (ID)
GL ANALYSIS (dim_code_h_id) - CODE H ATTRIBUTE 1 (ID)
GL ANALYSIS (dim_code_h_id) - CODE H ATTRIBUTE 2 (ID)
GL ANALYSIS (dim_code_h_id) - CODE H ATTRIBUTE 3 (ID)
GL ANALYSIS (dim_code_h_id) - CODE H ATTRIBUTE 4 (ID)
GL ANALYSIS (dim_code_h_id) - CODE H ATTRIBUTE 5 (ID)
GL ANALYSIS (dim_code_i_id) - CODE I ATTRIBUTE 1 (ID)
GL ANALYSIS (dim_code_i_id) - CODE I ATTRIBUTE 2 (ID)
GL ANALYSIS (dim_code_i_id) - CODE I ATTRIBUTE 3 (ID)
GL ANALYSIS (dim_code_i_id) - CODE I ATTRIBUTE 4 (ID)
GL ANALYSIS (dim_code_i_id) - CODE I ATTRIBUTE 5 (ID)
GL ANALYSIS (dim_code_j_id) - CODE J ATTRIBUTE 1 (ID)
GL ANALYSIS (dim_code_j_id) - CODE J ATTRIBUTE 2 (ID)
GL ANALYSIS (dim_code_j_id) - CODE J ATTRIBUTE 3 (ID)
GL ANALYSIS (dim_code_j_id) - CODE J ATTRIBUTE 4 (ID)
GL ANALYSIS (dim_code_j_id) - CODE J ATTRIBUTE 5 (ID)
BUSINESS PLANNING (dim_account_id) - ACCOUNT (ID)
BUSINESS PLANNING (dim_code_b_id) - CODE B (ID)
BUSINESS PLANNING (dim_code_c_id) - CODE C (ID)
BUSINESS PLANNING (dim_code_d_id) - CODE D (ID)
BUSINESS PLANNING (dim_code_e_id) - CODE E (ID)
BUSINESS PLANNING (dim_code_f_id) - CODE F (ID)
BUSINESS PLANNING (dim_code_g_id) - CODE G (ID)
BUSINESS PLANNING (dim_code_h_id) - CODE H (ID)
BUSINESS PLANNING (dim_code_i_id) - CODE I (ID)
BUSINESS PLANNING (dim_code_j_id) - CODE J (ID)
BUSINESS PLANNING (dim_code_m_id) - CODE M (ID)
BUSINESS PLANNING (dim_code_n_id) - CODE N (ID)
BUSINESS PLANNING (dim_code_p_id) - CODE P (ID)
BUSINESS PLANNING (dim_code_q_id) - CODE Q (ID)
BUSINESS PLANNING (dim_code_r_id) - CODE R (ID)
BUSINESS PLANNING (dim_code_s_id) - CODE S (ID)
BUSINESS PLANNING (dim_code_t_id) - CODE T (ID)
BUSINESS PLANNING (dim_counter_part_one_id) - COUNTER PART ONE (ID)
BUSINESS PLANNING (dim_counter_part_two_id) - COUNTER PART TWO (ID)
BUSINESS PLANNING (dim_planning_unit_id) - PLANNING UNIT (ID)
BUSINESS PLANNING (dim_business_plan_id) - BUSINESS PLAN (ID)
BUSINESS PLANNING (dim_company_id) - COMPANY (ID)
BUSINESS PLANNING (dim_currency_code_id) - CURRENCY CODE (ID)
BUSINESS PLANNING (dim_reporting_date_id) - REPORTING PERIOD (ID)
GL COMPANY RLS (COMPANY) - COMPANY (ID)
PLANNING UNIT RLS (DIM_PLANNING_UNIT_ID) - PLANNING UNIT (ID)
BUSINESS PLAN RLS (DIM_BUSINESS_PLAN_ID) - BUSINESS PLAN (ID)
BUSINESS PLANNING (dim_planning_unit_id) - PLANNING STRUCTURE (ID)