SAP Knowledge Base Article - Preview

1878930 - Change of behaviour for Universe defined @Prompt with 'N' (numeric) type for non-numeric responses in SAP BI 4.x


  • Invalid SQL is generated from use of @Prompt
  • SQL generated contains a '0' to the response of an @Prompt where the non-numeric response was provided.
  • Need to understand any issues associated with upgrading a Universe (.UNV) to BI4 that contains an @Prompt with 'N' (numeric type) for non-numeric responses.
  • Need to understand how to use @Prompt with 'N' (numeric type) for non numeric responses.



  • SAP BusinessObjects Business Intelligence Platform 4.x
  • Universes .UNV created by Universe Design Tool
  • Universes .UNX created by Information Design Tool


SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.0, feature pack 3 ; SAP BusinessObjects Business Intelligence platform 4.1


ADAPT01628331 4.0 4.1 , KBA , BI-BIP-SL , Semantic Layer , BI-BIP-UDT , Universe Design Tool , 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.