Cross Subject Area join between Checklists and Helpdesk Request Subject Areas

Question

There are Checklists created for certain Helpdesk Service requests. We need the data from both checklist and helpdesk on an OTBI Analysis cum Dashboard. Is it possible? Can we join Helpdesk Requests Summary Real Time with Checklists Real Time subject area.

We need the Service Request details along with the checklist questionnaire attached to it.

Vibha Pandey - Oracle · Answer

Thank you!

One more question. In helpdesk, not all SRs that have Journeys assigned via Checklist Questionnaire. While I pivot, my results show all the SRs of a person irrespective of only a few SR have checklists assigned. This causes duplication of records. How can I restrict that? I understand that it might be a custom flag on the OTBI which indicates "ASSIGNING JOURNEY", but I am not able to locate it. I am referring to the screenshot attached.

Raghavendra Raghunath-Oracle · Answer

Hi Vibha, yes you can pivot the data even if the report is created from the logical sql

Raghu

Vibha Pandey - Oracle · Answer

Hi Raghu,

Will I be able to do the pivoting if I use L-SQL?

I need to do the pivot to get the Question in saperate columns.

Regrads,

Vibha