Skip to Content

Step by Step Process to update BO Audit Universe 4.0 to 4.1

Step 1: Create a Relational Connection for your new Audit Database 4.1

Right click on Local Project, and Create a new relational connection

/wp-content/uploads/2013/10/1_293138.jpg

Give relevant connection name and description as in snap shot below and click on next

/wp-content/uploads/2013/10/2_293139.jpg

Select Database driver, in my case it is MS SQL SERVER 2008 OLE DB and click on next,

/wp-content/uploads/2013/10/3_293140.jpg

Fill in Connection Parameters and test connection on Successful test click on Finish,

/wp-content/uploads/2013/10/4_293162.jpg

Step 2: Export the Relational Connection to BO 4.1 Repository

Right click on Relational connection created in previous step and select Publish Connection to a Repository

/wp-content/uploads/2013/10/5_293163.jpg

Connect to BO 4.0 Repository and then click next,

/wp-content/uploads/2013/10/6_293164.jpg

Select folder and click on finish,

/wp-content/uploads/2013/10/7_293165.jpg

Click on Yes to create a secured connection shortcut in local project,

/wp-content/uploads/2013/10/8_293166.jpg

Final Screen,

/wp-content/uploads/2013/10/9_293167.jpg

Step 3:Open Audit Universe’s Data Foundation, go to Connection tab and change the connection

Open Audit universe’s Data Foundation file,

/wp-content/uploads/2013/10/10_293168.jpg

Click on change connection, and select the secured new connection, Click OK

/wp-content/uploads/2013/10/11_293169.jpg

Step 4: Change the Qualifier/Owner of all the tables of the schema and save data foundation

Right click on the table and select change Qualifier/Owner ,

/wp-content/uploads/2013/10/12_293176.jpg

Select the new Qualifier and Owner,

/wp-content/uploads/2013/10/13_293210.jpg

Repeat the above step for all the tables in schema, save the Data Foundation.

Step 5: Open Business Layer of Audit database check the integrity and export it to BO 4.1 Repository

Right click on Business Layer of Audit Universe, and select Publish to a Repository,

/wp-content/uploads/2013/10/14_293211.jpg

Click on Check All, click on Check Integrity,

/wp-content/uploads/2013/10/15_293212.jpg

On checking business layer integrity, check are there any errors if not click on next,

/wp-content/uploads/2013/10/16_293219.jpg

Select the folder to save the universe, and click on finish,

/wp-content/uploads/2013/10/17_293220.jpg

Click on close to finish.

/wp-content/uploads/2013/10/18_293221.jpg

You have successfully made the Audit universe working for 4.1! 🙂 🙂 🙂

To report this post you need to login first.

6 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply