OBI EE, Time Dimensions and Time-Series Calculations

Monday, April 30th, 2007 by Mark Rittman

I’m currently working on a paper on Oracle BI Suite Enterprise Edition (OBI EE) for Discoverer users, for the upcoming ODTUG conference at Daytona Beach, and a tricky area that I’ve come up against recently is getting the metadata layer in a state suitable for performing time-series queries. One of the strengths of Discoverer is […]

Oracle BI EE on Metalink?

Friday, April 27th, 2007 by Borkur Steingrimsson

I was trying to find out more about the new version of OBI EE on Metalink. If you try to find a patch or update, then you will not find it in the “Product or Family”. An Advanced search in the Knowledge Base for the exact phrase Oracle Business Intelligence Enterprise Edition will give some […]

OWB11g and other ODTUG Kaleidoscope Papers, plus News on Hyperion

Thursday, April 26th, 2007 by Mark Rittman

I was taking a look through the BI&DW presentation extracts for the upcoming ODTUG Kaleidoscope 2007 event next June, and I noticed quite a few that I’m keen to attend. The event is in Daytona Beach, Florida, and compared to the recent Collaborate event there’s quite a few presentations by various Oracle BI product managers […]

Miracle Scotland Database Forum Agenda Online

Wednesday, April 25th, 2007 by Mark Rittman

Doug Burns has already mentioned it earlier this evening, but the draft agenda for the Miracle Scotland Database Forum is now available online, and it looks really good. I work with tools most of the time, but there’s nothing better than metaphorically rolling your sleeves up and working directly with the database, SQL*Plus and the […]

Query tuning

Wednesday, April 25th, 2007 by Peter Scott

Yesterday I mentioned a query that would not eliminate unused partitions and resulted in a somewhat large nested loop join plan that would take hours to return. A kind of “find all the rows that match predicate B and then filter the result set on a range of 7 days (out of 800)” type of […]

Some Thoughts on Dimensional Modeling

Wednesday, April 25th, 2007 by Jon Mead

If you’re wondering who the “Mead” in Rittman Mead Consulting is, now’s probably a good time to introduce myself. I’m Jon Mead, I’ve worked with Mark for a number of years on projects around the UK, and together we started up Rittman Mead Consulting earlier this year to try and help Oracle customers around […]

Oracle BI EE 10.1.3.2.1 is out

Wednesday, April 25th, 2007 by Borkur Steingrimsson

Just noticed on OTN that a new version of the Oracle Business Intelligence Enterprise Edition is out. The full version number is 10.1.3.2.1 (one step from the previous Maui release 10.1.3.2). My guess is that this is just a platform availability release with no new features, but perhaps some bug fixes. The integration with BI […]

Ubuntu 7.04

Tuesday, April 24th, 2007 by Borkur Steingrimsson

The new Ubuntu 7.04 (feisty fawn) is out. I used the built-in upgrade facilities to get the new release. After 2-3 failed attempts to get the full upgrade started, I finally got the pleasure of watching the download progress bar telling me that I had some 3 hours to wait. After downloading all the new […]

Finally!

Saturday, April 21st, 2007 by Borkur Steingrimsson

Seems that the Oracle Forums have finally come to their senses and allowed changing the watch/notification email address. Hurray for them! I have had the same email addy stuck in there since I signed up back in 2000. I haven’t had access to the mailbox in 4 years by now.
So, now I can at least […]

Multiple repositories in the same OBIEE server instance?

Saturday, April 21st, 2007 by Borkur Steingrimsson

This is a strange one. The service INI file (nqsconfig.ini) for the OBIEE does suggest that the server can handle more than one repository at a time. In fact, if you do add another repository to the configuration file, that file must be a valid repository as well. Otherwise the server won’t start.
There is a […]