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.
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 |
|
|
|
_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.
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.1. Create a new Calculated field in Business Component and in write the Symbolic URL name created in previous activity in Calculated Value.
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.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.
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.
