Good day,
Please kindly assist is it possible to create a single subject area from two tables that sit in two different schemas in the database.
I created two separate connection pools to pull the tables. Schema names ADMPROD1 and PXRPT1
Hi User_B4S9A,
@Gianni Ceresa has already provided the solution. If you still need with simple practical example, please visit the link https://obiee-oraclebi.blogspot.com/2024/04/join-two-tables-from-different-schemas.html
Yes you can.
What you generally do is to define them as 2 different physical databases (so not 2 connection pools in the same physical database), define the joins as you need (you can join objects of different databases) and then you unify them into a single logical model.
Or in your case, just grant access to the same database account to the 2 schemas.
The tool doesn't handle multiple connection pool in that way (2 different users to connect to 2 schemas), it handle the multiple connection pool for variable and other things like that.
