1581328 - Passing BEx Prompt Variable using Opendocument URL in Web Intelligence report

.How to pass BEx Prompt Variable using Opendocument URL in Web Intelligence

• Product Version: Business Objects XIR3.1
• Product Patches installed: SP3
• Server Operating System: Windows Server
• CMS Database: Oracle 10G
• Reporting Database: SAP BW
• Database Middleware: SAP Netweaver
• Internet Explorer : IE7
• Application Server: Tomcat
• Java or .NET:Java
• JDK version: Java 1.6.0_14
• Authentication Type: SAP
• Clustered or Standalone(If clustered, please explain): Standalone.

Use the below sample syntax in the Opendocument URL with technical name for the BEx prompt variable obtained from the MDX Test editor

http://cacalsbot001.nal.local:8080/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=AduRXVvBlchBjzkXrFTyfPg&sType=wid&sRefresh=Y&sOutputFormat=H&lsSFiscal+Period+-+User+Input=[<Technical_Name>].[<user_input>]

For example:

http://cacalsbot001.nal.local:8080/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=AduRXVvBlchBjzkXrFTyfPg&sType=wid&sRefresh=Y&sOutputFormat=H&lsSFiscal+Period+-+User+Input=[0FISCPER].[K42010001]

BEx Prompts,Opendoc , KBA , BI-RA-WBI , Web Intelligence , How To