Categories
OBI11.1.1.9 Dynamic database source
Answers
-
HI Christian,
We would like to switch according to an initialization block parameter.
Thanks
Yossi
0 -
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.
0 -
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
0 -
Thanks Christian , I tried this also, regarding the data types - unfortunately, didn't work..
0 -
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
0 -
As I said this is basic config and must work - so best post screenshots of the business model, the LTS details and so on
0 -
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:
0 -
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?
0