Table or view not exists when we join multiple Subject Areas

Ram ANeni

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

Mallikarjuna Kuppauru-Oracle

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

RVohra

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!