OTBI | Learn Module | Need an analysis to get specialization name, it's corresponding module name ,

Content

I am working on an OTBI report where I need to fetch specialization name, it's corresponding module name , course name, offering name, offering status, learner.

I am able to get all the columns except offering name, need input on the same.

Code Snippet

<saw:report xmlns:saw="com.siebel.analytics.web/report/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sawx="com.siebel.analytics.web/expression/v1.1" xmlVersion="201201160">
   <saw:criteria xsi:type="saw:simpleCriteria" subjectArea=""Workforce Learning - Learning Management Real Time"" withinHierarchy="true">
      <saw:columns>
         <saw:column xsi:type="saw:regularColumn" columnID="c7c5e135da2d592d8">
            <saw:columnFormula>
               <sawx:expr xsi:type="sawx:sqlExpression">"Specialization Activities"."Activity Name"</sawx:expr></saw:columnFormula>
            <saw:tableHeading>
               <saw:caption fmt="text">