Hello everyone,
I am in a situation where the prefix of the table schema to all the tables
is causing me a problem. I am working with ORACLE database. I have multiple
database schemas set up for development, test, and production. Obvioulsy they
all contain the same tables, however the schema names differ. This is a
problem when I want to change the datasource of the cubes to point from the
"dev" schema using "tablex", to the "test" schema, because it can no longer
find the table ("dev"."tablex"). If the schema prefix wasn't there, then the
switch would work due to the table names being the same. Any advise or a way
to disable the schema prefix would be much appreciated.
Thanks.