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

w ehave OTBi Report skills and certfications but it showing unparallely ?

Received Response

21

Views

1

Comments

AjayKumar Maddipati Rank 5 - Community Champion

May 23, 2023 11:48AM in Oracle Transactional Business Intelligence

HI Team,

We have report facing this is how can sorted .

How it looks in the report

How we need it to look like:

SqL for query.txt

Tagged:

• HCM
• OTBI
• Report Layouts
• Report Output

0

Answers

• 

  Nathan CCC Rank 7 - Analytics Coach

  May 23, 2023 11:52AM

  Hi, Try a pivot table. You will need a column that says whether each row is type Skill or type Certificate.

  Oracle® Fusion Middleware

  User's Guide for Oracle Business Intelligence Enterprise Edition

  12.2.1.3.0

  E80922-02

  November 2017

  https://docs.oracle.com/middleware/12213/biee/BIEUG/GUID-843DD4CA-B575-4752-82DE-831768C1215D.htm#GUID-2B184B01-1FA5-4A09-9D4B-2F49227FE122

  0