All indexes are good, right? Wrong. An index can make a join fly. but it can also slow you down. As I’ve said many times before, most of the time I delete or hide indexes, especially on an Exadata box and add carefully. However, whilst query performance is helped by…
Category: Uncategorized
Uncategorized
Read more
Addidici Usage Tracking Project – Part 01
Today is day one of a new project to keep me busy, The OBIEE Usage Tracking Project. The aim of the project is to build a system to analyse usage data. This will include a database build, ODI code, RPD and Catalog metadata. This will all be free to download….
Uncategorized
Read more
Catching Up
Has it really been that long since I caught up with the Market? There loads of great stuff going on in the OBIEE world but I have been preparing for the Sailing world – UK Championships, European Championships and World Championships all happening within a 4 week window. So, for…
OBIEE Week
Read more
Post Conference Blues
Whilst in Miami we had the chance to catch up with co-author Christian Screen and meet his great team at the Art of BI. His OBIEE Products are exactly what we need, and I cant wait to implement them on my current project. Watch out for news on the next…
Conference
Read more
#KScope15 Special blog
Each year the O D T U G runs a conference called KScope. It started as Kaleidoscope but is now known as Kscope and this year was kScope15. What is ODTUG? See the video… Anyway, this year I went along to see why everyone was raving about the conference….
Logical SQL
Read more
YesSQL! for OBIEE
Monday is YesSQL day at Kscope15 and to show that OBIEE can party with the best, here is some useful implementation of SQL in the OBIEE front end. Ok, so it’s Logical SQL but the principle is the same. Below I will show you how to join datasets using just…
Uncategorized
Read more
KScope Excitement Building
I am a relative Conference Newbie, and I have never been to Miami. So to say I’m excited about going to Kscope15 is an understatement! I’m not speaking, so can just relax, learn something about OBIEE 12c and enjoy the after parties. We also have a meet the authors event…
Uncategorized
Read more
Just The Latest OBIEE Market Updates
Blogs of the week 1. OBIEE 11.1.1.9 released – link library Christian Berg posted links to the new release downloads and also to the New Features Guides. 2. BITeamwork 3.5 Releases to Great Excitement – OBIEE Financial Reporting Begins Here Christian Screen writes, “We’ve never had such interest and anticipation from our customers…