CODEWITHSUNDEEP
reportingbusiness-objectsuniverse
Viraj
Viraj

Reputation: 1

BusinessObjects: replace all not changing schema name in SAP BO universe

We are using SAP BO 3.1 R. We have one exciting universe and pointing the schema name of table to another database.

I tried using replace all option but it's not replacing schema name of one joining condition of table. When I am pulling columns in webi I can see old schema name with table name in where clause when it's joining two tables with sub query.

I am not sure where to find that joining condition in universe as universe is big. I tried with find option but not getting anything. I can see it in PDF format in joins list.

e.g. if it's ABC.employee I am trying to change it to ABC_x.employee.

Upvotes: 0

Views: 1466

Answers (1)

Joe
Joe

Reputation: 6827

That does sound exciting.

Don't use find/replace. Click-and-drag to select all the tables that need to change (or hit Ctrl-A to select all). Right-click on one of the tables and click Rename Table. Enter the new schema name in Owner, then click OK.

Upvotes: 0

Related Questions