Skip to Content
avatar image
Former Member

Sap BI 4.1 date issue

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Nov 02, 2016 at 11:35 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 02, 2016 at 11:47 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 02, 2016 at 01:22 PM

    can you apply custom format of the date in universe?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 02, 2016 at 02:10 PM

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

    Add comment
    10|10000 characters needed characters exceeded