Oracle Analytics and AI

Vibha Pandey - Oracle

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.

Gaurav Bharadwaj-Oracle

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