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
Get Started with Redwood for Oracle Cloud HCM   Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.

For more information, please refer to this announcement explaining best practices for getting answers to questions.

OTBI Subject Areas not joining properly- Costing & Assignment

edited Oct 30, 2018 1:59PM in Reporting and Analytics for HCM 4 comments

Content

Hello,

I'm trying to combine following two subject areas on multiple ways but it seems like that these are not joining properly despite having all dimensions included in the analysis.

I'm trying to combine some of the information from Payroll Costing Set Up Details Real Time and Workforce Assignment Real Time . However, when I combine them, for each record from assignment I get all payroll records (on the screenshot)

I tried a CASE statement to match per employee number e.g, however I get the error:
"State: HY000. Code: 14025. [nQSError: 14025] No fact table exists at the requested level of detail"

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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