Learning OTBI Report -> Missing 'Classroom' details upon adding 'Instructor' Details

Summary

Learning OTBI Report -> Missing 'Classroom' details upon adding 'Instructor' Details

Content

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

20d

Code 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