And we’re Off

The OBIEE community really took off this week, Conference Updates, Product News, some great Blogs and the jobs market all back in swing. Can the OBIEE world keep this pace up?

blogBlogs of the week

1. Hadoop and Oracle Technologies on BI Projects

Daan Bakboord links to the slideshare to the presentation ‘Hadoop and Oracle Technologies on BI Projects’.2. BIWA Summit 2015: The Best Dedicated Oracle BI Conference All Year

Red Pill Analytics share their thoughts on the BIWA Summit 2015


Robert Gideon posts, “The OBIEE comments on the My Oracle Support Document 1488475.1 state that this will likely be the last bundle patch for the version.”

He later edited his blog to add, “After multiple people found the note in Oracle KB Article 1488475.1, the note was removed from the document.  Oracle reserves the right to patch if necessary; however, I have a feeling development is going to be more focused on the 12c version of OBIEE.”

4. How to Set Axis Max Value of AnyChart in APEX Dynamically

Gokhan Atil says, “I just created a one-page APEX application to show performance chart of our main production server based on Active Session History data. We publish it on a big monitor so we can see the performance chart during the day. It’s not a big deal but it’s really useful.”

5. Kickoff to Kscope15

Cameron Lackpour shows us where Kscope15 is due to take place and asks for our Smartphone recommendations!

6. Big Data and Aggregation

Peter Scott says, “Last time I blogged about the need to aggregate I, teasingly, promised to write about Big Data and aggregation.”

7. Evaluating Classification Results

Brendan Tierney blogs, “When you are working on building classification models you will need some ways of measuring the effectiveness of each model that you will build. This measurement/evaluation is perform during the model build process.”

He says, “In my next 2 blog posts I will show you how you can perform these tests on the results generated by the Oracle Data Miner tool and then on the Oracle Data Miner models produced using PL/SQL.”

8. Oracle SQL Developer Meets SQL*Plus?

Jeff says, “If you’re not into reading so much, we have 7 or 8 blogs on the subject out there, you can just watch the movie.”

9. Bundle patch: OBIEE 11g Bundle Patch is Available for Oracle Business Intelligence Enterprise Edition and Exalytics

Lia Nowodworska writes about the OBIEE 11g Bundle Patch -Available for Oracle Business Intelligence Enterprise Edition and Exalytics


This week on LinkedIn

Gerd Aiglstorfer posted This will likely be the final Bundle Patch – OBIEE released

Oracle Business Intelligence Applications patch bundle 6 has been released

Monica Hasebi shared ERPi Drillback for Hyperion: A client study and considerations for transitioning to FDM/EE

twitterThis week on Twitter

Daan Bakboord shared Source Control and Concurrent Development in OBIEE

Steve Yeung tweeted OBIEE Print Answers to PDF with Page Breaks,

Robin Moffat posted No Silver Bullets – OBIEE Performance in the Real World

addidici logoOBIEE News




Stories from and

Videos such as:

Source Control and Concurrent Development in OBIEE

Airbus on Using Oracle Big Data Appliance to Analyze Aircraft Sensor Data

OBIEE SampleApp 406 by The Oracle A Team

Somewhere in Oracle HQ I imagine someone is saying ‘Don’t you love it when a plan comes together‘.

Years ago, members of the team were sent on a mission to get together all the tools needed for the Big (data) battle.

Someone made a database, ‘B.A.’ came back with a ‘Java‘, Hannibal sourced a Business Intelligence hack, and Peck (“The Face”) got hold of a Virtual Machine.

Into the garage they all went with their acquisitions, and worked through the night, until out they came with a ‘SampleApp 406

And SampleApp saved the day, so they broke out the cigars, and are now famous for being wanted by the Government (and loads of companies too!).

So now, if you’re in trouble and you need help, then call in the A-Team (or better still their Sample App).



How do you get it?

Run a search for ‘Sample App on OTN’.

The first result gives you the link to the Sample App.

You then have to sign in with your Oracle Account (you have one of those right?) and Accept the usage agreement.



The trick here is to download all the files into one place.  I have 150 MB download and it took about an hour to complete.

I use 7-zip, and when you ‘Extract’ the first file part 001, all of the other parts 002-006, are also extracted.

You will need loads of space for these extract and load steps.

You then just open Virtualbox, and load the ovf file, it will then spend an hour creating the virtual machine for you.

Instructions are available in the Quick Deployment documentation



Whats in the VirtualBox ?


OEL6.5 – Oracle Enterprise Linux, also know as Oracle

MAD – Mobile App Designer v2

Oracle Database 12c

OBIEE (version from May 2014)

One word of caution, I have tried this OBIEE version with IE 8 and it doesn’t work, so make sure you can demo/use on a recent IE, or Firefox etc

There’s also,

Times Ten database,

SQL developer,


Oracle Map Builder,








Apex 4.2,

StandAlone EPM,



See the PDF Whats New




There’s more information in the User Guide



Ravi has a SlideShare for you to read


You may want to install in a cloud machine.





Now you have a sample App installed you can use it to experiment, and learn how to configure OBIEE 11g, and use the front end.

One thing I will use it for is to run through the OBE (Oracle by Example) for OBIEE, so the OBIEE OBE!  Look out for up coming articles on this.


The first page tells you how to adjust the first page.  Lets try it.

So, we will find the file that they refer to, adjust it, and restart the Presentation server.


Before the change the login page looks like this









Lets edit the logonmessage.xml file








After restart we have a new message on the front page:















another test task is at



Great picture here from Boris Dahav



There are plenty of other resources on SampleApp, just search the web!

And watch a Video!





New Year, New OBIEE Blog

You may have noticed that I am now blogging from a new domain,, also known as and sometimes referred to as !  Addidici is now just for the company stuff.  Please update your links (You have links to my blog right?   eh?)

Also blogging at a new site is Pete Scott the first featured blogger this week.  Good luck Pete.


I am looking forward to this year, my First Kscope (in Hollywood, Miami) and potential updates to the product.  We will have to make time to restart our London OBIEE gatherings (which I certainly enjoyed!), and I am also hoping to get back to work on the project (fingers crossed).



Blogs of the week

1. My 2014 UKOUG Technology Conference – Tuesday and Wednesday

Peter Scott shared this post from his drafts folder about the 2014 UKOUG Technology Conference.

2.  Close Multiple Connections in SQL Developer

Danny Byrant writes, “If you are like me, you may have multiple open connections to various database instances or to the same one for that matter, and maybe you want to close a certain set of connections. By using folders, you can do this.”

3. Real Time BI with Kevin and Stewart on BIWA Summit 2015

Dan Vlamis thanks Kevin and Stewart for dedicating a Real Time BI show to the BIWA summit.

4. This was the year that was, 2014

Cameron Lackpour reviews his 2014 blog data.

5. Exporting a PL/SQL Package Just the Way Monty Likes in SQL Developer

Jeff Smith bases his blog on this conversation:


6. Response to Campaign for Clear Licensing Open Letter to Oracle

Debra Lilley applauds the 7 steps as best practice and looks at them more closely.

7. Using Shuttles in a many-to-many relationship (Form)

Dimitri Gielis refers to his previous post then writes, “In this post we will edit a record and see how we can represent the data in a Form and save the data back to the different tables.”

8. Data Takes its Rightful Place in 2015

Ian Abramson writes of how 2015 will bring us new ways to look at data.

9. Oracle EPM What Features Are You Looking Forward to Most?

Opal Alapat asks some of her expert friends in the ODTUG EPM community, “What features are you looking forward to most?”

10. OBIEE – What the “For” in Selection Steps stands for

Boris Dahav writes, “While creating a condition with Selection Steps, there is a “For” hiding in the center of the Selection Step Wizard.”

A question was asked, what is it used for?

Boris explores this in his blog


Stories from  and

Videos such as

OBIEE and Sharepoint Embedded BI

twitterThis week on Twitter

Opal A tweeted Oracle EPM What Features Are You Looking Forward to Most?

Danny Byrant shared Close Multiple Connections in SQL Developer

Rory Capon posted Looking Ahead at the 2015 Business Intelligence Landscape

Follow @Addidici on Twitter for regular OBIEE news, updates and articles.

LinkedinThis week on LinkedIn

Dermot Eustace posted The Oracle Business Analytics Summit 2015 is now open for registration.

Uday Singh shared A Comparison between Relational Databases Vs NoSQL systems over Parallel processing! 

Saandeep Raghunath posted Simplifying ETL – Part 1

Join our LinkedIn group for regular news and updates.