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.
BI Custom Enrollment Report: Need to include Category
Summary
Need to include Category for Enrollments in a Custom BI ReportContent
I created a custom BI enrollment reports that successfully pulls data on the: enrollment ID, enrollment name, start date, end date, drop-by-date, and duration. I now wish to add the category for the enrollment and have tried a number of options with the category and category mapping data views but I cannot get either to work. I also use both and still no luck. The latest structure using the category data view is attached.
I'd really appreciate guidance on the view/s, joins, and join conditions so that I can get the child category/categories for each enrollment into this custom report. Thanks for your help. Phil
0