SAP Knowledge Base Article - Preview

2479695 - Error occurs in Information Design Tool when paring SQL Expression including string-to-date conversion on @Prompt function without default value on Amazon Redshift datasource

Symptom

  • Error occurs in Information Design Tool when paring SQL Expression including string-to-date conversion on @Prompt function without default value on Amazon Redshift datasource
  • Error detail: [Simba](500310) Invalid operation: Data value 'Value1' has invalid format


Read more...

Environment

  • SAP BusinessObjects Business Intelligence Platform 4.x (BI 4.0 / BI 4.1 / BI 4.2)
  • Information Design Tool (IDT)
  • Amazon Redshift

Product

SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.1 ; SAP BusinessObjects Business Intelligence platform 4.2

Keywords

BI, BO, BI4, BO4, universe, IDT, UDT, parse, validate, @Prompt, prompt, filter, to_date, date, default, default value, 7th, convert, conversion, value1, string, BiSL , KBA , BI-BIP-IDT , Information design tool , BI-BIP-SL , Semantic Layer , BI-BIP-UDT , Universe Design Tool , How To

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.