I was pleased to be back in Linlithgow last week for my first BI event of the year. It's nice and close to home for a quick drive over and, more importantly, had an agenda dominated by actual, real life case studies of Oracle clients from both the Public Sector and Higher Education sectors in Scotland. I wasn't presenting myself but there was a good lot of shared discussion and insight from the attendees so was able to contribute to that as well as the networking sessions. There were some interesting observations made throughout the day so thought I'd put together a quick blog on the key points.
Deploying a new Repository (RPD) is quite a simple process in OBIEE 10g. It involves moving the new RPD to the default repository location (/OracleBI/Server/Config) and adding an entry in the NQSConfig.ini file for the new repository. The newly added RPD becomes active for BI Presentation Services once you restart the BI Server.
With OBIEE 11g, the process to deploy a new RPD is slightly different. The NQSConfig.ini file which is critical for defining BI server parameters continues to hold similar parameters in OBIEE 11g, but these parameters are now controlled and managed through Enterprise Manager Fusion Middleware Control. In my blog, I will take you through the steps to deploy a new RPD using Enterprise Manager Weblogic Console.
I've recently been helping a client understand the use of funnel analysis in Oracle BI 10G and happened to compare it what is now available in the 11G release (I'm using 11.1.1.5, the second public release). There have been some impressive enhancements in the 11G release reflective of the, perhaps understated, general enhancements made to the presentation front end in 11G so thought I'd jot them down in a blog post. It's my way of saying 'thank you' to the Oracle BI developers who have made the Funnel better.
One day we’ll look back and laugh at Oracle not releasing a simple client tool install with their first release or Oracle BI 11G but, for now, us humble developers are stuck with having to do a full install if we want to just access the RPD Development Environment or, as was the case with me tonight, deploy the Oracle BI ODBC driver on a new development PC.
We’ve set up a demo environment for Oracle BI 11G for a specific client purpose. I’m quite excited as it’s really been my first chance to explore this new environment having been familiar with the old 10G variant since it was branded Siebel Analytics. I liked it a lot but did recognise it’s limitations and had been salivating over the screenshots of the 11G release for a couple of years now. I thought I’d blog about first impressions trying to focus on the ‘new’ stuff but also taking it as a natural exploration process following where my thought processes took me. This initial entry is about the process of creating a new ad-hoc analysis.
UK: +44(0)118 923 5150 
Scotland: +44(0)141 880 1000