Monthly Archives: October 2014

OBIEE Up a Mountain

This weeks blog is brought to you from up a mountain in Italy, at a cafe overlooking Lake Garda.
We come here for fantastic sailing competitions and pizza!

Nothing to do with OBIEE except I sometimes get to wear my OracleNerd OBIEE T-Shirt ūüôā


Blogs of the week

1. Statement of Direction for Oracle Business Intelligence Analytics (OBIA)

Daan Bakboord says that the message from Oracle to customers is clear – “Move away from OBIA 7.9.6.x and move to OBIA 11g, either in the Cloud or On Premise.”

2. Cloud Services Are Reaching Maturity РThoughts from OOW 2014

Myles Gilsenan of KPI Partners shares his post OOW14 thoughts.

3. Are Cloud Applications Ready?

Debra asks, is Oracle Cloud ready for these Applications?

4. #2MTT by @OTNArchBeat

Gurcan Orhan shares¬†a ‚Äú2 Minute Tech Tip‚ÄĚ video. ¬†He says,¬†don‚Äôt forget that it was 8am in the morning and birds were¬†still sleeping.

5. OBIEE Patch now available

3 Sixty Analytics blogs about the new patch. There are no new features in this patch ‚Äď it‚Äôs just a bug fix patch.¬†The full list of bugs fixed are detailed in the readme for this patch set.

6.¬†Say ‚ÄúBig Data‚ÄĚ One More Time (I dare¬†you!)

Kent Graziano shares the following picture:

big data

7. OBIEE with Key / Name / Value table, the Union solution

Boris Dahav blogs, “A customer asked me to create an analysis on top of a Name – Value table. A table where instead of having one row for each key, there are multiple rows with the structure of Key_Value / Attribute_Name/ Attribute_Value. This structure is very nice for developers. They can add any attribute they want, but it’s a nightmare for reporting.” Read the full blog forthe solution.

linkedin logoThis week on LinkedIn

Piyush Dutta shared Capture Adhoc Report/analysis in Usage Tracking

Italia Nowodworska posted Statement of Direction: Oracle Business Intelligence Analytics (OBIA)

Duncan Mercer shared Five Smart Reasons Why You Need a Business Intelligence Tool

twitter logoThis week on Twitter

OracleAnalytics¬†¬†posted¬†Views from IDC’s Craig Stires on the Cloud and Big Data

Daan Bakboord shared Facts and Dimensions – a perfect couple

BI Futurecom tweeted Correct order by Month date in OBIEE

Stories from, and

Videos such as Webinar : Best Practices with Oracle BI Financial Analytics

and Fiat Chrysler on the Benefits of Oracle Exalytics





Insert OBIEE name here

How many  emails do I get each week where it says,

“hi (insert name here) I just wanted to catch up with your current situation, I have an opportunity you may blah blah blah.”

IT enables mass communication at the expensive of the personal touch. 

And when it comes to recruiting, I know I prefer the personal touch.


Blogs of the week


In this blog, Scott Spendolini writes that APEX 5.0 is still going to be a few months off. The good news, however, is there will be an EA3.  Read the full blog for more information.

2. What do I need to know about Data Warehousing/OLAP?

Daniel J Power says, “A data warehouse is a central, integrated repository for historical, enterprise data from multiple business systems. An expanded definition for data warehousing includes business intelligence tools for analyzing the data and OLAP is part of the broader category of business intelligence tools.”

3. Help the Riley Family Beat Cancer

As the title says.  Dig deep please for this cause.

4. OBIEE РGO URL, the old (Px) and the new (COLx) way

Boris Dahav says, “OBIEE had always the ability to run GO URL links and pass parameters. It is documented in many blogs.” ¬†Also see Oracle documentation.

5. Execution Plans Part 10: Guesswork

Jonathan Lewis writes, “In this instalment we‚Äôre going to look at an example where some of the numbers are generated by guesswork, and some by estimates that aren‚Äôt visible in the plan.”

6. Power of/Capabilities of Oracle BI Administration РTool Query Repository Tool

Srinivas Malyala¬†blogs, ”¬†I guess many people might be knowing about this but thought of re-sharing as it may help at least someone.”

7. My OOW14 Overview

Debra Lilley puts together her thoughts on OOW14

8.¬†Oracle BICS and Identity Management ‚Äď A New Security¬†Architecture

Shiva Molabanti blogs, “Oracle BI Cloud Service, a part of PaaS, offers a highly scalable, multi-tenant Oracle BI environment that is integrated with Oracle Cloud store. Oracle BI Cloud Service features Presentation Services to create analyses and dashboards, Oracle Database Cloud Service integration, self-service web-client Data Loader and Data Modeler, simple administration, and¬†integrated Identity Management¬†for¬†Security¬†(Authentication & Authorization)¬†Services.”

9. OBIEE BUNDLE PATCH AKA (?) is available

Boris Dahav tells us that OBIEE new general bundle patch (number 9?), is available!

10. Installing Oracle on Windows 64bit

Brendan Tierney goes through the 13 steps then tells us we can now sit back, relax and watch the installation of (with the in-memory option) complete. Then he says, we are not yet finished and gives us step 14!

linkedin logoThis week on LinkedIn

Gerd Aiglstorfer shared OBIEE Monitoring РRating

Ian Bristow posted Bundle Patch OBIEE 11g is available

Anshu Monga shared OBIEE11g Implementing KPIs, KPI Watchlist

twitter logoThis week on Twitter

OracleBlogs tweeted Automating the OBIEE patching process from EM Cloud Control 12c

Boris Dahav shared OBIEE: NonEmpty MDX for Essbase (and Microsoft) Рthe secret life of PERF_PREFER_SUPPRESS_EMPTY_TUPLES

Shiva Molabanti posted Reporting Capabilities in Oracle BICS with respect to OBIEE 11g


Stories from, and

Videos such as

TransRe attended Oracle OpenWorld 2014 and spoke about Oracle Hyperion Tax Provision


2 Minute Tech Tip: Integrate Oracle Essbase with Oracle Business Intelligence Enterprise Edition

OOW Special


In case you didn’t notice, last week was OOW week.

I personally stayed at work and delivered some great dashboards (I thank you), but some people (um hum, Christian) had a whale of a time in sunny/foggy San Francisco (that place where they used to host the Americas Cup!)

Luckily, there are those who went, and who blogged (how did we manage in the pre-Internet era?)





Blogs of the week

1. OOW14 day 0

Christian Berg talks breakfasts, sessions and scheduling issues!

2. Oracle OpenWorld 2014 – Back to the Future

Alex Hansal says, “Having to watch Oracle OpenWorld with several time zones between me and San Francisco has the benefit of getting enough sleep and waking up to interesting news.”

3. Oracle Openworld 2014

Arun Kumar shares lots of photos!

4. Real Time SQL Monitoring Support in Oracle SQL Developer [Video]

Jeff Smith says, “I had a pretty good week of presenting at Open World this week. 3 solo presentations, all well attended. But in one, I had a technical issue ‚Äď that‚Äôs code for I was having problems because I was using the wrong database connection ‚Äď when trying to show off the Real Time SQL Monitoring support feature in Oracle SQL Developer.”

So he shares this video:

5. Oracle OpenWorld, Day 5

Oracle OpenWorld 2014, day 4

Oracle OpenWorld, Day 3

Oracle OpenWorld, day 2

Oracle OpenWorld, day 1

Cameron Lackpour shares his OOW14 experiences in a series of blogs.

6. Your Ideas on OOW BI and Analytics Scoop Session

Dan Vlamis asks:

For those that attended:

  • What did you find interesting?
  • Any funny stories to share?
  • What was different from what you expected?

For those that didn’t attend:

  • What would you want to know?
  • Are you more interested in the “behind the scenes” or the “major announcements”?

twitterThis week on Twitter

 Daan Bakboord tweeted Oracle OpenWorld 2014 Presentations are available to download from here.

Christian Berg shared his blog ‘OOW14 Days 1 through 4 and wrap-up’.¬†

Debra Lilley shared the video ‘The Oracle ACE Program – An Overview’

Gokhan Atil posted a presentation on OOW14: Database Patching Best Practices

linkedin logoThis week on LinkedIn

Stewart Bryson posted a link to the Georgia Oracle Users Group

Daisy Ding shared Methods of Grouping and Summarizing in R Language

Anshu Monga shared OBIEE11g Implementing KPIs, KPI Watchlist

Stories from, and

Videos such as Mark Hurd: Companies With Billions of Revenue Rely On Oracle

and Connecting to an Oracle Database Cloud Instance


Don’t forget that KScope 15 is going to be soo cool (especially for us Nerks ( nerdy geeks )).¬† I will be buying a new T-Shirt just for the event ūüôā