cancel
Showing results for 
Search instead for 
Did you mean: 

DATE datatype is not recognised within universe designer in SAP BO 4.2 sp6

0 Kudos

Please can you advise if there is a known issue with Business Objects 4.2SP6 where a connection is made to SQL Server 2014 and the DATE datatype is not recognised within universe designer and while using date time there is no issue.

Please find the attachment of the error that I am getting using both the data types

1.png2.png

amitrathi239
Active Contributor
0 Kudos

Please use "SAP BusinessObjects - Semantic Layer" tag for Universe related question.

Accepted Solutions (0)

Answers (2)

Answers (2)

0 Kudos

I just wants to know that the DATE data type will work in the SAP BO 4.2 sp 6 or not.

amitrathi239
Active Contributor
0 Kudos

I don't have Bi 4.2 SP06.

0 Kudos

Is there anything else by which you can tell me that how this date data type will work in UDT or not while character and date time is working ?

amitrathi239
Active Contributor
0 Kudos

is it working in previous BI 4.x version? try with CAST function in universe designer.

0 Kudos

have you ever tried this data type in SAPBO 4.2 sp6 UDT