Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBI11.1.1.9 Dynamic database source

Received Response
131
Views
18
Comments
2»

Answers

  • Rank 4 - Community Specialist

    HI Christian,

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

    Thanks

    Yossi

  • Rank 2 - Community Beginner

    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.

  • Rank 8 - Analytics Strategist

    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

  • Rank 4 - Community Specialist

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

  • Rank 4 - Community Specialist

    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

  • Rank 2 - Community Beginner

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

  • Rank 4 - Community Specialist

    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:

    pastedImage_0.png

    pastedImage_1.png

    pastedImage_2.png

  • Rank 8 - Analytics Strategist

    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?

Welcome!

It looks like you're new here. Sign in or register to get started.