Date Conversion issue in Universe based on HANA calculation View

[Former Member]

Dear Experts,

In HANA we have field like Schedule payment date as data type as NVARCHAR, we have created universe based on HANA calculation view.

In IDT business layer when running the query with schedule payment date as prompt we are getting the error as below.

[303]: invalid date, time or Timestamp value: search table error :[6931] attribute value is not a date or wrong syntax;

Can any one help me on this issue, as this is urgent issue we need to resolve ASAP.

[former_member208919]

Hi Ravi,

In which format you are providing the date in prompt. like for example '20150401' or '2015-04-01'.

In your HANA calculation view what is the length of Schedule payment date ?

You need to convert your Schedule payment date in the proper format.

-

Subhash

[patrickbachmann]

When you say universe you are consuming in Business Objects?  It sounds like a simple data type conversion problem where it's expecting a date type field and instead is getting the text or NVARCHAR type.  I've done this cast conversion before, let me check real quick...

[patrickbachmann]

Ravi I'm not sure if you are using a calculation view but if you can somehow try to cast the NVARCHAR to a date something like this;

TO_DATE(PaymentDate)

-Patrick