we have questin text and answer report but all questions are coming in columns
Summary:
Hi ,
we have questin text and answer report but all questions and answers are coming in columns.
so we get multiple records for each employee i mean 7 questions we get seven records how to over come this issue?
PFA.
Thanks,
Ajay
Content (required):
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
Answers
-
Hi,
Please check this oracle doc id in support.oracle.com
You may find this useful.
Oracle Fusion Recruiting Cloud: OTBI: How to Report on Request Information Questions and Responses (Doc ID 2693295.1)
Subject Area: Recruiting - Recruiting Real Time
Dimension/Folder:
- Job Application > Request Info Questionnaire Responses
- Job Application > Request Info Confidential Questionnaire Responses
Columns/Attributes:
- Questionnaire ID
- Question Text
- Question Response Short Description
- Question Response Long Description
- Question Answer Text
Regards
Venkat
0 -
yes, i have same above coulmns but we need all questions ina row
0 -
Since your requirement is to pivot the data (rows to columns), then you could create a pivot table view while creating the report instead of table view. I suppose that will solve your issue
Regards
Venkat
0 -
It is possible to do that row wise. You have to use the Pivot table. I was trying with your sql but it seems you have few DFFs which are not present here, as a result I'm not able to modify your report.
If you have a simpler version without any DFFs then please attach the report xml so that I can try.
Here is the output of my report where you can see the all answers in a single row.
Hope this help.
Cheers,
0