Friday, April 24, 2015

OBIEE 11g Patch Repository Merge

Example 1: Modifying The objects in copy of existing production rpd(Development rpd) and applying those changes to production level rpd.

 Let us take 3 rpds

1.Original_rpd.rpd(Copy of Production rpd)
2.Original_reference_rpd.rpd(Copy of Production rpd)
3.Development_rpd.rpd(changes made to Production rpd)

 Step1:
Open Original_rpd.rpd and as show below it has 2 subject areas and corresponding business models.
Step2:
Now I have taken another copy of production as Development_rpd.rpd to make my changes. I have made following changes to this rpd.

1.I have changed the permission level's of Presentation table SALES as shown below.



2. I have renamed Presentation table TIMES to TIMES_kartheek and renamed BMM model name SH to SH_kartheek as shown below.


Step3:
In Development_rpd.rpd ,
Go to FILE>COMPARE 
Select the original rpd as Original_rpd.rpd and check the changes displayed and click on create patch with a name 'patch_to_merge.xml'.It is better to equalize before creating patch to avoid ID issues.

Step4:
Open the Original_reference_rpd.rpd it is also copy of Original rpd on which we have to apply changes.
FILE>MERGE
click on Patch Repository Merge
Select Original rpd as Original_rpd.rpd, select patch as 'patch_to_merge.xml' and save repository as to 'Result_rpd.rpd'

Click on next and see that the changes appear in result_rpd.rpd.



Example 2: Creating and Deleting The objects in copy of existing production rpd(Development rpd) and applying those changes to production rpd.

step1:
 After performing Example 1 you will get the modifications of existing objects to your production rpd. Now import meta data and created new HR objects in Physical , BMM , presentation layers.I have deleted SCOTT subject area , BMM model as shown below.

 

Step2: I am repeating the step3, step4 as in Example 1 by comparing development rpd with original rpd ,  click on Equalize and click on automatic as shown below.
 


create a patch 'patch_to_delte.xml'.
Step3:  Open Original_reference_rpd.rpd , Click on FILE>Merge select original rpd and save rpd as 'Result_delete.rpd', Click on next. It is will display decision box.
 
Note: OBIEE will ask us our decision Strategy only if we have any objects deleted in saved patch, It will not be displayed for modified or created objects.

If we select Current: It will not delete that object and leave it as it is.
If we select Modified(A): It will delete that object and perform as is in patch.

Selecting Subject area to be as is in Current rpd and selecting Busines Model to be as is in Modified(A)
Click on Finish
 Step4:
As decided by us I will not delete SCOTT in BMM but deletes in Presentation layer as shown below.

No comments:

Post a Comment