Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

Dynamic DB connection after logged into OBIEE

Received Response
71
Views
15
Comments
2»

Answers

  • Selva Pandiyan
    Selva Pandiyan Rank 3 - Community Apprentice

    Hi Gianni,

    These 40 schema resides in 40 hosts.or may be in 4 or 5 Regional Servers.

    Thanks

    Selva

  • Gianni Ceresa
    Gianni Ceresa Mod

    So the 2nd (if 40 hosts) and 3rd still match

  • Selva Pandiyan
    Selva Pandiyan Rank 3 - Community Apprentice

    Hi Gianni

    Could you throw some more light on options 2 or 3.

    Thanks

    Selva

  • Gianni Ceresa
    Gianni Ceresa Mod

    For 2 the idea is to reduce the variable part to just 1 value (so setting same username and password and keeping the host dynamic). In this way you can use the variable set by the prompt to point to the right host.

    For 3 you import in the RPD and map in the physical and logical layers all the 40 schemas. You then setup row level security (or LTS filtering) based on the user. So if user A => allowed to see country 1, 2 and 5. If user B => country 9 etc.

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics & AI Strategist

    Option 4 is federate/replicate the data to a central database and use the concept of a DATA_SOURCE_ID to filter the rows by their original source DB ... via a 'select sinlge value only'-type prompt