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 areaContent
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'
Tagged:
0