SAP Knowledge Base Article - Preview

3624190 - ADD_MONTHS or ADD_YEARS functions does not work and an error occurs when deploying a Fact View with Input Parameter without default value in SAP Datasphere

Symptom

"Invalid DATE, TIME or TIMESTAMP value: invalid calculated date value at 'add_years' function (at pos 1386), Code: 303, SQL State: 22007." error occurs when deploying a Fact view that contains an Input Parameter without a default value for a Date type dimension.


Read more...

Environment

SAP Datasphere

Product

SAP Datasphere 1.0

Keywords

add_month, invalid date value, SQL State 22007, deploy view, input parameter, default value, preview error, hana cloud, validation issue, fact view. , KBA , DS-MD-VIW , Views , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.