Avatar of naveenreddyinus
 asked on

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


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 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, 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)
DB Reporting Tools

Avatar of undefined
Last Comment
Mike McCracken

8/22/2022 - Mon
Maruthi Rao Yarapathineni

as per my understanding we need to perform only once in all three environments. next time onwards we don't promote the connections.  we just promote with out any dependencies.
Since you are dealing with many derived tables, you need to perform this activity manually. Mostly I deal with SAP BW almost way back I have worked on DW back end.

I know the solution that you are saying. I already mentioned it in my question. I am looking for an alternative solution.
Mike McCracken

View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.