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.
Learning OTBI Report -> Missing 'Classroom' details upon adding 'Instructor' Details
Summary
Learning OTBI Report -> Missing 'Classroom' details upon adding 'Instructor' DetailsContent
Hello,
Can anyone please help?
I have an OTBI report around Learning subject area (Workforce Learning - Learning Management Real Time) and would like to include Offering Activity Name, Instructor and Class room details.
When I add 'Instructor', there is an additional row but I like to get a single row consisting of Instructor Name, Offering Activity Name and Class room details. Attached a picture of the results and also the LSQL.
Appreciate your help.
thanks,
Santosh
Version
20dCode Snippet
SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT "Workforce Learning - Learning Management Real Time"."Classrooms Specific Information"."Resource Number" s_1, "Workforce Learning - Learning Management Real Time"."Learning Item Type"."Code" s_2, "Workforce Learning - Learning Management Real Time"."Learning Items"."Learning Item Identifier" s_3, "Workforce Learning - Learning Management Real Time"."Learning Items"."Learning Item Number" s_4, "Workforce Learning - Learning Management Real Time"."Offering Activities"."Activity Name" s_5, "Workforce Learning - Learning Management Real Time"."Offering Activities"."Activity Start Date" s_6, "Workforce Learning - Learning Management Real Time"."Worker (Instructor)"."Display Name" s_7 FROM "Workforce Learning - Learning Management Real
0