Wednesday Aug 07, 2013

Siebel BIP Tuning

Another brain dump from John, the product manager for the Siebel-BIP integration.

These docs focus on the out of the box integration. Where Siebel holds the reins and just sends the BI Publiser server publishing requests. For this you use Integration Objects to generate the data. This support doc contains a white paper on performance testing of the IOs and provides some standard tests that you can compare your system to.

Siebel CRM BI Publisher Integration Performance[Article ID 1466709.1]

I have pulled the white paper out of support to save you some time (cos Im kind like that.) Of course the latest and greatest will be on

The following support doc covers the tuning of said objects to handle larger data sets.

Improving the performance of Siebel BI Publisher Report Generation (Doc ID 1392449.1)

I have linked a converted PDF of the doc as of today, access com and search via the Doc Id for the latest and greatest.

For completeness of the post, heres a link to post on the Siebel-BIP Business Service Integration.

Wednesday Jul 03, 2013

Siebel BIP Integration

This post is more of a bookmark for me so that I stop bugging the brown stuff out of the John the Siebel-BIP product manager. I have had multiple customers over the past two weeks asking for help around the integration. What's its capable of? How can I allow my users to click a button to run a BIP report? How can I kick off a report from a Siebel workflow?

Start right here - this is a great white paper explaining whats now available with the integration using, the Siebel Report Business Service. Once you have consumed that from start to finish.
Get on over to Oracle support and look for the following note that has code samples and lots of other good stuff!

Siebel BI Publisher Reports Business Service ( [ID 1425724.1]

The Reports Business Service enables BI Publisher reports to be executed from the Siebel application via a Workflow Process, or through scripting. The report is generated in the background by connecting to the BI Publisher server. The report output is stored in the Siebel File System and accessed from the My BI Publisher Reports view. Alternatively using appropriate methods, the report can be attached to an entity or sent to a particular delivery channel.

Wednesday Apr 18, 2012

BI Publisher at Collaborate 2012

Wow - There are over 30 fantastic presentations that cover BI Publisher at Collaborate this year.  Interest and use of BI Publisher continues to spread across the growing family of Oracle Applications and products.

See Focus On BI Publisher at Collaborate 2012
for a day by day view of all the sessions.

Come and visit us at the Oracle Business Intelligence Foundation demo station (kiosk 14) to chat and see BI Publisher 11g live.

If you want to try BI Publisher 11g, show up for the Hands On Lab - early !
Last year we had over 200 people show up for 40 seats.
We are running 2 sessions this year to accommodate more people but still expect this to be a sold out event.

Here is a breakdown of BI Publisher sessions organized by Application area of interest.
Follow the link or see Focus On BI Publisher for time, location and speaker info.

General Interest for All

Building Reports and Data Models in Oracle Business Intelligence Publisher Hands On Lab -- 2nd session
BI Publisher 11g: Only Good News
Oracle Analytics & Performance Management Strategy and Road Map
Oracle BI Publisher: The Reporting Platform for Oracle Applications
OBIEE 11g - Using the New Features of Answers and BI Publisher
Oracle BI Publisher: Anatomy of an RTF Template
Migrating Discoverer to Oracle BIEE: Take Your Reporting to the Next Level
The Right Information, The Right Tool, the Right Time
Project and HR Analytics + OBIEE 11g + Exadata = Operational Efficiency

E-Business Suite

Jump Start Your Custom Reports with E-Business Suite R12's Seeded BI Publisher Templates
Upgrading to R12 Payments Funds Disbursement: An iRobot Case Study
Introduction to BI Publisher in Oracle EBS R12- Getting Started
Look Before You Leap! Issues to Consider When Migrating Discoverer Reports to BI Publisher 11g
Making Sense of Parent-Child Relationships – The Oracle Kind, Not the Human Kind
Adding Data Elements to BI Publisher Documents
Printing PDF Documents in Self Service Made Easy By Integrating BI Publisher With OAF
Oracle Payments in Release 12 - Take it to the Bank!

JD Edwards Enterprise One

I Bleed Red, Oracle Red Stack that Is...
Using Oracle BI Publisher for JD Edwards Operational and Financial Reporting
JD Edwards: Let's Get Going with BI Publisher
JD Edwards EnterpriseOne XE to 9.0 in Less Than 100 Days
Choosing the Right Solution to Transform Data to Actionable Information - Oracle EPM, BI and Reporting
Using Oracle BI Publisher to E-mail Customer ACH Payment Confirmations


Transitioning From InfoMaker to BI Publisher
Introduction to Primavera Contract Management, Business Intelligence Publisher Edition
Understanding the Px Schema and Writing Reports for Primavera P6 Using Oracle BI Publisher
Oracle Primavera and BPM - The Power of Integration
Reporting from Contract Management 14.0 Using BI Publisher 11g
Primavera P6 Release 8 - Web Innovation & So Much More

JD Edwards Enterprise World

Import/Export – Electronic Document Delivery – BI Publisher Gateway
BI Publisher and World
Delivering Value through EDD and BI Publisher in World A9.2


XML Publisher - Become an Expert in an Hour


A Case Study of a Migration to BI Publisher From Actuate at a Leading Healthcare Company

Hope to see you in Vega$,
Mike, Leslie and Nikos

All things Siebel

John from the Siebel product management team just shared a neat list of resources for all things Siebel-BIP. Too good to park in my email folders, here it is for everyone.

OpenWorld presentations:

2010 - Siebel Reporting: Oracle Business Intelligence Publisher Customer Experiences
2011 - Building More Insightful Reports with Siebel CRM Reporting Solutions

BI Publisher forum (public)

Oracle BI Publisher

Oracle BI Publisher Best Practices

The following are notes available on Oracle Support

  • Siebel CRM Reports - Statement of Direction / Planned Features (Doc ID 1226744.1)
  • Siebel 8 BI Publisher Reports - List of Siebel Reports (Doc ID 876284.1)
  • Links to Documentation for Using Siebel Reports (Doc ID 1172844.1)
  • Siebel BI Publisher 8 Integration Concepts (Doc ID 811104.1)
  • Siebel Reports integration with Oracle BI Publisher (BIP) Information Center (Doc ID 1147910.1)
  • Siebel Reporting Upgrading BI Publisher Server (Doc ID 1262585.1)Siebel BI Publisher 8 Reports Business Service (Doc ID 823360.1)
  • Siebel BI Publisher Reports Business Service ( (Doc ID 1425724.1)
  • Using Oracle BI Publisher for Siebel Proposals (Doc ID 1362460.1)
  • Siebel Reporting 8.x Migration FAQ (Doc ID 764097.1)
  • Supporting Documentation for Siebel Reports by Product Version (Doc ID 1172844.1)
  • Improving the performance of Siebel BI Publisher Report Generation (Doc ID 1392449.1)

Siebel Bookshelf, Siebel Reports Guide 8.1.x

Friday Dec 23, 2011

Siebel Tips and Tricks

Good tidings for the season to all of you. Its been erratic I know but we have stumbled along this year ...

I have been working with Eric, a Siebel sales consultant whiz on the BIP integration. He shared some really useful tips with a Siebel-BIP customer yesterday which I thought were well worth sharing.

Date Formatting

Firstly, some help with formatting dates when you are using a Siebel integration objects to generate the data. Siebel IOs do not generate the XSD date format that BIP needs to let you format dates to your hearts content.  Attached are a couple files that provide some examples on how to manipulate dates to get the desired formats. Some are easy to get working and some need a little effort.

MSWord Plugin Testing

Siebel development have shipped  some Siebel-BIP functions that are deployed to the server. However, to be able to test them locally on your desktop you need to get the java libraries into your classpath prior to starting MSWord. Here is the code Eric uses for starting Word with the Siebel classes in a batch file.  It assumes that the jar files are available locally on the client machine at C:\811DQSSIA\Client\CLASSES.  This will make the classes used by some Siebel report templates available to test directly in Word.  I have two versions, one for Word 2003 and one for Word 2007.

Word 2003:

echo %1

set _JAVA_OPTIONS=-Xbootclasspath/a:C:\811DQSSIA\Client\CLASSES\SiebelXMLP.jar;C:\811DQSSIA\Client\CLASSES\XMLP.jar;C:\811DQSSIA\Client\CLASSES\Siebel.jar;C:\811DQSSIA\Client\CLASSES\XSLFunctions.jar;C:\811DQSSIA\Client\CLASSES\SiebelCustomXMLP.jar;C:\811DQSSIA\Client\CLASSES\SiebelCustomXMLP_SIA.jar;

"C:\Program Files\Microsoft Office\Office12\Winword.exe" %1

Word 2007:

echo %1

set _JAVA_OPTIONS=-Xbootclasspath/a:C:\811DQSSIA\Client\CLASSES\SiebelXMLP.jar;C:\811DQSSIA\Client\CLASSES\XMLP.jar;C:\811DQSSIA\Client\CLASSES\Siebel.jar;C:\811DQSSIA\Client\CLASSES\XSLFunctions.jar;C:\811DQSSIA\Client\CLASSES\SiebelCustomXMLP.jar;C:\811DQSSIA\Client\CLASSES\SiebelCustomXMLP_SIA.jar;

"C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Microsoft Office\Microsoft Office Word 2007.lnk" %1

 Happy Holidays!

Monday Nov 16, 2009

More Siebel - BIP Integration Goodness

[Read More]

Follow bipublisher on Twitter Find Us on Facebook BI Publisher Youtube ChannelDiscussion Forum

Join our BI Publisher community to get the most and keep updated with the latest news, How-to, Solutions! Share your feedback and let us hear your voice @bipublisher on Twitter, on our official Facebook page, and Youtube!


« July 2016