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.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
OTBI Subject Areas not joining properly- Costing & Assignment
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"
0