10.2.1 Case 1

When the Product Dimension needs to be changed from DIM_PRODUCT to DIM_COMMON_COA, the following changes are required in the OBIEE Repository:

1. Repository physical layer will have DIM_PRODUCT.
2. Rename the table name from DIM_PRODUCT to DIM_COMMON_COA.
3. Rename every column name of the DIM_PRODUCT with PRODUCT to COMMON_COA.
4. Rename every column name of the DIM_PRODUCT with PRODUCT to COMMON_COA.
5. Double click Dim Product - Assumptions (View).
6. 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.product_name,a.hierarchy_id,a.display_order_num,c.language from dim_products_hier a
   left outer join dim_products_b b on
   a.child_id=b.product_id left outer join
   dim_products_tl c
   on b.product_id=c.product_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.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'
7. Click OK.
8. Save the Repository file.
9. Start the BI Server.