SAP Knowledge Base Article - Preview

2064868 - Default value not displaying in the Prompts section when scheduling a Web Intelligence Report

Symptom

  • A Web Intelligence document has been created using the @Prompt function
  • The report utilizes customized SQL that uses the @prompt functionality in the WHERE clause
  • Default values have been defined within the @prompt.  Example below:

WHERE
  dbo.Customer.Country  IN  @PROMPT('Country:','A',,Multi,Free,Not_Persistent,{'Argentina','Aruba'},User:0)

  • When scheduling the report, the default values defined above are not displayed in the Prompt section of the schedule window
  • Modifying the prompt does display the values as defaults as expected

 


Read more...

Environment

  • SAP BusinessObjects Business Intelligence Platform 4.x
  • Web Intelligence Document

 

Product

SAP BusinessObjects Business Intelligence platform 4.1

Keywords

schedule scheduling prompt lov list of values default selected used last report document webi webintelligence bilaunchpad , KBA , BI-RA-WBI , Web Intelligence , BI-BIP-ADM , BI Servers, security, Crystal Reports in Launchpad , 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.