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

SAP Knowledge Base Article - Public

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

Symptom

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

Environment

  • 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.

Resolution

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]

Keywords

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

Product

SAP BusinessObjects Xcelsius Enterprise 2008