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.
SAP Knowledge Base Article - Preview