Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
OTBI Outer Join Subject Areas — 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

OTBI Outer Join Subject Areas

Accepted answer
40
Views
12
Comments
edited Aug 10, 2020 4:44PM in General Transactional Reporting (OTBI) 12 comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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