Monthly Archives: September 2014


blogBlogs of the week

1. Installing BITeamwork on SSL Configured WebLogic Admin Server

Christian Screen writes, ” Although not a very common integration but every now and then an organization will install OBIEE with SSL configured between the components.”

He lets us know of common errors and how to fix them!

2. APS diagnostic report failure

John Goodwin says, “If you are running and a Provider Services version before patch 502 then if you run a diagnostics report you should hopefully see a pass for the Essbase web services. If you decide to apply patch 502 or later then there are some changes that have been made to the web services.” Read on for more details.

3. My Oracle Open World Objectives

Debra Lilley explains the many hats she will be wearing this year at OOW!

  • Oracle ACE Director*
  • Oracle Applications UX Advocate
  • Usergroup Leader
  • Speaker
  • Partner – My new job
  • With Analysts
  • Just for fun
  • As a mum


This blog goes through interview questions regarding Agregate Tables such as:

  • What is granularity?
  • What is content logical level ?
  • If Two fact tables, due to some reason has same granularity then how to decide the priority?

5. The importance of BI specific skill sets

Lyndsay Wise writes, “BI implementations are becoming more commonplace as organizations realize they cannot overlook the management of and access to their data in order to facilitate better decision-making. What this means for many is the re-evaluation of resources, skill sets, and project planning to ensure that the proper resources exist to support BI and analytics development.”

6. #OOW14 Sessions & Interests & Social

Gurcan Orcan lists his sessions:

Here are my sessions to speak for this year’s Oracle Open World.

and then goes on to list the sessions he himself would like to attend.

7. Oracle Endeca Information Discovery Resources

Pravin Khadakkar says, “Oracle Endeca Information Discovery (OEID) is one the most significant product to enter into the Big Data space, this blog is an attempt to give a brief overview of the OEID and list down links for resources for the same.”

8. Building KPIs And Using KPIs Presentations

Boris Dahav says, “At the last ILOUG we presented the “KPIs creation in OBIEE”  and “Using KPIs in OBIEE”.

Download them here.

9. Treemap Visual Now Available on Oracle BI Cloud Edition

Last but certainly not least, Christian Screen blogs, “We all like new shiny-spoon features and it looks like the Oracle BI public cloud edition will be brandishing at least one new visual on which we can feast our eyes. Treemap visualizations have long been a staple in analytical visual renderings and many a business user will be happy to explore this new functionality.”

He links to the following video: 

Oracle Business Intelligence Cloud Service: Convert Data into Insight

linkedin logoThis week on LinkedIn

Marije Nelis asks How are technologies like #Cloud & #BigData transforming business?

Monwabisa C. Sibiya asks the question “Is there anyway of reporting using Google maps in OBIEE other than Oracle Spatial reporting?” Answer him here.

ANAND EKBOTE shared OBIEE Smartview Integration

twitter logoThis week on Twitter

KPI Partners tweeted one from the archives – Complex Row Level Security in Oracle BI (OBIEE)

Gerd Aiglstorfer shared his blog post Oracle BI Mobile HD App

Daan Bakboord posted Update to the FAQ-section of the OBIEE – Sample Application (V406)


Edition of 22nd September

Stories from and

Videos such as

No Silver Bullets – OBIEE Performance in the Real World

and Deploying an Application to an Oracle Java Cloud Service Instance

Summer Loving – And OBIEE Greases the wheels of Industry


You may have noticed that Sailing features strongly on this blog, so today was a great day for us as we joined thousands of sailors around the World who raced against each in Barts Bash –

The only downside is that a certain large competitor of Oracle is presenting the results – We need to get the full Oracle based results analysis system out there to show that Oracle Database and OBIEE are better than a certain TLA.

I hope it didn’t pass you by – The Major news of the week is the launch of the Cloud BI solution from Oracle.  I don’t know how this will change IT departments, but look out for reviews on this as we find them.

Anyway, on with the show…

Blogs of the week

1. Your indispensable guide to DW at OpenWorld in iBook and PDF formats

Keith Laker has put together a comprehensive downloadable guide of all the data warehousing and big data activities at OracleOpenWorld 2014. Download it here.

2. Analytics Hands on Labs at OOW 14

Brendan Tierney says, “After trawling through the list of Hands-on-Labs it was disappointing to see that there was no Oracle Data Mining or Oracle R Enterprise hands-on-labs this year.

But there is a hands on lab that looks are how to use the new SQL for Big Data feature (announced over the summer).”

3. Who moved my data?

John Booth pays homage to ‘Who moved my cheese?’ in this blog about data.

4. OBIEE common Pre-defined System Session Variables

Praveen shares the common Pre-defined System Session Variables in this blog post.

5. It’s almost time! #OOW14 and #OTW14 – the biggest gathering of Oracle experts anywhere

Kent Graziano writes, “There will be much to see, do, and learn at what is arguably the largest (60k+ people) gathering of Oracle users and experts in the world. Expect big news from Oracle Corp, great sessions from Oracle ACEs and ACE Directors, and of course the annual customer appreciation event.

So here is my short list of what to check out this year:”

Read the full blog for what he expects to be highlights!

6. Minimalist Design for the Criteria Tab

Jeff McQuigg says, “When it comes to OBI report design, minimalist is the only way to go when it comes to the Criteria Tab.” Read his full blog post to find out why.

linkedin logo

This week on LinkedIn

Anshu Monga shared ETL Part 1

Kent Graziano posted It’s almost time! #OOW14 and #OTW14 – the biggest gathering of Oracle experts anywhere

Gerd Aiglstorfer shared Top 4 BI Articles

Mohamed Abdelaziz posted MERGE Two Repository in OBIEE 11G

twitterThis week on Twitter

David Haimes posted Focus on Oracle Social Network at OpenWorld

Danny Byrant shared Direct Database Request

Stories from and

Videos such as The Oracle ACE Program – An Overview

and 35th America’s Cup Press Conference – Full Replay

and Mark Hurd Previews Oracle OpenWorld Theme – the Social, Mobile Customer




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.

twitter logoThis 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