Unable to join Workforce Goals - Goal Status Overview Real Time and Workforce Performance - Performa

Khush Tiwari Credit Suisse

Summary:

Hi Team,

I have a requirement where I need to fetch goal plan details along with rating details for a specific goal plan for employees. I have included fact columns from both the subject area, common attributes and enable dimensionality checkbox. But whenever I try to introduce a column from performance rating subject area I get "No fact table exists at the requested level of detail error". Please help me with the error asap.

Regards,

Khush Tiwari

Capture.PNG

Content (required):

PFA the screenshot of the error

Version (include the version you are using, if applicable):

Logical SQL.txt

Code Snippet (add any code snippets that support your topic, if applicable):

PFA the logical SQL.

Sahithi Kolasani-Oracle

Competency Name column is causing the error.

if we remove this column, report works fine.

In OTBI, we will be able to create a cross subject area report only if the underlying dimensions are joined to the fact tables and the grain is supported. Otherwise, this error "No fact table exists at the requested level of detail error" is reported.

gdegenna

I have the same problem? have you solved it?

Gaurav Bharadwaj-Oracle

Hi,

There are certain rules to be followed when building cross SA analysis. Sahithi also explained it well.

In addition to that you may want to review these 2 documents and verify if you are following the guidelines :

Fusion BI : What Are the Key Steps Required to Perform Cross Subject Area Analysis ? (Doc ID 2013245.1)

Fusion Applications OTBI: Guidelines for creating cross subject area analyses in Oracle Transactional BI (Doc ID 1567672.1)

Sahithi Kolasani-Oracle

Thanks for sharing @Gaurav Bharadwaj-Oracle

Bhaskar Konar

Thank you very much @Sahithi Kolasani-Oracle & @Gaurav Bharadwaj-Oracle !

Appreciate your help.

Cheers,