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 create 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_member183330 · Accepted solution]

Hi

In object properties make data type as date and try.

Regards,

Sampath

[Former Member · Accepted solution]

Hi Sampath,

We did the same but still problem persists

[Former Member · Accepted solution]

BO cannot just read a varchar column and implicitly convert to date because you set its data type to date. You will need to convert the varchar string to a date using the appropriate syntax for ToDate in a business layer calculation based on your starting date format.

[Former Member]

Hi Ravi Shankar

The data type of this object should be DATE in HANA itself. Please change it to DATE datatype in HANA and try to check. This should work.

[former_member195292]

Try with To_char("Obj",'MM/DD/YYYY')

[Former Member]

Hi Ravi,

What is back-end system??? SAP BI HANA or what ???

Thanks & Regards,

Srinu.Rapolu

[Former Member]

Hi Srinu,

Its SAP BW on HANA only.