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.

[IDT 4.x] Date Formats in Dervied Table Joins-SQL Server -Oracle


 
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
Mjames
Forum Member
Forum Member



Joined: 16 May 2018

Posts: 1



PostPosted: Wed May 16, 2018 1:58 pm 
Post subject: Date Formats in Dervied Table Joins-SQL Server -Oracle

Hello all,
I am getting two tables into IDT, one from Oracle and the other from SQL Server.
Issue - When I join using the dates from both tables the results are 0.
Checked with to string, to date , to string to char but doesn't work.
Did anybody have such issues and can suggest ?

to_date(Column1-SQLServer)=to_date(Column2_Oracle)



Regards,
Venkat
Back to top
Debbie
Forum Addict
Forum Addict



Joined: 01 Mar 2005

Posts: 2743
Location: Cheshire, England


flag
PostPosted: Mon May 21, 2018 2:51 am 
Post subject: Re: Date Formats in Dervied Table Joins-SQL Server -Oracle

Where are you joining the tables? If it's in IDT, you need generic SQL that both SQL and Oracle can use. Have a look at my post here - about half way down for some ideas: http://www.forumtopics.com/busobj/viewtopic.php?t=152613&postdays=0&postorder=asc&start=30

debbie
Back to top
joepeters
Forum Fanatic
Forum Fanatic



Joined: 29 Aug 2002

Posts: 6417
Location: Connecticut, USA


flag
PostPosted: Mon May 21, 2018 12:52 pm 
Post subject: Re: Date Formats in Dervied Table Joins-SQL Server -Oracle

When using multisource universes, joins and object definitions must* use Multisource SQL, and not the underlying database's SQL.

With that said, what is the data type of the two date fields? Are they strings, dates, timestamps?


*Sort of... The is a NATIVE EXPRESSION function that does this but is not documented.
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.0297 seconds using 17 queries. (SQL 0.0029 Parse 0.0009 Other 0.0259)
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