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
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.