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!
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.
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.
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.
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.
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.
This file is used during the installation of OBIEE 11g to define the ports. This post shows a sample of one.
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.
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:
- Recommended Installation Scenarios for Oracle Business Intelligence
- Managing Ports
- Using the Cluster Manager
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.
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!!
Robin Moffat covers:
- Anti-patterns in performance optimisation
- Generally good design principles to observe in OBIEE
- Optimising OBIEE further
- BI Server Caching
- Use fast disk for cache and/or temporary files
- Web Tier for static content caching
- Scale out / Scale up
- Optimising the database
- Oracle’s tuning document (which can be found here)
Saandeep Raghunath shared Just Analytics blog post “Geospatial Analytics in OBIEE – Part I – The Basics”
Anand Ekbote posted OBIEE Smartview Integration
Join the LinkedIn group for more Oracle Business Intelligence discussions.
Oracle Blogs posted Fusion Middleware Forms & Reports 11gR2 Patchset 2 (220.127.116.11.0) and OBIEE 11.1.1: Load Testing Oracle Business Intelligence Enterprise Edition (OBIEE) 11g Using Oracle Load Testing (OLT) 12.x and a link to ADF Architecture TV in 2014 with 2 bonus episodes, 47 and 48.
Follow Addidici on twitter for daily OBIEE news and updates.