Update Universe with new connection & schema

[Former Member]

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.

[amitrathi239]

Hi,

Change the owner/Qualifier by Right click Table->Change the owner/Qualifier in DF layer and check.

If these changes will not reflect in the business layer then remap the data foundation layer to Business layer again and see

Amit

[Former Member]

Hi Amit,

Thanks for your response, this way we will have to change all the tables (may be 1000 in number) manually which will be tedious and risky.

If anyone has any idea about option in IDT which can do this for me automatically ?

[amitrathi239]

Hi,

Not very sure but check with CTRL or SHIFT key to select multiple tables and change the owner/Qualifier name.

Amit

[Former Member]

Hi Amit,

It worked this way, we can select multiple tables using CTRL key and then change qualifier in one GO ... for derived tables we have to edit the query for each table.

Thanks a lot !!