Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Different Schemas in different environments for same tables used in a Universe

Hi,

I have a Universe in Development where I have tables pointed to a schema (DW) in DEV but in TEST/INT I have the same tables under a different schema (TESTDW). So when I promote the Universe & reports from DEV to TEST, I will be getting errors as the schema is incorrect. So we need to find a way so that we can define the schema globally instead of having it at the individual table.

I know we can repoint the schemas, etc but i need to avoid extra work in other environments.

Known Solutions: Promote the reports to TEST, then select all the tables & change the schema by Right Clicking the selected tables and selecting Change Qualifier/Owner.

One of the few reasons, I don't want to follow this route, because I have lot of derived tables which I need to change it manually by editing the SQL Statement,  &  also If I add new tables or columns again in future & promote them to TEST, then again I have to change the schema.

Did anyone faced this kind of issue?Is there any other way that we can use like Begin_Sql , etc?


(FYI, I am using BO4.0 SP5)

Tags:
Former Member replied

Hi ,

You can go for synonyms.

because synonyms can have same name in all the schemas

Thanks,

Swapnil

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question