To migrate business rules from one environment to another using import and export feature of EAS console


When we export the BRs, EAS exports the BRs in a xml file, this xml files contains all the BRS, Security (if you are not exporting for Calc Manager), locations etc. Now if we are trying to migrate the BRs from say Production to Development environment, we have to update the location of the BRs the .xml file because when we export our .xml will have the BR location of Production and here we are trying to migrate the rules to Development, so we need to update the .xml and modify the location of Brs.


Here are the steps to export and import rules from one server to another:

1. Log into EAS console of Source Environment using an admin id, 
2. Right Click on Business Rules Node,
 
3. Click on Export,
 
4. In the right hand pane you will get all the BRs listed, Click on Select All,
5. Uncheck For Calc Manager,
6. Click on Dependents,
7. Export the rules,
8. This will ask to save the BRs in a XML format save the .xml file,
9. Save As the .xml file with a different name,
10.Edit the .xml file and replace all the Old locations of BRs with the new one, the location is case sensitive and there will be two location we need to replace small case with the small one and Upper case with the Upper one, Ex: A part of exported .xml

Source .xml:
<Location>
<property class="int" method="setLocID" value="41"/>
<property class="int" method="setLocationID" value="41"/>
<property class="java.lang.String" method="setLocation" value="ProdClusterEPPLAN"/>
<property class="java.lang.String" method="setUpperLocation" value="PRODCLUSTEREPPLAN"/>
<property class="int" method="setCluster" value="-1"/>
</Location>

Say if our Destination Location is: "Planning/WDBSSAPEPMR03/EPPLAN/EPPLAN"

In this case in your source file replace All:

ProdClusterEPPLAN with Planning/WDBSSAPEPMR03/EPPLAN/EPPLAN
and
PRODCLUSTEREPPLAN with PLANNING/WDBSSAPEPMR03/EPPLAN/EPPLAN

12. Save the file,
13. logging in the destination EAS console,
14. Right click on Business Rule node,
15. Import the BRs using the modified .xml file.

PS: If you are not sure of the destination location, Create a Test Rule in the destination environment assign security, export the rule, look at the xml to find the exact location.

Cheers..!!!
Rahul S. 

Comments

Popular posts from this blog

Multiple Navigation Flows are Active

The Member Does Not Exists For The Specified Cube

"Smart View handled an unknown exception thrown by Microsoft Office" Error on Vista, Windows 7, Windows 2008