Error while joining two subject areas — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Error while joining two subject areas

edited Jun 25, 2020 5:21AM in Reporting and Analytics for HCM 12 comments

Summary

Error while joining two subject areas (No fact table exists at the requested level of detail:)

Content

I am trying to fetch list of roles that a worker has along with their current department (tied to assignment). I used two subject areas - 'Security - Roles & Privileges Real Time' & 'Workforce Management - Worker Assignment Event Real Time'.

I first inserted only Person Number & Role from Security SA and it worked. I then added 'Worker.Person Number' & 'Department.Name' from Workforce Management - Worker Assignment Event

Real Time SA and then it gave this error. If i remove 'Department.Name' and include only Worker. Person number from 2nd SA, it works fine. Any pointers how to fix this?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!