OBIEE Job Available Now!

There is a great RPD Developer role available in the UK, Manchester Area – Who wants it?

There is also another job available in the USA – Any Takers?


There are hundreds of other jobs too, but these are worth taking a look at.

Message me if you are currently located and eligible to work  in the UK or USA.


The Rugby is on now, so not going to add any more, except:

  1. I owe you all the next install of the Security Series (tomorrow i Promise)
  2. You need to read the blgos below…




Blogs of the week

  1. Intelligent Analytics in Data Visualization Desktop V4 (

Mike Hallett shares a link to download Data Visualisation Desktop (DVD), and also links to this video:

and the Youtube playlist.

There are also lots of links to reading material and documentation.

2. UKOUG Northern Technology Summit

This summit will take place in the North of England in early 2018 (April). Call for papers is now open.

3. OBIA 11g : Analyzing ODI ETL Load Performance – Part 1

Gunaranjan Vasireddy writes, “When you run an ODI ETL Load plan, it takes certain time. At times, customers would like to understand a split of the time taken by the load plan and analyze the top running maps to see if they can be optimized to run faster. In the first part in this series, we help you understand how you can easily analyze the time taken by the load plan and identify the top running maps.”

4. Essential WebLogic Tuning to Run on Docker and Avoid OOM

Andrejus Baranovskis advises us to read his previous post about how to run ADF on Docker firstly and foremost.  Then read on in this current blog to how to do the above.

5. Buffer cache hit ratio–blast from the past

Connor McDonald says, “I was perusing some old content during a hard drive “spring clean” the other day, and I found an old gem from way back in 2001.  A time when the database community were trying to dispel the myth that all database performance issues could be tracked back to,  and solved via, the database buffer cache hit ratio.  Thankfully, much of that folklore has now passed into the realm of fiction, but I remember at the time, as a means of showing how silly some of the claims were, I published a routine that would generate any buffer cache hit ratio you desired.  It just simply ran a query to burn through logical I/O’s (and burn a whole in your CPU!) until the required number of operations bumped up the buffer cache hit ratio to whatever number you liked Smile Less performance, more work done…. all to get a nice summary number…”

6. Using D3 and OBIEE

This blog opens by saying, “OBIEE is an integration of several pieces of technology that creates an enterprise grade scalable platform for delivering business analytics.  Because of the capabilities of OBIEE, people with no programming skills can create rich and complex visualizations using just the base functionality of the product.    When organizations do need special visualizations that can’t be accomplished with OBIEE’s delivered visualizations there can be a tendency to turn to other technology stacks because of the perception that either OBIEE isn’t easy to integrate or that using JavaScript libraries, like D3, within OBI will make it harder to upgrade the OBI in the future. ”

7. Problem loading java datasource OBIEE

Boris Dahav shares his experience of the above problem.

8. Using Content and Experience Cloud with your Oracle Intelligent Bots chatbot

Dolf Dijkstra says, “In this blog, I will show how you can use the content items from Content and Experience Cloud in your Oracle Intelligent Bots chatbot.”

He goes through:

  • Why?
  • Overview of the integration
  • Breakdown of the parts
  • Content type
  • Intent
  • Entity
  • DialogFlow
  • Custom Component
  • Service Module to construct query
  • REST call to the Delivery API
  • Re-using this sample

9. Go Big…

David Fitzjarrell concludes his ‘Go Big’ blog by saying, “Automatic Big Table Caching can be a performance improvement when large tables are the norm rather than the exception. That it’s also a feature that doesn’t require additional licensing makes it all the more desirable to configure and use.”

10. Comparing ODI Scenario versions using SQL

This blog starts off by saying, “The situation that I’m about to describe often happens in large/old ODI projects. Imagine the following: you received a task to change an ODI component that was created one year ago by someone else that is not even in the company anymore. The code is running fine in PROD and the business want a small fix to it. You open the ODI package and it contains a lot of interfaces, procedures, variables, etc. You need to change the code in one single interface, which seems very simple. You change it, save it, generate a new scenario and move it to PROD. When it gets there, the job fails due to an error in another interface that you did not touch! You start to troubleshoot and figure out that someone else changed something in DEV, saved it, but did not move the code to PROD. Unfortunately this ”unwanted” code change was included by you when you generated your scenario and now the mess is already created. If you already passed through this situation, than this post may help you.”

This week on Twitter

Oracle BI Blogs shared OBIA 11g : Analyzing ODI ETL Load Performance – Part 1 posted UKOUG is coming

Gokhan Atil tweeted Oracle Cloud Day Istanbul

Stories from and

Videos such as

Tableau Analytics for OBIEE using BI Connector

and Mark Hurd Oracle OpenWorld 2017 Keynote Highlights 10-2-2017

Good Oracle, Bad Project Manager

While Storm Brian batters the UK, Oracle batters us with update after Update!.

I am especially looking forward to Oracle XE 18.

It’s clear to me that the pace of Oracle change is picking up, and that we all need to embrace that change.  This month the DBA role was questioned with the introduction of the self updating database.  While some may be sceptical about the ability of Oracle to deliver a self maintaining database, if they do deliver then that could free up the DBA for more ‘productive’ activity, such as performance tuning everything, advising on database design and building framework PL/SQL (error traping etc).

This would help the OBIEE developers so they can focus on more content and less tuning activity.

Another thing that would help the OBIEE developer is to remove project management.  The biggest drain on a developer’s time are project managers who insist on pointless meetings, task updates, time estimates and thinking that their job is more important than everyone else’s.

It’s time that companies started trusting the developers more.  Let people know what the goal is, and let them get on with it.  You are only wasting your money and delaying your project by having a project manager.


Blogs of the week

  1. Welcome to ODTUG Kscope18!

Opal Alapat talks about the main 4 ideas which have been listened to.

1.  New Abstract Deadline

2. Expanding opportunities for volunteers

3. Publishing the ODTUG Kscope Session Evaluation Average

4. New Webcast series

Read the rest of the blog for more details of this, and more.

2.  Art of BI: The 6 Greatest Data Integrity Business Challenges

Christian Screen writes, “Clean, correct, consistent, reliable information is the holy grail of data-driven organizations, one of the most important assets that a company can have. In order to achieve data integrity, however, you’ll first have to surmount a number of obstacles.


  • Multiple sources of data
  • Multiple BI Applications
  • Manual Data Pulls
  • Inconsistently built reports
  • Excel dependencies
  • Lack of best practices

3.  POST Up a BLOB to an Oracle Table via REST

Jeff Smith writes, “Scenario: I want to post up a record to be inserted into a table. The record will consist of a couple of regular values, but also a file, which will be stored as a BLOB.Ok, how does this happen?”

4. OBIEE Security Dashboard

Syed Zubair says, “The following are benefits of having a separate security dashboard.

  • Provides a 360-degree overview of user access to OBIEE catalogues and dashboards
  • Fetches complete access details of any particular business user
  • Fetches the list of catalogs, users and AD groups (If applicable) mapped to any application role

5. Optimize Oracle response times with Cary Millsap using Method R

This blog shares details of a webinar to take place on 26th October. Register


6. BI Cloud Connector – Download Data Extraction Files

Ulrich Janke gives a short introduction to this tool followed by a focus on the file download capabilities of these data extracts. In case of an enhanced interest,  he says that in future blog postings, he will discuss other features and functions in more detail.

7. Freeze Column & Headers Plugin

Jorge Rimblas goes through how to do this and then links to a


8. OBIEE 12c – “CSF error” OR “OFM security error” OR “no matching Authentication Protocol”

Debashis Paul says, “So , Nowhere in OBIEE 12c Installation said that, you need to have certain pre-requisite condition in the DB to ensure successful installation and  you end up scratching head why you are getting all the nonsense in OBIEE installation logs when everything you did right !

Yes , unfortunately that life with Oracle tool ! (! Sigh ! ) and if you are the one person who hit this error you can try out the option below to fix.”

Read his blog for the fix option!

9. OpenWorld 2017 – Must-See Sessions for Day 1 – Sunday

Keith Laker details his must see sessions.

10. ADF BC REST Service from ADF Library JAR

Andrejus Baranovskis writes, “I had assignment to enable ADF BC REST for existing ADF application, which was developed with multiple ADF libraries. ADF BC REST was supposed to be enabled for one of the ADF libraries and then accessed through Master application. All ADF BC REST samples usually show how to enable REST inside Master application itself. I was curious if it will work to enable ADF BC REST and package it into ADF library, which is consumed from Master application. It worked and I would like to share sample app.”

This week on Twitter

Oracle BI Blogs shared OBIEE 12c in Docker from scratch

Opal A posted Welcome to ODTUG Kscope18!

Becky Wagner tweeted The @ BI Community is hosting a meetup in London!

Stories from and

Videos such as



OBIEE Jobs Market Going Strong

A quick search for OBIEE jobs last week (for no reason at all!) showed just how many jobs there are out there still. Indeed has over 1300 jpbs. Obviuosly some are duplicate and not all pure OBIEE jobs, but it does show that its still worth keeping the skills up, so read, read read..

My book that is, and these blogs…

Blogs of the week

1. Art of BI: What You’re Missing When You Can’t Visualize Your Data Part I

Bill Anderson asks the following questions:

  • What happens when you can’t see your data?
  • If you don’t have an easy, interpretable, analytics view of your data, how can you improve your operation?
  • How do you know what is working and what is not working?
  • How would you set prices under these circumstances?

He refers us also to the following white paper.

2. Call for Papers nlOUG Tech Experience 2018

Daan Bakboord shares the Call for Papers information for Tech Experience (closing date 24th December)

3. Using Oracle’s Baseline Validation Tool with OBIEE — Part 1

Michelle Kolbe writes, “This post is part 1 of 4 about using the Baseline Validation Tool (BVT) with Oracle Business Intelligence (OBIEE).”

She writes about:

  • Overview of BVT
  • Tests available in BVT
  • Catalog
  • Reports
  • Logical Query
  • UI
  • Dashboard
  • BI Publisher
  • VA
  • 12C Upgrade Baseline Testing
  • Finding BVT Help

4. Help! Where do you go for help with Oracle?

Jeff Smith asks the above question! He is running a week long poll on Twitter.

He also asks, What do you find most valuable when it comes to solving your Oracle Database problems?

Vote on the blog.

5. Watch this video:

Mark Hurd Oracle Openworld 2017 Keynote Highlights

6. Data Blending Made Easy with Oracle Data Visualization

Philippe Lions shares this youtube video:

Go here for your free trial

7. Securing Subject Areas in Oracle Analytics Cloud

Dayne Carley posts about:

  • Setting up Test Users in OAC
  • Preparing Application Roles in OAC
  • Securing Subject Areas using Presentation Services Privileges
  • Validating the Security Setup
  • Summary
  • References

8. Question Time 

Jonathan Lewis posts about Question Time at the UKOUG Tech conference

This year there are:

  • Christian Antognini
  • Nigel Bayliss
  • Maria Colgan
  • Richard Foote
  • Neil Chandler
  • Martin Widlake

If possible, he would like some advance questions, so if you have any, please comment with them on the blog or send him an email (link on the blog).

9. Review of Big Data Warehousing at OpenWorld 2017 – Now Available

Keith Laker’s review is now available – PDF version available here. (Also available for Apple and Linux users).

10.  Oh…another language is too hard”

Connor McDonald answers a question from  AskTOM a few days ago asking for an implementation of the XIRR function in PL/SQL.

11.  Announcing the 2018-2019 ODTUG Board of Directors

The new members are:

  • Danny Bryant
  •  Gary Crisci
  • Natalie Delemar
  •  Roel Hartman
  •  Eric Helmer

who join existing members:

  •  Karen Cannell
  •  Tim German
  • Mike Riley
  •  Jake Turrell


This week on Twitter

Connor McDonald tweeted A silent movie on joins

ODTUG posted Oracle Data Viz details 

Philippe Lions shared Oracle DV : What’s new in Oracle DV V4.0 Desktop version ?

Stories from

Videos such as A Look Back at ODTUG #Kscope17 in San Antonio, TX!

Oracle 12c Release 2 – How to do transparent data encryption ONLINE

OBIEE Security – Layers

Applying security in OBIEE involves a myriad of controls that weave layers of protective barriers over the data.     

There are three Main layers, each with it own strata that work in isolation or in association with the other layers.

The main layers (from bottom to top) are:

  1. Database
  2. OBIEE Application
  3. Location

The Location layer is quite simple, it’s where you expose the web address and it’s how you decide who can see the web page.  For example, In a simple development environment you may have your server on a separate subnet, which is only accessible to developers using computers or virtual machines on that network.

Access to web servers can actually be restricted too, maybe behind a firewall, or to a specific set of IP addresses.  Windows Kerberos security can be employed to make sure you only allow access to the server from already authenticated people.

Dont forget the simple controls that the location of a server can bring, and please don’t expose your server to the internet directly (Or Christian will hunt you down!)

The Database layer has a wealth of security measures to protect the data.

A brief glance at the Oracle website, oracle /database /security, will show all the layers available in the database – similar options are available on MS SQL server too.

The simple measures not listed are also important to consider, for example the use of Separate Schema to separate your data.  You can keep HR records separate from Finance, separate from Sales etc, by placing the data into separate Users, or separate Pluggable databases even!  A common database security measure is Virtual private Database (VPD) which is worth examining, although I prefer to keep this sort of security in the application layer to keep it more flexible.

Data masking and data redaction can help to hide the real values, as well as database vault can keep the real data away from unauthorised users – like DBA’s!

The OBIEE Application layer has a mixture of Object Security and Data level security.

Object security is available in all three layers in the RPD and also available in the catalog.  The common theme is that the both use users and groups to determine what you can see.  The recent change to remove the very handy Catalog groups from the equation is a real shame, but at least Application Roles can do the job nicely, and could be sourced from corporate directories.

It’s worth pointing out that user roles use a hierarchy of permissions, or inheritance if you like.  This can get really confusing if Roles are members of other roles, which have conflicting permissions.  I prefer to keep a flat hierarchy of roles (i.e. no parent-child relationships) which makes my life simple.

Data level security is applied to the business layer of the RPD.  It magically adds a where clause to your queries, nicely hiding some data, and if you design it right, letting you see the big picture.

The trick with data level security is to secure only those dimensions that need securing.

You can also build your own fine grained security, just by making use of object security or just exposing subsets (using content levels or different views in the source).


In the next article in this series we will look into Object security in the Catalog..



OBIEE Beats the Holiday Blues- Again!

The great thing about working on OBIEE projects is that when you come back from holiday (Got back last night from Croatia), you can get excited wbout going bck into the office. In fact, I cant wait til Monday – So I am going in tomorrow.

Heres what i found today….

Blogs of the week


  1. Check out the 2017 UKOUG Conference agendas

Daan Bakboord shows us the agenda for Tech17

2.  ORDS 17.3 Beta – Introducing REST enabled SQL

Kris Rice shows us where to download then writes about:

  • Versioning
  • REST Enabled SQL
  • The Fine Print
  • What’s coming next

3. Swagger Doc for ORDS RESTful Services

Jeff Smith shows us where to download then says, “There are 2 major new features, and this post is about one of those: Swagger/OpenAPI style JSON for /metadata_catalog/ calls.”

He posts this video:

4. Data Visualization with R ggplot2 – Part 2

Nandoo’s blog writes, “In my previous post Data Visualization with R ggpplot2 – Part 1, I detailed the pre-requisites for getting started with using ggplot2 with R. In this post, I will focus more on the usage of R package – ggplot2 and various visualizations that can be generated using this package.”

He finishes by saying that there are several other options available to plot various charts using R.  See the cheatsheet for all the  available options:   Data Visualization with R

5. Build ATG Commerce applications in Oracle Developer Cloud

Michael Shanley says: “This post will demonstrate how to setup and build an Oracle ATG Commerce application in Oracle Developer Cloud Service (devCS)”

Read on for more details.

6. High Five POUG: Polish Oracle User Group Conference?

Neil Chandler says, “I’ve just returned from presenting at the 2nd annual POUG Conference, this time in Krakow, Poland (the first was in Warsaw). This is the Polish Pint with Oracle User Group conference and is exactly what a conference should be. Educational, Informative, Well-executed and Fun.  It was based in a lovely city, with a wonderful friendly people, good food and great beer!”

Read the whole post for his full account, plus photos!

7. DYNAMIC_SAMPLING SQL Plan Directive in the cloud or not

Ric Van Dyke writes:  “With 12, Oracle introduced SQL Plan Directives, which in my view is really giving the optimizer a
chance to learn from its mistakes.   This is a step in the direction of a leaning optimizer.  In a way the optimizer is taking notes on how something ran and if not quite right, this note will help it not make the same mistake again.  It’s limited in 12.1 to just one type DYNAMIC_SAMPLINGand in 12.2 another one appears DYNAMIC_SAMPLING_RESULT.  Right now I’m going to focus on the first one.”

8. SystemTap and Oracle RDBMS: Page Faults

Bertrand Drouvot writes, “Now that I am able to aggregate SytemTap probes by Oracle database, let’s focus on page faults.”

His blog covers:

This blog links to the

10. ODTUG Leadership ProgramOBIEE is available

Boris Dahav links to the download page and talks about the new features and changes.

This week on Twitter

Red Stack Tech tweeted Welcome to OBIEE 12C: File Locations

Oracle BI Blogs shared OBIEE 12c Custom Style via EAR file

ODTUG posted the guidelines for Board of Directors nominations

Stories from and

Videos such as Tableau Analytics for OBIEE using BI Connector

and GoldenGate What is it; Who & What to Learn; How It Works

OBIEE is not dead, just has a new name

With just one more holiday to get through before back to work, there’s just enough time to catch up with the latest blogs we read this month.

Also happening this month were the speaker announcements for UKOUG, and unfortunately I didn’t make the cut. With so many submissions for a limited number of slots, I know it’s hard for them to decide, I have been there before on the Kscope selection panel, and there is always someone who is going to be disappointed – this time it was me.

I could speculate that it’s because my topic was not what they wanted this time, or because OBIEE is not their focus, or my submission was poor, or the sponsors took up lots of spaces, or the conference wanted more newbie speakers (or the same ones we normally see), or I annoyed the selection panel chair!  Unfortunately that’s all I can do – speculate.

So, how do I go forward from here?

In some ways it’s good to have been rejected, because the memberships fee, travel cost, hotel bill, loss of client billing, buying special equipment and software, all add up.  I was wondering why I was paying so much to give away my knowledge for free?

Then there’s the time saved, not having to work so hard to prepare the presentation.

But I guess the biggest benefit is that I reminded to constantly review the market and make sure I adapt to where it’s going  – no doubt that the Analytics  space is evolving and I need to evolve with it.  There isn’t even an Analytics track on Super Sunday – Just Apex, Database and fusion.

For the main event there is still an Analytics track, featuring Cloud (of course), Data warehousing (Good Old DW), Visualizations (New stuff) and what they call Advanced Analytics (Not sure which session this is).  There is little mention of last years trendy word (BIG DATA), and only a few mentions of data lakes, but we are still seeing lots of the Cloud word and Data Viz.  My biggest concern is there are only 2 (yes TWO) session that mention OBIEE.  Down on last year.

I still think the conference will be good, and worthwhile going if you can get your company to pay, but if I was going I think I would have trouble knowing which session to attend – the tracks conflict with each other, so I would find it difficult to decide whether to go to Apex, Database or Analytics sessions!

One speaker I would have liked to have seen is Daan Bakboord, and to quote his blurb

“Change is the law of life. And those who look only to the past or present are certain to miss the future.”

So I will take his advice and guess that in the future companies will still need Oracle Business Intelligence, some in the cloud, some cloudless, some with visualisations, some without, some advanced, some basic.  Oracle Business Intelligence will still need great database design, some customisations, and most importantly, will still need integrating into the client.  We may use new toys, new functions, new apps etc, but we will still be doing “Business Intelligence implementations”, and hopefully with great Oracle products, like OBIEE.

Hopefully all needing experts like me to be right on the cutting edge, and also fully up to speed with the current tech (i.e. OBIEE 11g/12c on site).


Anyway, start here, and learn!


Blogs of the week

1. Installing Oracle Data Integrator Cloud Service (ODICS)

Travis Brannan names Part 1 of this blog series , “Creating the Database and Java Cloud Service”. and goes through:

  • Creating the database
  • Creating the Java Cloud Service

2. Art of BI: OBIEE 12c RCU Installation – Invalid Credentials Error

Sherry Milad writes that this blog is to guide you through getting around an error you may face during the OBIEE 12c RCU Installation on a Windows 2012 R2 environment.

3. OAC Backup Issue

Robert Gideon writes about a backup issue with OAC and how to get round it!

4. Look and Feel – Feel Free to Go Crazy

Jeff Smith asks and answers: How can I make SQL Developer look…different?

5. Real Time Business Intelligence with Oracle Technologies

Iñigo Hernáez recommends going through the previous blog post first, then covers:

  • Traditional and Real Time BI
  • Case Study Overview
  • Solutions Design and Development
  • On Premise
  • Azure
  • Power BI Cloud
  • Scenario Analysis and Conclusions

6. Code Based Access Control, #securecoding #oracle #plsql #MultipleSchemas

Robert Lockard tells us to download the code here. Then says, This example depends on the HR Demo schema being loaded. We will be building on this example over the next several months to present a full blown application that includes many of the secure coding features I have been talking about.

7. Join Elimination Bug

Jonathan Lewis says, “A few years ago a bug relating to join elimination showed up in a comment to a post I’d done about the need to keep on testing and learining. The bug was visible in version and, with a script to replay it, I’d found that it had disappeared by I had a reason to rediscover the script, and decided to test it against – and found that the bug was still present.”

8. Something Going Up Is Not Always Good

Stephen Few starts off by saying, “Even though our unique ability to deal with complexity propelled humans to the top of the evolutionary heap, we still crave simplistic (i.e., overly simple) explanations. I promote the value of simplicity in my work, but never simplicity that sacrifices truth. Simple things can and should be explained simply. Complex things can and should be explained as simply as possible, but never in a way that disregards or misrepresents their complexity.” Read on!

9. Oracle Big Data Cloud Service CE: Working with Hive, Spark and Zeppelin 0.7

Gokhan Atil points us towards his previous blog post  and looks at working with Hive, Spark and Zeppelin 0.7

10. Auto enabling APPROX_* function in the Oracle Database

Brendan Tierney opens his blog by saying:

“With the releases of 12.1 and 12.2 of Oracle Database we have seen some new functions that perform approximate calculations. These include:


These functions can be used when approximate answers can be used instead of the exact answer.” Read the rest of the blog!

11. Grammar of Graphics

This week on Twitter

Opal A tweeted ‘Women in Technology Scholar’

UKOUG shared a conference sneak peek

Kent Graziano posted What is a data warehouse, and why should you care?

Stories from and

Videos such as:

KISS series on Analytics: 25 The KEEP clause


Multiplication Table Project: Create ERD with Quick SQL

OBIEE 12c Security

Security of Data, Integrity of Systems and Ease of Use are fundamental cornerstones of any system,
-and OBIEE is no exception.

This is the first blog in a series which demonstrates security features and design choices that can made when building your secure Oracle Business Intelligence system.

In the series of blogs I will cover

  1. Data Security
  2. System Integrity
  3. Code Security

Data Security

The security of data covers a wider spectrum from Legal requirement (Data Protection Laws), to simple need to know rules.  On the one hand, the penalty for exposing data to the wrong people could result in serious consequences, while on the other you get to annoy your customers/users.  The severe consequences include legal cost and fines, major damage to your company reputation and the loss of customer revenue.  These all apply internally too, so just because your OBI project is only on the company intranet, dont be lax with the data.

Just to confirm, for Data Security we mean making sure we know the right people have access to the right data.  What they do with that data, e.g. downloading, emailing etc, is up to your company policies and controls, but for us we will focus on who can see what.


System Integrity

Anyone running an internet facing business knows just how many people are trying, on a daily basis, to break in.  Whether its kids, fraudsters or government agencies they all have the potential to take down your system.

For internal based systems you could think that the chance of people hacking into your code are reduced, this is up for debate, but the possibility is still there, and what if rival companies have sent in spies to work in your company!

The system intregrity blogs will cover Authentication as well and Authorisation as well as the protocols in place to safeguard access to the components.


Code Security


Finally I will cover my thoughts on code development and therefore security of code.  This is mainly to ensure that you can develop in a fast way, unincumbered by too much overhead, but still leaves your system code safe and reliable.



The next blog will cover the many layers of data security…

Summer Fun with OBIEE

I used to get earache on flights, but not any more
… this year I’m booking my kids five rows back

Why don’t mummies go on summer vacation?
They are afraid to relax and unwind!

The sun has got his hat on in Europe this week – time to head indoors, and enjoy the shade, with a cool drink and a computer full of OBIEE blogs!

Blogs of the week

1. Art of BI: OBIEE 12c Upgrade Gone Wrong? Bring in Datavail

Bill Anderson talks about when things go wrong. He says the aspects of OBIEE that can be adversely affected by an improper upgrade are:

  • Technical deployment
  • Infrastructure
  • Core Oracle Analytics
  • Security
  • Report Development
  • High availability sets

2. Trying out the Oracle Cloud Platform

Daan Bakboord links to the download page  and tells us to try out the Oracle Cloud Platform!

3. Enforcing Naming Standards for Your Data Models

Jeff Smith answers this question:

“We tried also to apply some naming conventions but I think we didn’t understand something….
Having a logical model with a table having the column X, and a glossary having the standard name as Y. Can I apply some checks based on the glossary directly in the logical or relational model?”

4. Extending Oracle DVD Map functionality

Irina Bakardzhieva goes through:

  • The Challenge
  • DVD 12.3 plugin
  • The ClearPeak’s Solution
  • Demo
  • Conclusion

5. SQLPLUS, login.sql and 12.2 in the cloud or not

Ric Van Dyke talks about a little hiccup in 12.2  with SQLPlus in this blog.

6. Sans Kscope

Scott Wesley talks about NOT going to KScope!

7. Multi-Instance Subprocess in Oracle Process Cloud Service

Antonis Antoniou says, “The May 2017 Oracle Process Cloud Service release on-boarded a very useful and powerful on-prem feature, that of multi-instance subprocesses. In a nutshell, multi-instance subprocesses allow you to execute a specific set of actions a specified number of times either in sequence or in parallel. What shouldn’t be confused is the difference between repetitions and multi-instances. Multi-instances will create a snapshot of a specific set of actions and data, and run it a specified number of times, with each instance living in it’s own private memory space.”

8. #Oracle #sqldev MAJOR improvement

A quick blog about SQL Developer Instance Viewer!

This week on Twitter

ODTUG shared the following video:

A Birthday This Big Deserves an Entire Year of Celebrations – Happy Birthday ODTUG!

Daan Bakboord posted Trying out the Oracle Cloud Platform (Try it here)


Ricardo Giampaoli‏ shared A look back at ODTUG Kscope17

This week on LinkedIn

Andy Jorgensen shared The Future of EPM is upon us

Blogs from and

Videos such as:



Summer Holiday Reading for OBIEE Fans.

This week we have a great collection of updates – Including a great blog from Stephen Few, and some free stuff from Oracle.

We also see some more tips from the prolific Red Stack team – keep them coming guys!

I hope this week finds you on a beach, refreshing yourselves, and learning new stuff – I have just bought the latest books from Brendan Tierney, so look forward to getting sunburnt while loading more knowledge 🙂

Anyway, enjoy, wherever you are…

Blogs of the week

  1. Hunters Eat Better Than Gatherers

    Phil Goerdt discusses how we can better implement analytic solutions by challenging the convention of requirements gathering.

He says: Don’t “Gather Requirements”. Hunt for Questions.

“My take aways for consumers: Think about what data you need, the data you don’t have and what questions you can’t answer. From there, brainstorm how you can help the data suppliers understand these pain points. An export or data dump is a failing answer in my classroom!

My advice for suppliers: Try to read between the lines and understand what the consumers are really gunning for. Once you understand that, try to find ways to deliver it! “

2. Trial Subscription to Oracle Process Cloud Service

Antonis says, “Oracle has simplified the previously long and complicated process of subscribing to its Cloud Services, making it much simpler and quicker to get access to any of its Cloud Services.”

Go here and click on the Free Trial button.

3. Basta, Big Data: It’s Time to Say Arrivederci

Stephen Few blogs about why he’s had enough of Big Data.

He concludes by saying, “Let’s say “goodbye” to the term Big Data. It doesn’t mean anything in particular and all of the many things that people have used it to mean merely refer to data. Do we really need a new term to promote the importance of evidence-based decision making?”

4. Oracle REST Data Services and Docker

Kris Rice goes through:

  • TL;DR
  • GitHub Project
  • The Build Structure
  • Optional Software
  • Running The Image
  • The build

5. Unpivot

Jonathan Lewis blogs about an interesting observation that appeared recently as a side-channel on a question on the OTN database forum – how does Oracle execute an unpivot()operation. He gives an example of such a query in this blog.

6. BI Publisher 12C: Running reports via the REST API

Paul Cannon writes, “BI Publisher 12c comes with a suite of REST APIs allowing you to manage and run reports via URL calls, primarily to allow you to make automated calls from custom applications. The APIs provide a wide range of functionality from creating reports & templates, updating definitions & xliff translation files to viewing the report definition & sample data, plus of course actually running the report.

In this blog I’ll go through the basics of viewing the report definition and running a report – providing parameters and downloading the report.”

7. What is Oracle Analytics Cloud and why should you care?

Christian Screen asks us to imagine that you don’t have to worry about hosting the necessary infrastructure in terms of servers, software, and storage space, and can concentrate on using the functionality and getting results in an environment that is:

  • Scalable
  • Flexible
  • Comprehensive
  • Secure

The Oracle Analytics Cloud is all the above and much more.

He also links to these white papers

8. nl.OUG Tech Experience 15 June 2017

Daan Bakboord wrote of his experience at nl-OUG Tech Experience which took place in ‘De Rijtuigenloods’.

How to Update the ORDS_PUBLIC_USER Password

Jeff Smith writes, “ORDS_PUBLIC_USER is the database user that’s used to create your ORDS connection pool(s). Each database configured with ORDS gets one.

When you publish a RESTful Service under HR on database X, ORDS resolves the call to the proper jdbc connection pool, then proxy connects from ORDS_PUBLIC_USER to user HR, and runs the SQL or PL/SQL.

So, now imagine what happens when you let the ORDS_PUBLIC_USER password expire?” Read on for more…

10. Online Index Rebuild Problem in 12C

Neil Chandler blogs, “When building an index in Oracle Enterprise edition using the keyword “ONLINE”, if the index build fails for whatever reason a messy set of extents can get left behind.”


This week on Twitter

ODTUG celebrate their 20th birthday!


Philippe Lions shared the following video:

This week on LinkedIn

Divya Kalro asked, “Does anyone have experience in using Smartview with OBIEE?” Answer her here

Vishal Pathak shared a link to the blog post OBIEE 11G RPD bypass using Private Variable Columns

Dave Moini asked if anyone has an automated process with Oracle R12.1 or R12.2, to please share it with him

Stories from Red Stack and BI connector

Videos such as:

OBIEE Saved Filters

The beauty of data visualization


I was stuck in Bermuda last month while everyone had a great time at Kscope17!

So, for me, and everyone else who missed the fun, here are a selection of post event blogs, and some links to the actual content.

Next year I will certianly try to go over for Kscope18 – which will be held in Orlando, Florida – USA (Hone of Disneyworld!). You can book your room now, for 219 dollars – which is currently GBP169 – per night. The rate is good up to Mya next year, but will the British Pound fall further against the dollar!


Slides from some of the talks are available here.

San Antonio Revisited

Joel R Kellman writes about his fourth Kscope (third as a speaker!)

He writes about the Food and Swag, the Sessions and Sharing, The People! and Gratitude.

Kscope17 Exhibit Hall Fun

Kscope17, it’s a wrap

Cameron Lackpour talks about his lack of sleep, dinner, presentations and the people.

Using R for Data Profiling – Michelle Kolbe, Red Pill Analytics

KSCOPE 17 – San Antonio, Texas

Debra Lilley talks about how she loves the community service day, the sessions she delivered and geek game night!

Kscope18 – Call for extracts

Click the link to submit extracts for:

Application Express
Business Intelligence & Reporting
EPM Business Content
Data Warehousing & Big Data
EPM Infrastructure
EPM Data Integration
Financial Close
Data Visualization & Advanced Analytics

Open Source PL/SQL Utility Tools for Oracle

Martin Giffy D’Souza shares his slides

Alexa! How Do You Work with Oracle REST Data Services? – Jonathan Dixon, JMJ Cloud


ODTUG share the booking link for Kscope18.  You have a matter of days left to catch the Early Early Bird!

The APEX Community & ODTUG Kscope

Joel R Kallman talks about the APEX presence at Kscope17

ODTUG Kscope17 Award Winners Announced

The award winning speakers are listed here!

KScope17: A Newbie’s Perspective

Jazmin Ribeiro shares her experience of Kscope from a newbie’s perspective.  She tells other newbies not to be afarid – you will meet people!!

Kscope17 – a week full of fun and learning

Celvin Kattookaran shares lots of pictures of the event!


Opal A shares a comprehensive recap of the entire week.

Kaleidoscope 17 Half Time report

Kaleidoscope Second Half Report

Two blogs from Ludovic De Paz about this year’s Kscope.


Data Visualisation Desktop and Data Visual Analyzer

This week we have a look at some DV blogs

If you would like to trial – and you should – then download free here:

By far the best way to learn DV is to watch the Data Viz Daily series from Kevin McGinley. Available on You Tube

1. Adel Naser compares the Two products.

Oracle Data Visualisation Desktop Vs. OBIEE 12C Visual Analyzer

Adel Naser provides a comparison between Oracle Data Visualization Desktop (DVD), and Oracle Visual Analyzer (VA). He names some of the great qualities of DVD as:

  • Stunning rich interactive visuals, 22 visuals including geo mapping capability.
  • Easy to get started with the tool. Upload an excel file with the data to be analyzed and visualized, then start dragging and dropping columns to create your visuals.
  • Take snapshots of visualizations insights that are important to the business.
  • Integration between different data sources into one visual.
  • DVD is free for customers who have visual cloud solutions or an on premise version such as VA.


2. Heres a video!


3. The 10 Best Data Visualization Articles of 2016 (and Why They Were Awesome)

Evan Sinar says:

“2016 was an astounding year for insightful, informative data visualization articles — here were the top 10 I saw all year (in no particular order), in each case including a representative quote from the piece and a brief note of why it was at the top of my must-read list.” Read the full blog here.

4. Oracle DV – New filtering options in Oracle DVD 12.2.2

OracleBITECH Demo  posts the following video in their blog:

5.  Data Viz Daily playlist

6. Childhood Cancer Research Gets Investment Boost From Oracle

This press release tells how two big data PhD research projects received an investment boost from Oracle. The research projects will be conducted by Western Sydney University’s School of Computing, Engineering and Mathematics.  The studies will look at new ways of using visual analytics across two fields: using visualisation to help better interpret data in the cancer treatment of children; and how the use of virtual and augmented reality can make large scale visual analytics more accessible. Read the full press release for more details.

7. Is Data Visualization A Separate Market Or Just A Feature Of BI Platforms?

Boris Evelson says:

“If what you are looking for includes requirements for data visualization administration, security, data management, version control, collaboration, etc, you really need a BI platform with data visualization capabilities.”


Michael Sandberg shows an example of data visualization as a map from Adam Green.

9. A 6 monthly review of the best of data visualisation

These are named as:

  • The Aftermath of the US Election
  • The Impact of Dear Data
  • Data Sketches
  • Evolution in Action
  • Ship Map
  • Profiling the Parks
  • Jonni Walker
  • Joy Division Charts
  • Map Containers
  • The NYT’s Composite ‘PhotoVizzes’

10. Data Visualization Blogs You Might Not Know About

Nathan Yau shares some of the visualization (and mapping) blogs that he enjoys.




OBIEE 12c Book Published

Finally, our follow up to Oracle Business Intelligence Enterprise Edition 11g: A Hands On Tutorial has been released. The new book is named Oracle Business Intelligence Enterprise Edition 12c – Second Edition.

Co-authored with myself, Christian Screen and Haroun Khan, Oracle Business Intelligence Enterprise 12c – Second Edition is described as “A comprehensive guide from Oracle experts, that will act as your single point of reference for building an Oracle BI 12c system that turns data in actionable insight.”

The book covers the following:

Chapter 1:  Oracle BI 12c Architecture

Chapter 2: Installing the Prerequisite Software

Chapter 3:  Installing on Windows Server 2012

Chapter 4: Reviewing the Features of the Reporting Repository

Chapter 5: Installing and Configuring Client Tools

Chapter 6: Understanding the Systems Management Tools

Chapter 7: Developing the BI Server Repository

Chapter 8: Creating Dashboards and Analyses

Chapter 9: Agents and Action Framework

Chapter 10: Developing Reports using BI Publisher

Chapter 11: Usage Tracking

Chapter 12: Improving Performance

Chapter 13: Using the BI Admin Change Management Utilities

Chapter 14: Ancillary Installation Options

Chapter 15: Reporting Databases

Chapter 16: Customizing the style of Dashboards

Chapter 17: Upgrading to 12c

A wide variety of users will find this book valuable. If you are an IT professional, business analyst, project manager, and/or newcomer to Business Intelligence who wish to learn from self-paced professional guidance and actual implementation experience, this book is for you.

OBIEE, You’re soo cool

Auto-correct can be your own worst enema.

Charles Dickens walks into a bar and orders a Martini.
The Barman says: “Olive or Twist?”

Claustrophobic people are at their best when thinking outside the box.

Seriously, have a look out of the window. Its sunny, the economy is doing great, there are lots of OBIEE Jobs in the UK, and our friends at Peak Indicators won the Partner of the Year Award. Life is good. OBIEE is good. You are good at OBIEE (if you read our book)


Blogs of the week

1.  Which version was it again?

Phil Goerdt writes, “Recently I had to verify the version of an OBIEE installation for a client. As I was already ssh-ed into the Linux machine, I figured there was a way to determine the version without having to log into the presentation server. Turns out I was right, but for thoroughness sake, I’ll cover both approaches.”

2. Oracle Management Cloud – Finding the needle in the haystack

Red Stack Tech blogs: “Director of Cloud Strategy, Philip Brown has recently written an article which has been published in the 2017’s first edition of Oracle Scene. In the article, he explores the Oracle Management Cloud Log Analytics service. Phil demonstrates how this service enables you to work across infrastructure and application tiers to provide a better understanding of errors and issues and turn the huge volumes of operational log data into a useful commodity.”

3. OBIEE 11g: Setting multiple values to Presentation variables through goURL and conditional filtering

Vishal says that he is writing this blog after a long gap and it is worth the wait!!

4. SQLcl – Setting Up the Formatter

Jeff Smith says, “Just because you’re in a command line interface doesn’t mean you’re stuck with ugly code!”

5. Getting Started with GoldenGate

Neil Chandler posts a link to his article in Oracle Scene

6. @Oracle Cool new features to improve security. Part 1 Enhanced Whitelists PL/SQL

This blog states, “In Oracle 12.1 the ACCESSIBLE BY clause was introduced to the PL/SQL language. This gives the developer the ability mark a package, procedure, function, or type with what was allowed to call it. 12.2 gives us fine grained control over what can the specific functions and procedures in a package.”

7. Deception

Jonathan Lewis writes, “One of the difficulties with trouble-shooting is that’s it very easy to overlook, or forget to go hunting for, the little details that turn a puzzle into a simple problem.”

8. Integrating with Taleo Enterprise Edition using Integration Cloud Service (ICS)

Mani Krishnan says, “Integration Cloud Service (ICS) provides Oracle SaaS customers with pre-defined to connections to most SaaS subscriptions and zero-code integration features to quickly connect SaaS applications. Oracle Taleo provides talent management functions as Software as a service (SaaS). Taleo often needs to be integrated with other human resource systems.”

9. How Enterprise Manager Detects the Version of Oracle Databases

Gokhan Atil says, “You know that patch numbering has been changed since November 2015, and the new format replaces the numeric 5th digit of the bundle version with a release date in the form “YYMMDD”. Let’s say you applied PSU 160719 to your database, the exact version of your database becomes We also know that PSUs do not change the Oracle release version information that can be queried from v$version (Doc ID 861152.1), so when you query your database, you still see”

He then goes on to elaborate on this.

10. Head in the Essbase Cloud No. 1 — The Blessed Event

Cameron Lackpour writes, “No, Yr. Hmbl., Fthl., & Obt. Svt. has not suddenly changed sex and really and truly had one of life’s miracles bestowed upon him but instead something almost as great has happened:  Essbase Cloud has launched.” !!

11. My query just got faster – brief introduction to 12.2 in-memory cursor duration temp tables

Keith Laker blogs, “This post covers one of the new SQL performance enhancements that we incorporated into Database 12c Release 2. All of these enhancements are completely automatic, i.e. transparent to the calling app/developer code/query. These features are enabled by default because who doesn’t want their queries running faster with zero code changes?
So in this post I am going to focus on the new In-Memory “cursor duration” temporary table feature. Let’s start by looking at cursor duration temp tables.”

12. How to find Oracle DVD log files

Dan Vlamis starts his blog by saying, “Hey, folks, I ran into a DVD error message that referenced a log and thought I would share where I found the log file in case others were wondering this.”

13. Presentations from OUGN17

Brendan Tierney shares some of his slides, including:


This week on Twitter

ODTUG shared OAC Series: Finally Released!

Robin Moffat posted (Still) No Silver Bullets : OBIEE 12c Performance in the Real World

Red Stack Tech shared OBIEE 11G – Using dashboard prompts to view analyses 

This week on LinkedIn

Vishal Pathak shared OBIEE 11G: Setting multiple values to Presentation Variables through goURL and conditional filtering

Stories from, and

Videos such as Tableau Analytics for OBIEE using BI Connector

and What is Oracle Analytics Cloud (OAC)?

Catching Up with OBIEE News

My mate has been fired from his job at a dress alteration company.

Apparently he didn’t turn up enough.

OK, lets keep up the pace this year. Soo much to learn in the OBIEE world, so little time.

Lets talk about size. How big is your OBIEE? I was recently at an OBIEE presentation and the speaker talked about a ‘large’ obiee user base of 50 users. Sorry, but this is tiny, not even small. Should OBIEE really be used for less than 50 users? How about less than 100? Maybe, maybe not, but I do know it can handle millions of users. Seriously. MILLIONS.
Obviously not all at the same time, concurrent will be depending upon your BI Server hardware – You will obviously have to use Exadata for the database, but should you use a cluster? Well, you could. In fact most do, but whats best for a larger user base is ONE machine. Seriously, ONE.
One Exalytics machine, using as many of the processors as possible and you will have a simple environment that is fast enough for thousands of concurrent users. When you have more than 4,000 users per day, then forget the cluster, buy the Exalytics. If your client/company won’t buy Exalytics then they will spend more money trying to build and maintain the cluster of slower machines. You can go for cluster, and if you do, aim for one machine per 1000 daily users.

BTW Just how do you define concurrent users? Number of people logged in any any one time? Number of people logging in per hour? per day?. Is number of user relevent when some are running more queries than others? Is number of queries relevent when one person runs load intesive and 100 people run a quick query?

My Advice? Ask the users about their experience with the system. Use the Apex Survey app (You have installed that, right?) and monitor averages, Total Server time, Total database time, number of queires per 10 minutes, number of user logins, etc, etc. Develop a rich picture of server stats and make sure your users can let you know easily when the performance is unacceptable.


Anyway, read these.


blogBlogs of the week

  1. Uploading a file to Oracle storage cloud service using REST API

Ketan Rout writes the 2nd part of a 2 part article which demonstrates how to upload data in near-real time from an on-premise oracle database to Oracle Storage Cloud Service.

The first part of the article can be found here.

2. APEX 5.2 early outlook

Scott Wesley writes a blog post about the following slide that recently appeared at a conference:


3. Oracle’s Database as a Service in action

Porus Homi Havewala shares the following:

which is a preview lecture of the Udemy Course: Oracle Private Database Cloud. It can be found here.

4. Oracle Conferences

Neil Chandler reviews a few of the conferences he has been able to attend this year.

5. Data Modeler Reports: Templates and Configurations

Heli writes: “I do not understand why there are configurations and templates related to reports in Data Modeler. What is the difference and when are they used?”

6. PL/SQL Security Coding Practices. Introduction to a better architecture part 1.

Robert Lockard says, “I have been seeing this database architecture for over thirty years and it’s high time we stopped using it. Before I go too far, let me tell you I get it, you have pressure to get the application out the door and working in a defined timeframe. I still design and develop systems and the pressure to take shortcuts can be great. This short cut is a security killer.”

7. Oracle Data Visualization Desktop Connecting to Essbase

Wayne D. Van Sluys talks us through how to do this.

8. Oracle 12cR2 – Howto setup Active DataGuard with Temporary Tablespace Groups

William Sescu blogs: “Temporary Tablespaces Groups exist for quite a while now (since 10gR2), but they are, for whatever reason not so often used. Personally, I think they are quite cool. Very easy to setup, and especially in big environments with a lot of parallel processing very useful. But this blog will not be about Temporary Tablespace Groups. They are already explained in the 12.2 Admin Guide.”

9. Best Practices – Data movement between Oracle Storage Cloud Service and HDFS

Ketan Rout writes, “Oracle Storage Cloud Service should be the central place for persisting raw data produced from another PaaS services and also the entry point for data that is uploaded from the customer’s data center. Big Data Cloud Service ( BDCS ) supports data transfers between Oracle Storage Cloud Service and HDFS. Both Hadoop and Oracle provides various tools and Oracle engineered solutions for the data movement. This document outlines various tools and describes the best practices to improve data transfer usability between Oracle Storage Cloud Service and HDFS.”

10. Loading Data into Oracle BI Cloud Service using BI Publisher Reports and REST Web Services

Dayne Carley says, “This post details a method of loading data that has been extracted from Oracle Business Intelligence Publisher (BIP) into the Oracle Business Intelligence Cloud Service (BICS). The BIP instance may either be Cloud-Based or On-Premise. It builds upon the A-Team post Extracting Data from Oracle Business Intelligence 12c Using the BI Publisher REST API.This post uses REST web services to extract data from an XML-formatted BIP report.”

twitterThis week on Twitter

UKOUG tweeted UKOUG Conferences 2016 – it’s a wrap and Ria’s journey to the cloud with new Human Capital Management Tool

Rebecca Wagner posted The Rittman Mead Open Source Project

Michael Vickers tweeted this photo from UKOUG_Tech16


LinkedinThis week on LinkedIn

Benjamin Perez-Goytia shared Integrating Big Data Preparation (BDP) Cloud Service with Business Intelligence Cloud Service (BICS)

Kanthikiran Kalagoni posted Repository Upload Procedure in OBIEE 11G and 12C

Tanya Heise shared Business Analytics Monthly Index – October 2016


Stories from, and

Videos such as A Lookback at #Kscope16 – ODTUG Took Chicago By Storm

and Schema Wars Episode 1: The Unstructured Menace