Skip to Content
avatar image
Former Member

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Aug 17, 2015 at 08:56 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member AMIT KUMAR

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