Forum Stats

  • 3,874,841 Users
  • 2,266,780 Discussions
  • 7,911,978 Comments

Discussions

Is there any way in OTBI analysis where we can transpose columns to rows?

VPSangle
VPSangle Member Posts: 1
edited Nov 25, 2019 2:43AM in HCM Cloud Service

We have developed OTBI analysis where we are using multiple subject areas. And we are getting historical rating for our employee lets say from last three years, the result include Year and Rating which result in values for each year and create three different rows for each employee as shown below.

EmpEmp IDCurrent RatingHistory YrHistory Rating
ABC123420163
ABC123420174
ABC123420184

What our expectation is

EmpEmp IDCurrent Rating2016_Rating2017_Rating2018_Rating
ABC1234344

I tried logical sql and use union but its not allowing to use set operation because some of the columns in our report are hirerarchical/we have selection steps.

Please suggest a way (apart from SQL BI Report) to achieve the same result using OTBI analysis.

Gabriel Grigorie-Oracle

Answers