Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

we have questin text and answer report but all questions are coming in columns

Received Response
160
Views
5
Comments
AjayKumar Maddipati
AjayKumar Maddipati Rank 5 - Community Champion
in Oracle Transactional Business Intelligence

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):

Tagged:

Answers

  • Venkat Koduvayur-Oracle
    Venkat Koduvayur-Oracle Rank 4 - Community Specialist

    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

  • AjayKumar Maddipati
    AjayKumar Maddipati Rank 5 - Community Champion

    yes, i have same above coulmns but we need all questions ina row

  • Venkat Koduvayur-Oracle
    Venkat Koduvayur-Oracle Rank 4 - Community Specialist

    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

  • Bhaskar Konar
    Bhaskar Konar Rank 6 - Analytics Lead

    Hi @AjayKumar Maddipati,

    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,

  • User_VCD7M
    User_VCD7M Rank 1 - Community Starter
    edited September 30

    Yes, using Pivot table would help in getting all responses in a single row instead of getting one row for each question response (therefore multiple rows for each candidate).

    I have a different issue. Anyone has a multiple choice/selection question and able to get all answers (more than 1 answer to the question like some one who selected multiple languages they could speak) in the output? My report only shows one response in the output and its a random response (not alphabetical).