You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to get the two rows of data in single row in OTBI

Received Response
edited Apr 26, 2019 3:39AM in Reporting and Analytics for HCM 3 comments


How to get the two rows of data in single row in OTBI


Hello Team,

I am using organization hierarchy in one report, we have two tree codes here, i want to get the two tree code values in a single row. 


Test 1 Hierarchy, Test 2 Hierarchy

For Test 1 Hierarchy, i want to show Level 05 Org to Level 10 Org

For Test 2 Hierarchy i want to show Level 01 org to Level 02 Org

Both the level values should be in same row

I am using case condition in Edit Formula like below:

CASE WHEN "Organization Hierarchy"."Tree Code"= 'TEST1_HIERARCHY' THEN "Organization Hierarchy"."Level 05 Organization Name" END


Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!