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 […]

Website Design & Build: tymedia.co.uk