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.
for a particular report, when some users click on the link, the new tab opens but after about 10 minutes of loading the system returns
Summary: Hello experts, We are using WLF_ASSIGNMENT_TASKS_F to fetch the data from the learn tables The WLF_ASSIGNMENT_TASKS_F table, in the LAST_UPDATED_BY field, doesn't reflect who actually updates the task. I've attached the query used. Can you please help me? Content (please ensure you mask any confidential…
https://blogs.oracle.com/analytics/announcing-the-general-availability-of-oracle-analytics-server-2026 As announced, OAS 2026 has moved to FMW 14. What does this mean for the future of OBIA? Given that 103PS4 is for 12.2.1.4 , it would seem another required upgrade beyond 103ps4 will have to happen. What should customers…
Hi everyone, we're experiencing an interesting issue with report filters in Oracle Learning Management (or similar). Problem: When we use filters based on SQL queries, for some specific users the report filters disappear completely, making the report non-functional. Technical Details: We've identified the critical point in…
We use OAS 2025, EBS 12.2.12, OBIA 7.9.6.4, Oracle 19c db on Linux. We are trying to build Project to GL Cost reconciliation report that runs for a period, currently it is done manually, by running three analytics reports (one on Project - Cost subject area to get total cost for Contract and Resources, another report on…
