Multiple OBIEE 11 on the same server.

Whilst Addidici are not allowed to talk about their current (Military) installation activity, I do like to share what I have been reading each week.
A few years back I installed 10 OBIEE 10g environments on a box (10 env on 8 boxes actually), which was very simple to do. With 11g the challenge was greater, but it still can be done. No need for multiple VM’s.
OBIEE News is out!

OBIEE news is out. Edition of 6th January. Blogs from John Goodwin, Oracle BI By Bakboord and Corporate Technologies.

Blogs of the week

1. Creating ReForms in Oracle APEX

In Vishal’s blog, he defines a ReForm as “an amalgum of Reports and Forms that has the DNA of both.” The discussion in this blog not only presents a ReForm but also demonstrates the enormous benefits of using JQuery in APEX report development. In this post, he discusses the process needed to create a ReForm (Report cum Tabular Form) and also see the process of controlling the data cells for superior reporting.

2. OBIEE 11g Configuration for Interaction for Views

Pravin says in this blog post: “OBIEE 11g offers number options on the way that right-click interactions are handled in views. To configure various options that change the way that right-click interactions are handled in views for an analysis at runtime. The elements in the instanceconfig.xml file specify the default settings for a new or upgraded analysis. One can edit the properties of an analysis in Presentation Services to modify how the analysis handles right-click interactions in views.” Read the whole blog for more details.

3. How-to: Upgrade Usage Tracking OBIEE 10g to OBIEE 11.1.1.x

John Cook discusses the five steps to upgrade usage tracking OBIEE 10g to OBIEE 11.1.1.x as:

1. Make changes to existing OBIEE 10g Usage Tracking RPD

2. Modify Physical Data Model

3. Enable Usage Tracking in Enterprise Manager

4. Deploy Usage Tracking Tables to Your 11g Database

5. Confirm Usage Tracking is Enabled

Read the post and comments here.

4. Creating a Run Button on a Dashboard in OBIEE 11g

Here, M & S Consulting talk us through the steps to create a run button on the dashboard. In the first part of the exercise, they talk about setting up the analysis and in the second part, set up the prompt for it.

5. Speed Mobile

In this post, Mark Rittman writes about: “Creating an Initial Business Intelligence Mobile App” and “Publishing Your App to the Mobile App Store.” He also links to useful documentation including User’s Guide for Oracle Business Intelligence Mobile App Designer 11g Release 1 (11.1.1), also watch videos on how to create a mobile BI app and use key designer features, explore tutorials, review collateral, and interact with social media.

6. Fusion Middleware – OPMN.xml configuration file

OPMN.xml is the main configuration file for OPMN that is used to launch each system component (such as Oracle Business Intelligence). This post details the various sections and gives an example.

7.OBIEE 11G – staticports.ini

This file is used during the installation of OBIEE 11g to define the ports. This post shows a sample of one.

8. Default OBIEE 11G Ports

Here Sunil says: “Recently came across a situation in which someone, due to some security issue, wanted to bypass OBIEE’s default ports. After looking at multiple places, I could put all information together. I thought it would be a great share.” View the post here.

9. Change Server Port in OBIEE 11g

This ClearPeaks White Paper comprises of the following sections:

Stop the WebLogic Managed Server
Change the port number
Start the WebLogic Managed Server
Test that everything is running properly

10. The following Oracle documents are also useful:

11. Oracle BI EE 11g – Managing Host Name Changes

This post by Venkatakrishnan J states that the components at a high level in 11g, which require changes whenever the host name changes are:

1. Admin Server
2. Managed Server
3. Node Manager
4. RCU Schemas Connections
5. System Components
6. Hardcoded Host name entries in Repository, JDBC Connections etc
7. RCU Database Listener

This blog post gives instructions and visuals as to how to carry this out.

12. Error flushing write connection to OPMN

This blog post by “Not just a DBA !!!” talks through the problem – for some reason opmn ports were conflicting for the two domains – and then gives the solution!!

13. Performance and OBIEE – part VII – Optimising OBIEE performance (“Tuning”)

Robin Moffat covers: