Tuesday, November 22, 2011

BI Publisher 11g - Webservices

If you are looking BI Publisher Webservices then you can simply find them under the following location:
You will get a list for these services :
Some of them are new in this release and therefore may not be compatible with Webservices for BIP10g.
In future posts I will write on some of these new webservices.
That's it for now. Got to go back to my daily duties for my current customer :)

Tuesday, April 26, 2011

Enabling LOG messages in BI Publisher 10g

Enabling BI Publisher 10g to DEBUG mode is pretty simple. I will show you how to do it in OC4J.

1. Stop OC4J
2. Make a backup of this file:
3. Modify the file xmlp-server-config.xml and set this value:
   <property name="DEBUG_LEVEL" value="debug"/>
4. Save the file
5. Restart OC4J

It should be now in Debug mode

Tuesday, March 29, 2011

Upgrade BI Publisher to 11g

Now that more and more customers are starting to use the newest BIEE 11g release a commom question asked is : How do I upgrade my BI Publisher 10g to 11g?.

Sometime ago we made a presentation on BI Publisher 11g and touched this matter. Here we revisit this interesting topic again and present you a summary of the upgrade process.

The upgrade of BI Publisher 10g to 11g is essentially a three step process:

1. Install BIEE 11g
2. Run Upgrade Assistant (to upgrade BI Publisher 10g Repository)

3. Run Upgrade Assistant (to upgrade BI Publisher 10g Scheduler metadata)

In Windows to start the Upgrade Assistant using the GUI change directory to the ORACLE_HOME/Oracle_BI1/bin directory of the Oracle Fusion Middleware installation: ua.bat

Assumptions: Certain considerations should be taken during the process as for example.

  1. BI Publisher 10g Repository is file based. If it is XMLDB based then move the directory to a file system before migration. As of release 11.1.0 there is no support for XMLDB repository type (Future will use MDS as repository).

  2. The upgrade assistant assumes the BI Publisher 10g repository is accessible in a shared drive.

  3. Before upgrade, make sure BI Publisher 11g is set to repository File Type (by default it is BIEE Catalog) because the UA only upgrades to file type repository.

  4. After upgrade, BIEE 11g and BI Publisher 11g integration works if security is "Fusion Middleware" and BI Publisher Repository is BIEE Catalog. So use the utility in BI Publisher 11g Administration --> Server Configuration --> Select Catalog Type: BIEE --> set the BIP Repository path -->Upload to BI PS Catalog
For more further detailed process, follow my friend's site:



1. Oracle BI Publisher 11g Documentation

Wednesday, March 9, 2011

Oracle BI Publisher 10g - New patch released (March 2011)

A quick note to just let know our followers that there is a new BI Publisher 10g patch released just today through the Oracle Support site: http://metalink.oracle.com


We will look into it and see if there are useful things which were corrected.

Stay tuned BI Publisher is coming soon!

Friday, February 25, 2011

Oracle Data Miner 11gR2 available for download

It has been awhile since my last posting and decided to catch up by posting a couple of things I have been working on lately.

One of them is a topic which I am passionate about: Data Mining. A few weeks ago while at Boston I had the opportunity to visit an old friend of mine Charlie Berger (Senior Director PM Oracle Data Mining) in the Oracle office at Burlington.

 We had a short but nice conversation on the new release of ODM 11gR2. At the time of our conversation Oracle was getting ready to release it in OTN and it just made it last Tuesday Feb 22.
ODM 11gR2 is now part of SQLDeveloper ( currently in SQLDevelopers Early Adopters 3)

 and as such you need to download SQLDevelopers EA3 from this link:
Well the new good feature is that it now provides a graphical workflow to easily define the data flow and processes until final results for analysis are obtained. Here a screenshot of my first exercise with this tool.

It is really fantastic. This new GUI has long been waited for the Oracle Data Mining community.
We will post soon how Oracle Data Miner can be integrated with OBIEE to produce actionable analytical results. Stay tuned!

BI Publisher 10g: Switching from BI Server to XDO security mode

The BIEE10g default installation provides BIEE services as well BI Publisher services. Also, by default from this installation BI Publisher 10g is configured to authenticate all users through BI Server: “BI_SERVER”. But there is a way to switch BI Publisher from this pre-configured authentication mode to its own: “XDO”.
First, make sure all BIEE and BI Publisher (OC4J) services are down, next just (first make a back up of this file) modify the file xmlp-server-config.xml located at: C:\OracleBI\xmlp\XMLP\Admin\Configuration
and modify the entry from   <property name="SECURITY_MODEL" value="BI_SERVER"/>  to   <property name="SECURITY_MODEL" value="XDO"/>

Now, all you need to do is launch “Start OC4J” icon from your “Business Intelligence” programs group and immediately after BI Publisher will be running in stand alone mode. There is no need to have BI Server services running at all.

The predefined user for this setting is Administrator and password is Administrator. Now all users are controled and authenticated through BI Publisher interface.