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

Apr 26, 2019 3:39AM

Summary

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