Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
How to get the two rows of data in single row in OTBI — Cloud Customer Connect
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
85
Views
3
Comments
edited Apr 26, 2019 3:39AM in Reporting and Analytics for HCM 3 comments

Summary

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

Content

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. 

Example:

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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