Skip to Content
0

Sap BI 4.1 date issue

Nov 02, 2016 at 11:27 AM

39

avatar image

Hello,

I have a problem with a date object, I create a date object based on the date from db, and i can`t use it in the filter bar i keep having the following error:

i used also trunc and cast but no result, can you please help?

thanks.

9w76t.png (14.8 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

AMIT KUMAR
Nov 02, 2016 at 11:35 AM
0

It's a generic SAP Note.What is the date object datatype in DB and what datatype you have selected in the universe object?

Share
10 |10000 characters needed characters left characters exceeded
Alin Gurcuti Nov 02, 2016 at 11:47 AM
0

the object is a date format, I think it is a conflict because the date format in DB is like this: 07-06-2013 17:36:58,000034000 EUROPE/BERLIN

Share
10 |10000 characters needed characters left characters exceeded
Jawahar Konduru Nov 02, 2016 at 01:22 PM
0

can you apply custom format of the date in universe?

Share
10 |10000 characters needed characters left characters exceeded
Alin Gurcuti Nov 02, 2016 at 02:10 PM
0

i used trunc(result_date) and cast (result_date as date) and it didn`t return any value

Share
10 |10000 characters needed characters left characters exceeded