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
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?
Paper.li
Stories from artofbi.com, thatjeffsmith.com and siebel-essentials.com
Videos such as Kevin McGinley’s ice bucket challenge
and Real Time BI with Kevin & Stewart: Man on the Street