How to open BIP report inside Siebel Applet

0: Overview

Sometime as per the requirements you need to display 3rd party web page inside Siebel to achieve that there are two simple steps which are described here in details.

1: Prepare BIP Report URL

In this post requirement is to show Oracle BI Publisher report inside Siebel Applet with report filters.

1.1. First Oracle BIP Developer will create report and share report link and important thing here is to ask BIP Developer to share the link without BIP Header page shown in below image.

And link will look like this (Removed default filter details as they will auto set when report will open):
http://BIPServer:PORT/xmlpserver/FOLDER/REPORT_NAME.xdo?_xpf=&_xpt=0&_xdo=%FOLDER_PATH%2FREPORT_NAME.xdo&_xmode=2&_xt=REPORT_TITLE&_xf=pdf&_xana=view&_xautorun=false

1.2. Now simply divide this URL into input parameters so that we can configure this URL into Siebel Application. "&" is the key from where you can determine the parameter name and their values.

http://BIPServer:PORT/xmlpserver/FOLDER/REPORT_NAME.xdo

Parameter Name	Parameter Value	Comments
_xpf		No need to add this
_xpt	0
_xdo	%FOLDER_PATH%2FREPORT_NAME.xdo	No need to add this
_xmode	2
_xt	REPORT_TITLE	No need to add this
_xf	pdf
_xana	view
_xautorun	false

1.3. Add below parameters. Credentials are required for auto login the but the other are optional and can be removed as per the Environment setup.

Parameter Name	Parameter Value
Id	username
passwd	password
IFrame	iFrameStyle="Height:500px; Width:100%; allowfullscreen:false !important"
FullWindow	False

2: Setting up Symbolic URL in Siebel

Now we need to configure there in Siebel.

2.1. Login Application.
2.2. Open sitemap and type "symbolic" in filter field.

2.3. On Symbolic URL Administration screen create New Record and enter data per below:
Add unique name.
2.4. From the previous step (1.2) add URL.
2.5. In "Fixup Name" field set value as "Default".
2.6. In "SSO Disposition" field select "IFrame" from the drop down.

2.7. Now go to "Symbolic URL Arguments" applet and from the menu click on New Record.
Add the parameters gathered in previous step as per below screen shot.

3: Setting up Siebel Side objects

Now in this part we will configure the Applet and Business Component to open this symbolic URL.

3.1: Business Component:

You can use any existing Business Component or create a new one based on any table as we only need a calculated field in which we will define the Symbolic URL.

3.1.1. Create a new Calculated field in Business Component and in write the Symbolic URL name created in previous activity in Calculated Value.

3.2: Applet

You can create a new applet with Base Applet template or use the cloned of any existing applet which is showing the BIP Report.

3.2.1. If you are going to create a new applet you need to select "Analytics Applet" web template.

3.2.2. Create a new list column and add the Calculated Field name in Field and in "Field Retrieval Type" drop down select value "Symbolic URL".

3.2.3. Right click on applet name and from the select "Edit Web Layout".
3.2.4. From the "Controls/Columns" window drag and drop the calculated field on layout.

4: Final Output

Now complete the remaining configuration and compile the objects on SRF and test.