Rittman Mead Blog - Oracle BI Suite EE

Essbase Integration with OBIEE 10.1.3.3.1

A month or so ago I posted a series of articles [http://www.rittmanmead.com/category/hyperion/] on getting up and running with Hyperion Essbase, and mentioned at the time that it soon would be possible to plug Essbase directly in to Oracle BI Suite Enterprise Edition. In this article,

Technical

BI information security

These days there are a wealth of restrictions or regulations (SOX, UK Data Protection Act to name but two) on data access and coupled with the simple commercial need to hide sensitive information that means unfettered access to data warehouse data is a thing of the past. Fortunately products such

Technical

OBIEE 10.1.3.3.1 Now Available On OTN

Venkat [http://oraclebizint.wordpress.com/2007/10/22/oracle-bi-ee-101331-new-release-new-features/] and Abhinav [http://oraclebi.blogspot.com/2007/10/101331-is-now-available-on-otn.html] posted the news earlier today; Oracle BI Suite Enterprise Edition 10.1.3.3.1 is now on general release [http://www.oracle.com/technology/software/products/ias/htdocs/101320bi.html]

Technical

Five Oracle BI Trends for the Future

I gave a BI keynote (pdf copy of slides [http://www.rittmanmead.com/files/BIWA%20Keynote.pdf]) at a couple of events last week (the Business Intelligence, Warehousing and Analytics Summit in Reston, VA and the OUG Scotland Conference & Exhibition, Glasgow), and as it's been picked up

Technical

OBIEE Dimensional Data Modeling Redux

Several months ago I wrote a blog post [https://www.rittmanmead.com/blog/2007/06/19/obiee-data-modeling-tips-1-integrating-1-1-and-1-many-source-tables/] on pulling together an Oracle BI Suite Enterprise Edition business model from a normalized data source. At the time I was working through in my own mind how best to join different data

Technical

Managing multiple Presentation Services on the same Unix box

As I had mentioned, I wanted to write up a bit on how to go about setting up multiple Oracle BI presentation services, each configured to access a different repository file (RPD) running on the BI Server. The thing is that you can easily set up the BI server so

Technical

Integrating BI Publisher and Discoverer

The other day I wrote about the first of the integration features between Oracle BI Suite Standard Edition and Enterprise Edition in my article "Integrating Oracle Answers and Oracle Portal" [https://www.rittmanmead.com/blog/2007/09/07/integrating-oracle-bi-answers-and-oracle-portal/]. Today, I'm going to take a look

Technical

Open World, BIWA, UKOUG and Oracle Mag

Things have been a bit quiet on the blog recently, as Jon and I have taken a bit of leave and I've been working on a couple of articles for Oracle. As well as the articles, Jon and I are also due to present at a number of

Technical

OBIEE & SOA, and a Parrot in the Fireplace

This week Jon and I took a few days out from client work, and went down to Oracle's offices in Bristol to work on some OBIEE and SOA prototypes. Regular readers of this blog will know that I'm particularly excited about the convergence of BI and

Technical

Oracle Data Integrator Article on OTN

My article on real-time data integration with Oracle Data Integrator [http://www.oracle.com/technology/pub/articles/rittman-odi.html] has just been published on OTN. This was quite an interesting article to write; apart from establishing how ODI related to OWB, I also put an example together that takes data,

Technical

Flying Back from Johannesburg, and Thoughts on BI and the SOA Suite Demo

I’m currently sitting on the flight back from Johannesburg to London Heathrow, after running an Oracle BI Enterprise Edition workshop on behalf of Oracle South Africa. On the way back from the conference centre, I did smile to myself as I saw a road sign for Pretoria out of

Technical

Odds and Ends

Just a quick catch up post, as I sit here watching Spurs draw 1-1 with Blackburn. Brian Duff posted a link earlier this week [http://blogs.oracle.com/duffblog/2007/05/07#a413] to the new Oracle Blogs Semantic Web [http://otnsemanticweb.oracle.com/blogs.jsp] site, that aggregates a

Technical

Installing OBIEE 10.1.3.2.1 on Ubuntu Part II

Ok, so I tried running the OBIEE installer again, this time choosing only BI Server option. When I read through the install.log I noticed that it was complaining about that the UnixChk.sh didn't exist. The reason for that was simple, I had renamed it when I

Technical

Installing OBIEE 10.1.3.2.1 on Ubuntu 7.04 … not so fast

Well, this was a productive 2 hour stint. I just managed to hack my way past the OBIEE installer to get ahead to the actual installation. After downloading the cpio (I chose the RedHat file, since I knew that I could at least install the Oracle Linux because I have

Technical

Thoughts on OBI EE for Discoverer Users

I mentioned the other days that one of the papers I’m delivering for ODTUG Kaleidoscope 2007 is on Oracle Business Intelligence Enterprise Edition (OBI EE) for Discoverer users. The aim of this paper is to introduce OBI EE to those Oracle customers who currently use Discoverer, perhaps have requirements

Technical

Time Series in OBIEE compared with Discoverer

I just finished reading through Mark Rittman's post titled OBI EE, Time Dimensions and Time-Series Calculations [https://www.rittmanmead.com/blog/2007/04/30/obi-ee-time-dimensions-and-time-series-calculations/] Here, Mark goes on a wee journey to look at how time-series queries in OBIEE (as the title suggests :)) can be set up.

Technical

Towards “Business Intelligence 2.0″, and Thoughts on the Next Seminar

Last week I posted an article on the forthcoming round of BI Masterclasses [https://www.rittmanmead.com/blog/2007/03/23/bi-masterclasses-200708-your-feedback-required/] that I'll be running through Oracle University, and I suggested an agenda mainly focused around the new BI Enterprise Edition family of products. I invited feedback

Technical

Looking Closer at BI Suite EE 10gR3

I've been spending all my spare time recently on the book I'm working on, and so deliberately stayed away from the new Oracle BI Suite Enterprise Edition so that I didn't get distracted. I've got a couple of days free now, and

Technical

Putting Together a BI Suite Sample Dataset, Part 1

I've more or less finishing the opening chapter of the book I'm working on, and I've reached the part now where I need a set of sample data for the examples that are going to follow. Without giving too much away (the contracts are

Technical

Oracle BI & SOA - Hype or Here Now?

I mentioned in my posting yesterday [http://www.rittman.net/2006/10/29/back-home-and-reflections-on-open-world/] that, whilst at Open World last week, I was struck by the many conversations I had with people around Oracle business intelligence and Service Orientated Architectures (generally shortened to SOA and, within Oracle, pronounced "So-ah&

Technical

Back Home, and Reflections on Open World

Well I'm back in the UK now, and I've had yesterday and this morning to myself before the family gets back from Ireland. We're all back at work tomorrow (well school and nursery for the kids, we haven't got them working as

Technical

Oracle Open World Days 1,2 - Database Roadmaps

I'm sitting now in the Speaker Ready-room down in the Moscone South mezzanine, in between sessions on Oracle Database 11g and the BI Suite Enteprise Edition & Standard Edition presentations later this afternoon. The morning started off with the Chuck Rozwat keynote on Oracle's database technology,

Technical

New BI-Related Papers and Downloads On OTN

I noticed the other day that a number of new BI-related papers and downloads have gone up recently on OTN. "New Features and Performance Enhancements in Oracle OLAP 10g Release 2" [http://www.oracle.com/technology/products/bi/olap/OLAP_10gR2_New%20Features.pdf] goes into a bit

Data Warehousing

Time series revisted (2)

Yesterday I wrote about the challenge of calculating YTD [https://www.rittmanmead.com/blog/2006/06/14/time-series-revisited/] on a sparse dataset. Even in these days of low cost storage I can not justify the vast amount of additional storage required to persist a YDT figure for each sale of

Data Warehousing

Learn by play

Today was a playday. I spent the day having a go with the new Enterprise Edition of Oracle’s BI suite. I found some of the tools very easy use and as a person with a database rather than a user-tool background I didn’t have that baggage of saying