Hi,
I have several schemas on a database with exactly the same tables. Each schema have the data for a specific country.
On them, I want to create an unique universe but I don’t want to duplicate the objects (ex: I want only one object called “Customer Name” which return UK Customer or FR Customer according to the chosen country).
For that, I can use the function aggregate_aware, but I want to try an other method using @Variable() to choose the schema. On my universe, I replace the Owner by @variable(‘Schema’) and I start BO by command line with a “vars” file. During the execution of my query, I receive a SQL error “ORA-00942 table or view does not exist”.
Does anyone have tried something like this with more success?
Fandor
ChristopheA (BOB member since 2003-09-04)