OTBI Outer Join Subject Areas

Summary

How to connect subject areas where I need to represent null for rows that are not existing in other subject area

Content

Hello,

I am struggling with creating an analysis.

One of my subject areas is 'Product Management - Source System Item Real Time'.

Column 1: Item Name 

Column 2: Item Status

Colum 3: Formula Column with following formula

CASE WHEN TIMESTAMPDIFF(SQL_TSI_DAY,"Who Columns"."Item Last Updated Date", CURRENT_DATE)<2  THEN 'Days 00-01'

WHEN  TIMESTAMPDIFF(SQL_TSI_DAY,"Who Columns"."Item Last Updated Date", CURRENT_DATE) between 2 and 7 then 'Days 02-07' 

WHEN  TIMESTAMPDIFF(SQL_TSI_DAY,"Who Columns"."Item Last Updated Date", CURRENT_DATE) between 8 and 14 then 'Days 08-14'