OBI11.1.1.9 Dynamic database source

Yossi Belitsky

HI Christian,

We would like to switch according to an initialization block parameter.

Thanks

Yossi

[Deleted User]

1.) Why "combine"? You said either one or the other. Not "both together".

2.) How is your session variable instantiated? Maybe '0' vs 0 ? Data types are important.

3.) This must work because it's an extremely basic concept that's being used all over the place.

Robert Angel

As Christian says fragmentation does work, I would; -

a. Double check your data source actually has the values you think it does

b. Double check that it always takes the first source by adding; AND 1=2 to the first condition and OR 1=1 to the second - if it fails in this condition then I would open an SR

Yossi Belitsky

Thanks Christian , I tried this also, regarding the data types - unfortunately, didn't work..

Yossi Belitsky

Thanks Robert, I tried this also as you suggested:

first source:

"Alma Funds Expenditure"."D15 Item Loan"."Source" <>'1651'

and 1=2

Second source:

"Alma Funds Expenditure"."D15 Item Loan"."Source" ='1651'

or 1=1

Still it went to the first one..

I think I'll open an SR as you suggested.

Thanks a lot

Yossi

[Deleted User]

As I said this is basic config and must work - so best post screenshots of the business model, the LTS details and so on

Yossi Belitsky

As you could see below the first source "D15 Item Loan" will always be false, and the second "D15 Item Loan_Vertica" should always be true but still the source is pointing to the first not to the second database:

Robert Angel

And any good reason you have the content level set on the first but not on the second?

Can you try with the second also set and see what result you get?