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

Duplicate element entry report with entry details

Received Response
102
Views
1
Comments
Vibha Pandey - Oracle
Vibha Pandey - Oracle Rank 3 - Community Apprentice
edited Apr 6, 2024 3:33PM in Oracle Transactional Business Intelligence

I have a requirement where I need to report on more than one element entry for a person where the input values differ. Attached is the OTBI analysis details on how I have developed but I need to correct in a way that it gives me only two rows with the input values and displayed value as columns to the element entry.

In the screen shot I have an employee who has an element twice, in this case the Input values are different in terms of STATE, COUNTY, CITY and % of Time Worked. Business Purpose is to capture employees who work across locations in a pay period.
I am able to get two rows until I am fetching STATE value, but as soon as I add rest of the input values, the rows start multiplying.
The first ss is first output when the other Inputs are not added. The 2nd ss is when I add rest of the inputs. The 3rd is what I am expecting.

Current Output 1.png Current Output 2.png Expected.png
Tagged:

Answers

  • Gaurav Bharadwaj-Oracle
    Gaurav Bharadwaj-Oracle Rank 6 - Analytics Lead

    Hello @Vibha Pandey,
    I understand you are asking a question regarding Data in Analysis built using Subject Area.

    Please note that grouping happens implicitly from left to right in OTBI.
    You are getting 2 rows because you are adding the state column, the 2 rows in this case cannot be called duplicate rows, since the data in both rows is unique(AK and AL). So this is expected output.

    You can try using Pivot Table to see if that provides the kind of output you are expecting(which is basically to convert values in rows to columns also called Transposing rows to columns)
    https://community.oracle.com/customerconnect/discussion/544606/transpose-rows-to-columns-in-otbi

    Another option that you can explore and try :
    Oracle Fusion Recruiting Cloud: OTBI: How to Transpose Values from Rows to Columns in a Report (Doc ID 2878783.1)

    Additionally, in case you want to stop the fields Person Number, Display Name and Input Value Name from repeating in the output you can edit the columns in criteria and click on properties and set these columns to suppress repeating values.

    You can know more about it here :

    https://www.youtube.com/watch?v=mtjFBjiRHao

    If my response has answered your question or assisted you with your concern, please click "yes" below to accept the answer or comment with any additional queries. You can also read the Cloud Customer Connect Guidelines for Accepted Answer

    Regards,

    Gaurav