Change the database schema with @Variable() ??

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 :fr: (BOB member since 2003-09-04)

This thread may be useful to you

https://bobj-board.org/t/16940


Paul Shovlar :uk: (BOB member since 2002-09-05)

Hi paul,
It works very well with @Prompt, thank you for you answer. I hadn’t found this post because I had limited my search to the word “@variable:oops: .

I think it doesn’t work with @variable because I can’t declare the value as numeric to avoid the quotes.

Thanks again.

Fandor


ChristopheA :fr: (BOB member since 2003-09-04)