Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
OTBI Prescreening Questions as column headers - Prescreening Questions OTBI Report
Summary:
We have had a requirement to produce a prescreening questions OTBI report. The subject area has a column for Question Text and a few for the responses.
Content (required):
The issue is they've requested the questions be the column headers and responses be the rows. Has anyone achieved this or handled a similar requirement? I've looked into doing it using a CASE WHEN statement which does work but seems a huge manipulation of the functionality - is there a better way to achieve this?
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
1