Universe mapping

[Former Member]

HI All,

we have a Bo Universe which is using tables from one of our developer's schema, now we are planning to promote these table to production, so my question is will the universe will get mapped automatically to the data now in production or do we have to create the new universe based on the new data.

Please suggest me the we to do that

thank you

[Former Member]

hi Malik,

If its a universe created through IDT, then you have to get the universe and connection migrated to PROD and then re-point the migrated connection to PROD DB/DSN etc.After that follow below steps

Import the unx to your local project

create new shortcut on the updated PROD connection and overwirte the old shortcut thats pointing to DEV

Publish the universe.

What is the version of your BO? is that a unx or unv universe?

Thanks

Mallik

[former_member182521]

Hi Malik,

If you are using Oracle tables you may required to consider the Schema name as well while mapping tables in production.

Regards

Mani

[CdnConnection]

Malik,

     The Universe is just the metadata on a given datasource.   In DEV you have a system ODBC DSN that is pointing to BOBJ Connection name that points to db and then Universe is created on that datasource.   When you promote your Universe to PROD, it will only promote the Universe only and BOBJ Connection name is promoted.  You still need to make sure proper System ODBC DSN that need to be created.  If the structure of the DB is same then you would just need to make that that BOBJ Connection name point to System ODBC and then refresh structure to pick-up any changes in PROD.

Regards,

Ajay

[Former Member]

Hi,

You don´t need to recreate the universe, first of all you must have created the tables in the producction data base and before export the universe you must change the conexion parameters from testing DB to production DB. Test the conexion and then go to tools and probe the integrity.