Dynamic DB connection after logged into OBIEE

Selva Pandiyan

Hi Gianni,

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

Thanks

Selva

Gianni Ceresa

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

Selva Pandiyan

Hi Gianni

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

Thanks

Selva

Gianni Ceresa

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

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