You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

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

edited May 17, 2021 5:12AM in Learning 10 comments

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">
       

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!