BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: No events within the next 45 days.

How to include null in join


 
Search this topic... | Search Semantic Layer / Universe Designer... | Search Box
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Author Message
BOXI R2
Forum Member
Forum Member



Joined: 08 Oct 2013

Posts: 5



PostPosted: Tue Jul 09, 2019 8:49 am 
Post subject: How to include null in join

Hi,

I have a table which joins to second table on date values, its left outer join. Lets say the two are joined on start_date and update_date. There's a prompt on report which for calmon. this calmon is noting but extracting YYYYMM from start_date of table 1.

Now we can have null values for start_date but I want them in output anyway. Since the filter is on start_date(YYYYMM) the null values never shows in output.

I cannot have a calculated field as well since, I will be assigning a default value to the field in that case so it will be filtered as there will be no matching update_date in table 2.

I am working on BO4.2 with Oracle as DB

How can I capture those null Start_date rows.

TIA
Back to top
Marek Chladny
Forum Advocate
Forum Advocate



Joined: 27 Nov 2003

Posts: 19316
Location: Bratislava


flag
PostPosted: Tue Jul 09, 2019 10:24 am 
Post subject: Re: How to include null in join

[Moderator Note: Moved from General Discussion to Semantic Layer / Universe Designer]
Back to top
charlie
Forum Associate
Forum Associate



Joined: 20 Aug 2002

Posts: 898
Location: Woodinville, WA USA


flag
PostPosted: Tue Jul 09, 2019 2:04 pm 
Post subject: Re: How to include null in join

Not exactly sure since you didn't post your join code, but maybe add something like
Code:
OR ( table1.start_date IS NULL AND table2.update_date =@Prompt('Select update date','D',...
to the join code.
_________________
Regards,

Chaz
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0323 seconds using 17 queries. (SQL 0.0036 Parse 0.0011 Other 0.0276)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo