Table or view not exists when we join multiple Subject Areas

Question

Hi Team - We created a Dashboard and report using four subject areas. Procurement - Spend Financial - AP Payments PPM - Project Revenue PPM - Project Invoices

When we try to get the customer name from PPM - Project Revenue as a filter, it's giving the following error where as if we use in results in table format, it's fetching the data. SELECT 0 s_0, ifnull("PPM - Project Revenue"."Contract Customer"."Customer Name",'N/A') s_1 FROM "PPM - Project Revenue" WHERE (("Procurement - Spend"."GL Segment2 Hierarchy"."Segment Tree Filter" = 'Line of Business CORP_COA01~Line of Business CORP_COA01 Current') AND ("Procurement - Spend"."Time"."Fiscal Calendar Name" = 'CORP_COA') AND (DESCRIPTOR_IDOF("Procurement - Spend"."Business Classification"."Business Classification") IS NOT NULL)) FETCH FIRST 500001 ROWS ONLY

RVohra · Answer

Hi @Ram ANeni , as per my understanding, this is expected in when mixing subject areas,

When we add a column to Results, OTBI generates a logical outer join like query and Subject areas can coexist as long as there is a conformed dimension path.

When we add a column to Filters, OTBI generates a constrained WHERE clause and the filter must be resolvable across all subject areas because OTBI tries to push the filter to the driving subject area.

Hope it helps!

Mallikarjuna Kuppauru-Oracle · Answer

Hi @Ram ANeni

if the report build based in ootb subject area's, can you share me your .dva file for testing purpose to see what causing the issue  for failed case?

Regards,

Arun