RittmanMead BI Forum 2011 – Masterclass (Part I)

Arrived this morning in Brighton for my second RittmanMead BI Forum 2011. The forum started of with a Masterclass. Because of the flight-schedule between Amsterdam and London – Gatwick, I wasn’t able to make it on time. In the end I received sufficient information to call it a valuable Masterclass. The hosts of this Masterclass were the master himself; Mark Rittman and Tony Heljula. These guys had the privilege to ‘compete’ with last years Masterclass by Kurt Wolff. I must say; They did a pretty good job. The Masterclass consist of 4 different subjects, equally (although Mark tried to claim Tony’s time) divided by the two hosts:

  • OBIEE11g – Architecture, Components & Internals
  • OBIEE11g – Spatial Integration
  • OBIEE11g – Server & RPD New Features
  • OBIEE11g – SOA Integration

Mark started off with the OBIEE11g – Architecture, Components & Internals. Unfortunately I had to miss the first part. Still I have been able to take some notes. With the new Oracle BI 11g release, starting form we are presented with an whole new architecture. The best way to  make sense of Oracle BI 11g is to get comfortable with;

  • Instances
  • Domains
  • Using the WebLogic Scripting Tool (WLST)

I joined the Masterclass when Mark arrived at the WLST part. Thes WLST-scripts are calling MBeans. There seem to be more of these MBeans in the background than presented via the GUI. By using scripting (Jython) you are able to manipulate meta-data in the repository and objects in the catalog. Andreas Nobbmann will cover part of this subject in his presentation on Thursday.

Anthony continued with his presentation about the improvements of the Spatial Integration in OBIEE11g. One of my ex-colleagues (Maarten Jan Kampen)  did a presentation of  Spatial Intelligence in OBIEE10g. The integration in OBIEE10g was full of additional Javascripting. In OBIEE11g this has significantly improved. For the sake of his marriage, Tony didn’t gave his holiday a different purpose, so he left his presentation based on So maybe there are some more improvements in

If you have your spatial metadata in order, the user should be capable to make his own spatial reports. Just by using the Map as an additional representation of the data, next to eg. the Pivot View. In OBI11g the spatial architecture is as follows;

  • Database (Locator could be enough, for extra manipulations on the data you will need an additional Spatial-license)
  • Oracle Mapviewer
  • Oracle Mapbuilder (or better Map Configurator)

Tony showed us several possibilities of building basemaps using the sample files from Navteq on OTN. You could also use Google Maps or Bing Maps. Using the Navtew files you could also create your own custom basemaps. Next to that Tony showed us a lot of possibilities of Spatial Integration in OBIEE11g, like

  • Locator Functions
  • Spatial Functions
  • Drilling (Master-Detail)
  • Navigating
  • Evaluate –> Spatial Functions

Already a lot to talk about and we were only half way!!

Installing Oracle BI 11g R1 – Windows Server 2008 R2 64bit

Recently I did an installation on a Windows Server 2008 R2 64bit. Reading through the documentation made me realize that it’s not possible to do a ‘Enterprise Install’. Check the following part in the manual:

1.4.3 Software Only Install

The Software Only Install type installs the Oracle Business Intelligence software binary files in an Oracle home for later configuration as part of a Fusion Middleware deployment. This install type is required to install Oracle Business Intelligence on an AIX operating system or with a 64-bit JVM, such as on a supported 64-bit operating system.”

Th following could be a guideline to install Oracle BI 11g on Windows Server 2008 R2 64bit:

Install RCU –> rcuHome\BIN\rcu.bat
Install JDK 64bit
Install Weblogic generic –> via the Command Line java -jar wls1033_generic.jar
Install Oracle BI11g –> ‘Software Only’
Run config.bat to configure Oracle BI11g –>C:\Oracle\Middleware\Oracle_BI1\bin\config.bat

Of course you need to check the manual for additional info. Next to that you have to perform a ‘Software Only’ install on 32bit machine to be able to use your client tools.

Check My Oracle Support for more details.

Deploy Custom content folder location in WLS

In an earlier post I ended up with problems with custom folders in Oracle BI 11g R1. It turned out that I had to make some additional steps to deploy a custom folder in the Weblogic Server. Thanks to the documentation of the SampleApp I was able to make this work.

I have been working on a demo. Therefore I have created an index site with links to custom images and custom documentation. When I migrated this demo from 10g to 11g, I had to copy the images and documents manually. This seemed not to be enough. I ended up with some red crosses.

You have to take the following steps to deploy custom folders to the Weblogic Server.

Login to the Weblogic Server
Navigate to te Deployments
Click on ‘Lock & Edit’ in the left pane to enable the ‘Install’-button


click ‘Install’

Navigate to ‘<MIDDLEWARE_HOME>\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1’

select ‘analyticsRes’
click ‘Next’

select ‘Install this deployment as an application’ (default)
click ‘Next’

Select ‘Deployment targets’
Choose ‘bi_server1’
click ‘Next’

Under ‘Source accessibility’

Choose ‘I will make the deployment accessible from the following location’
click ‘Finish’

Check the ‘Deployments’ to see whether the ‘analyticsRes’ is available.

click on ‘Activate Changes’

start the deployment; ‘analyticsRes’

Now I am able to add the required images and documents in custom folders just by referencing to the  ‘analyticsRes’- folder, eg.; ‘/analyticsRes/Documents/’