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