Cross Subject Area join between Checklists and Helpdesk Request Subject Areas

Vibha Pandey - Oracle

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.

Raghavendra Raghunath-Oracle

Hi @Vibha Pandey There might not be the common worker dimension between these two subject areas. You can build the report using logical sql query. You can join the two SA's based on Person Number, Assignment Number etc

Raghu

Vibha Pandey - Oracle

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

Raghavendra Raghunath-Oracle

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

Raghu

Vibha Pandey - Oracle

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.