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

jnaneshwari hasavimath

The error it throws is : Warning: Possible long compilation time for his expression:
Dim - Contract Customer.Customer Name
because it's not associated with any measure. To eliminate this problem, please add an appropriate hidden measure to your report or declare an implicit fact column.

Please add a measure to your query to resolve this issue.

RVohra

@Ram ANeni

Please review these General guidelines when there is a need to get data from multiple subject areas using facts and confirming dimensions from all the subject areas.

• If all the required metrics and attributes for the report are available in a single subject area and fact, use that single subject area only and don’t create a cross-subject area query.
• When you want to bring the data from more than one subject area, you must choose metrics from all the subject areas in the analysis.
• Start with the necessary filters before you start building visualizations to ensure you use the best performing queries when you add the necessary metrics required in the visualization.
• Always start by selecting all the columns in one subject area, including the facts and dimensions, and then add the facts from the second subject area.
• When joining two subject areas in a report, use at least one attribute from a common dimension

Hope it helps!