Skip to Content
Former Member
Aug 17, 2015 at 07:22 AM

Update Universe with new connection & schema


Hi Gurus .. Urgently need a solution of below situation

We have few universes built on top of database with database schema name as ABC_1 so all the objects in dft layer and blx have select statement

as "ABC_1.dbo".Field_Name.

Now we have to point the universe to new database schema name ABC_2 for this we have done the changes to change the connection name to

point to ABC_2 but object SQL statement remains the same "ABC_1.dbo".Field_Name so what is the solution to change the SQL statement to

"ABC_2.dbo".Field_Name so that we know existing objects are pointing to new database.

BI4.1 SP5 is the environment.