10.2.3 Case 2

When the new product dimension is DIM_GL_ACCOUNT, the following changes are required in the OBIEE Repository:

1. Rename the existing DIM_GL_ACCOUNT table name to DIM_GL_ACCOUNT_OLD.
2. Rename the DIM_COMMON_COA to DIM_GL_ACCOUNT in the same way it has been stated above for DIM_PRODUCT.
3. Rename every column of DIM_COMMON_COA.
4. Double click on the alias table Dim General Ledger in the physical layer.
5. Source table is displayed as DIM_GL_ACCOUNT_OLD.
6. Click Select next to the Source table name.
7. Select the physical table DIM_GL_ACCOUNT and click OK, and then click OK again.
8. Select Dim Product - Assumptions (View) and double click.
9. Go to General tab. Replace below query:
   select
   a.parent_id,a.child_id,a.child_depth_num,a.parent_depth_num,b.leaf_only_
   flag,c.common_coa_name,a.hierarchy_id,a.display_order_num,c.language
   from dim_common_coa_hier a
   left outer join dim_common_coa_b b on
   a.child_id=b.common_coa_id left outer join
   dim_common_coa_tl c
   on b.common_coa_id=c.common_coa_id
   and c.language='US'
   with
   select
   a.parent_id,a.child_id,a.child_depth_num,a.parent_depth_num,b.leaf_only_flag,c.gl_account_name,a.hierarchy_id,a.display_order_num,c.language from dim_general_ledger_hier a
   left outer join dim_general_ledger_b b on
   a.child_id=b.gl_account_id left outer join
   dim_general_ledger_tl c
   on b.gl_account_id=c.gl_account_id
   and c.language='US'
10. Click OK.
11. Save the Repository file.
12. Start the BI Server.