How to change data source of Universe

[Former Member]

Hi,

I have two databases called A_Database and B_Database

Same tables and data are in both the databases.

I created universe U_universe using A_Database. It is working fine

Now I would like to change from A_Database to B_Database in U_universe without affecting any thing in U_universe because tables and data are same.

Please let me know following doubts.

1.How to do above things?

2.if A_Database and B_Database are in different server, how to overwrite data source in the universe

3.if A_Database and B_Database are in the same server, how to overwrite data source in the universe

Thanks and Regards,

Manjunath

[Former Member · Accepted solution]

You have to create first ODBC connetion for the Second Database.

Select Tools > Connections.Create new Connection there.

You can use the connection wizard to set advanced and custom parameters

for a connection.

Now in File > Paramerter. Change the connetion whcih you have ceated.

[Former Member · Accepted solution]

Can you please explain in detail for File> paramater? I am stuck here.

[denis_konovalov · Accepted solution]

In Designer, import your universe, click on File>Paramers or click on parameters icon on the tool bar and change connection used by the universe from one pointing to Universe A to one pointed to universe B.

Also, visit this site : http://help.sap.com/content/bobj/bobj/index.htm

Look for Universe Designer guide.