Partitioning gripes A little while back I took part in a partitioning survey. You may have seen it mentioned on Ton Kyte's blog. It is certainly good to be asked these things - but I expect that the organiser of the survey already had an inkling of my views anyway.
OBIEE and Row-Level Security During the past week I've been working on getting row-level security working with Oracle BI Suite Enterprise Edition. Like most OBIEE topics, typing the subject into google brings up zero results and so my first port of call was the online documentation on OTN. I'm not
UKOUG call for papers The UKOUG [http://www.ukoug.org/] is having a conference in December and the call for papers for the 2007 calendar has been open for a while now. I just finished submitting an abstract through their website. This is the first submission I make to such a big conference so
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
Test cases revisited Back in January I wrote [https://www.rittmanmead.com/blog/2007/01/30/sending-test-cases-to-support/] about a bug we found in the query optimiser that caused some of our complex temporary table star_transformation query candidates to crash the plan evaluation phase of optimisation with an ORA 604 error. Well, the
Data Warehouse health-checks Like cars and people, a data warehouse can benefit from a check-up to keep things in top condition. Unlike cars and people data warehouses don't tend to have parts that wear out but DWs do age; either technology moves on and new, more efficient, techniques can utilised or
Oracle OLAP 11g News, and the Vlamis Blog Whilst I was over at Collaborate'07 last month, one of the biggest bits of product news that I heard about, but couldn't mention fully at the time, was details of the new 11g release of Oracle OLAP. Chris Claterbos from Vlamis Software Solutions was given permission
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
Unable to connect to the OWB Control Center I am currently doing some OWB 10gR2 training in Iceland, some of the examples I am using are on a Virtual Machine running on my laptop, halfway through the day I tried to connect to the Control Center and I got the following error: RTC-5260: Failed to connect to Control
Technorati I had never really paid much attention to Technorati before. Seems like a quick way to find blogs just about anything. Now I have a profile there. Technorati Profile
Month start odds and ends Yet more consolidation in the BI product space. Every so often one of the major vendors disappears into a larger vendor. Proclarity has been absorbed by Microsoft and no sooner than Oracle had digested a main course of Sibel and its amazing BI tool, it was on to Hyperion for
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.
OBI EE, Time Dimensions and Time-Series Calculations 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.
Oracle BI EE on Metalink? I was trying to find out more about the new version of OBI EE [http://www.be-ice.eu/2007/04/25/oracle-bi-ee-101321-is-out/] on Metalink [http://metalink.oracle.com]. If you try to find a patch or update, then you will not find it in the "Product or Family"
Technical OWB11g and other ODTUG Kaleidoscope Papers, plus News on Hyperion I was taking a look through the BI&DW presentation extracts [http://www.odtugkaleidoscope.com/2007conference_papers.htm#BIDW] for the upcoming ODTUG Kaleidoscope 2007 [www.odtugkaleidoscope.com/] event next June, and I noticed quite a few that I'm keen to attend. The event is in Daytona
Miracle Scotland Database Forum Agenda Online Doug Burns has already mentioned it [http://oracledoug.com/serendipity/index.php?/archives/1257-MSDBF-Agenda-Online.html] earlier this evening, but the draft agenda for the Miracle Scotland Database Forum [http://www.miracleltd.com/index.asp?page=167&page2=343&page3=368] is now available online, and it looks really
Technical Query tuning 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
Technical Some Thoughts on Dimensional Modeling 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
Oracle BI EE 10.1.3.2.1 is out 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
Ubuntu 7.04 The new Ubuntu [http://www.ubuntu.com/getubuntu/] 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
Finally! 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
Multiple repositories in the same OBIEE server instance? 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
Back to the UK, Then off to Dusseldorf I'm back in the UK now after a rather eventful flight back from the States; our flight from Las Vegas to San Francisco was delayed by around an hour, which meant we arrived at SFO at 4.00pm for a 4.30 flight back to Heathrow. After a
