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.