This is post 100.

Doesn’t time fly when you are having fun.

And boy, OBIEE is just too much fun  🙂


Yes, there maybe new technologies turning your head, but stay faithful to OBIEE, it just gets better and better.

Blogs of the week

1. Execution Plans Part 9: Multiplication

Jonathan Lewis writes: “In part 8 we looked at a very simple execution plan involving a hash join; but that example was too simple to give us the full flavour of the arithmetic involved in Oracle’s predictions because every operation executed just once. We need to see some plans where each execution of a parent operation could requires multiple executions of its child operations; and that’s what we’re going to do in parts 9 and 10.”

2. Oracle OpenWorld Agenda Released

Eric Helmer lets us know that the Agenda is released – catch him (VP of Global IT Services at ADI Strategies and an Oracle ACE Director)  presenting CON4996, Session Title: “SaaS? Cloud? Oracle Exalytics? On-Premise? Exploring Oracle EPM Deployment Options” on Monday September 29, from 2:45 – 3:30 PM at Moscone West – 3010.

3. 30 SQL Developer Tips in 30 Days, Day 3: Syntax Highlighting

Jeff Smith gives us 30 SQL Developer Tips in 30 Days.  This one is day 3! Lots more tips to come.

4. 2 Options For Data Security in Tableau

Kumar Krishnaswamy goes though the Manual and Automatic options.

5. Build Your Own Time Hierarchy

Jeff McQuigg says, “Every single BI system has a time/date/period/calendar hierarchy in it. If you use the BI Apps, it actually comes with 2 different tables for this purpose alone, along with a ton of OOB capability. However, when you are faced with a pure custom system from scratch, how do you build one? What does it look like? What sort of data should it have in it?”

He covers:

  • There Are Multiple Hierarchies to be Aware of
  • A Closer Look at a Level

  • Optional Columns
  • Column Naming
  • Putting the Table Design Together
  • OBI Configuration
  • Building Calendar data
  • Testing
  • Other Notes

He wraps up by saying that a good time hierarchy should be very robust and flexible for users.

This week on Twitter

Danny Byrant linked to Direct Database Request

Cameron Lackpour tweeted Oracle OpenWorld 2014 EPM/BI meetup

KPI Partners shared What Is Cache?… 5 Steps to Automatically Purge Cache in Oracle BI

linkedin logo

This week on LinkedIn

Gerd Aiglstorfer added OBIEE Mobile App Designer Release 2

Monica Hasebi shared The Answer to the Analytic Needs of a Business

Daisy Ding posted How to join related tables in database construction and analysis?


Stories from, and

Videos such as Kevin McGinley’s ice bucket challenge

and Real Time BI with Kevin & Stewart: Man on the Street