Oracle Business Analytics Update

Last week I visited the Oracle Business Analytics Partner Update at Oracle NL in Utrecht, the Netherlands. The NL (Pre-) Sales gave us an update of the Oracle Analytics Roadmap. There is a lot of movement in the world of Oracle Analytics. I have written about the publications during Oracle Open World 2014. When we look back at 2014; “Year in Review – Oracle Business Analytics in 2014“, we can see that there are a few subjects key; Big Data, Cloud.

Oracle Business Analytics Strategy

The Oracle Business Analytics Strategy can be captured in one picture.

Oracle Business Analytics Strategy - 2014

The Oracle Business Analytics Strategy consists of Six Design Goals.

Oracle Business Analytics Strategy - Six Design Goals

1. Solutions – “To see more Patterns”

    • 12 C
    • R Integration
    • Interactive Dashboards
    • Voice & Word Recognition (BIAsk)
    • Data Mashups
  • Endeca Information Discovery

2. Mobile – “A Secure and Simple Experience”

Oracle has two options for a Mobile Experience.

  • Oracle BI Mobile HD
  • Oracle BI Mobile App Designer

3. More Answers – “In Context”

  • Oracle BI Applications (On Premise)
  • OTBI Saas (Embedded in Oracle Cloud Applications)
  • OTBI Enterprise (HCM, CRM, ERP, etc.)

4. Most Complet – “Cloud Capabilities”

Oracle has introduced new Cloud Services. The Oracle Analytics Cloud delivers Business Intelligence  & Analytics for Traditional Data and Big Data; Oracle Business Intelligence Cloud Service

There already is a lot of information to be found about the Oracle BICS offering;

If you like there is also a possibility to Try it Live.

5. Engineered – “Systems that Scale Operations”

Larry Ellison announced the Next Generation of Oracle Engineered Systems. See the Press Release here.


Check here for more video’s about Oracle’s X5 Engineered Systems Launch Event.

6. Faster – “Innovation Cycles”

Oracle introduces; Oracle Big Data Discovery – The Visual Face of Hadoop. With this new tool you should be able to spend more time on analyzing your data instead of prepping it. Check here what Oracle has to say about it.

Sounds like enough to try to keep up with!

Hadoop and Oracle Technologies on BI Projects

Last night I attended an event powered by oGH and OBUG. Mark Rittman was invited to talk about; ‘Hadoop and Oracle Technologies on BI Projects’. This event has been organized to inform us about Hadoop combined with Oracle Technologies. Next to that the event was also meant as a start up of a BI / Warehousing SIG.

Last May I visited the Rittman Mead BI Forum in Brighton. I attended a Cloudera Hadoop Masterclass. Mark extended this Masterclass where he integrated Hadoop into the (traditional) Oracle BI world. It was a very interesting session. Check a blogpost form Jan Karremans for a summary.

Although a lot of my current clients are still struggling with their (Operational) BI, it’s very interesting to see how Oracle responds to the Digitization & Datafication of the world.

Oracle Data Warehousing Platform - 2014

The Oracle BI Community is a very vivid and lively (Online) Community. There are a lot of offline (partly) Oracle BI related events around the globe. Sadly there is not much offline activity (yet) in the Benelux. It’s good to hear that the oGH and OBUG seem to join forces to setup a BI / Warehousing SIG. Mark proved with his session that there is a lot to talk about as we see that the worlds of traditional Data Warehousing and Hadoop & NoSQL (Data Reservoir) are colliding.

Check out Mark’s Slideshare for his presentation. For those interested in the BI / Warehousing SIG, please watch the OBUG-site. There is a new session planned for 3 march 2015.

Oracle BI By Bakboord – 2014 in review

The stats helper monkeys prepared a 2014 annual report for this blog.

Here’s an excerpt:

Madison Square Garden can seat 20,000 people for a concert. This blog was viewed about 68,000 times in 2014. If it were a concert at Madison Square Garden, it would take about 3 sold-out performances for that many people to see it.

Click here to see the complete report.

Preparing for TOGAF 9 and ArchiMate 2 Exams

Last week I posted a blog that I had passed my TOGAF 9 and ArchiMate 2 Certification Exams. Find below the two presentations I made for myself to help me study. It’s certainly not enough information to pass both exams, but it might help to get the bigger picture.


ArchiMate 2


I hope these presentations can serve as a little bit of help.

Good luck.

TOGAF 9 and ArchiMate 2 Certified

The world is changing. People are asking for new kinds of rapidly changing data. This has a big impact on Business Intelligence and Information Management as we have known it for a long time. Therefore I look with great interest in Information Management Architectures in general and Oracle BI Solution Architectures in particular.

Information Management Architectures as a result is one thing, but the processes that lead to, and govern these Architectures is another. I did some (online) research and stumbled upon The Open Group.

“The Open Group is a global consortium that enables the achievement of business objectives through IT standards.”

There are several Forums and Work Groups for Enterprise Architecture within The Open Group. Two of the were very interesting me;

  • The Open Group Architecture Forum is the premier global environment for fostering the development and delivery of robust Enterprise Architecture ecosystems, and is responsible for the evolution of TOGAF®. The mission of The Open Group Architecture Forum is to advance The Open Group’s vision of Boundaryless Information Flow™ ( achieved through global interoperability in a secure, reliable and timely manner).”
  • The Open Group ArchiMate® Forum supports the use and dissemination of, and continued development of ArchiMate®, an open and independent modeling language used in Enterprise Architecture. Joining the ArchiMate® Forum enables you to actively support the use, dissemination, and further development of the ArchiMate® specification.”

TOGAF is relatively popular in Holland, compared to other countries in the world.

Over the last two months I took a few classes with The Unit AcademyThis resulted in two Certifications; TOGAF 9 Certified and ArchiMate 2 Certified. I would like to thank Joost Bleijenberg and Rienk de Kok from The Unit. The provided us with a training which served as a solid foundation to take all four (Level I and Level II) exams. The TOGAF exams as well as the ArchiMate were (very) theoretical. Nevertheless Joost and Rienk took a practical approach to make sure we understood the structure of both specifications.   

togaf9-certified archimate2-certified

Now it’s back to the real world, where a lot of Processes and related Information (Technology) is not so well structured as we would like them to be. Enough work to be done 😏.

Facts and Dimensions – a Perfect Couple

With Oracle BI EE (OBIEE) you are able to report against various different data models. There are several different interesting blogposts to prove that. Let me Google that for you; Transactional Schemas, Data Vault. In the end the Business Model and Mapping Layer (Logical Layer) ‘needs’ a Star Schema to construct the model we can report upon.

To simplify things, the Star Schema is one Fact-Table with one or more Dimension-Tables. So when you start creating your reports in eg. Oracle BI Answers, it’s just a matter of combining the Fact-Table with the Dimension-Table(s). Last week I was at a client who had a problem with one of the reports; Unexpected Results.

The issue was the following; 3 Dimension-Tables joined together. Dimension-Tables in a Star Schema do not have a direct relationship with each other. The 3 Dimension-Tables together only get a meaning when there is a Fact-Table included. Let me clarify that.

Let’s say we have 3 Dimension-Tables (Date – 27/10/2014, Product – iPhone, Region – Europe). If we put these 3 Dimension-Tables in a report, what does that tell us? Nothing! We can guess. There are iPhones sold in Europe on 27/10/2014? That might be. How much? We don’t know. There are iPhones stolen in Europe on 27/10/2014? That might be correct as well.

If we add a Fact-Table (Quantity Sold – 20,000) to the above, the whole query makes more sense. There are 20,000 iPhones sold in Europe on 27/10/2014.

When you construct a query in OBIEE with only Dimension-Tables OBIEE includes a Fact-Table in it’s query. Unless you have defined an Implicit Fact Column, you don’t necessarily know for sure which Fact-Table/Column is included in the Dimension-Only Query.

Facts and Dimensions are a Perfect Couple, please include both of them in your query.

Statement of Direction for Oracle Business Intelligence Analytics (OBIA)

Last week Oracle released a Statement of Direction (SOD) for Oracle Business Intelligence Analytics (OBIA). The message from Oracle to their Customers is clear; Move away from OBIA 7.9.6.x and move to OBIA 11g, either in the Cloud or On Premise.

Let us have a look what the actual message is. Find below a picture would find in a lot of the current Oracle presentations regarding Oracle Business Analytics. It’s shows you Oracle’s Business Analytics Strategy

Oracle Business Analytics Strategy - 2014Oracle delivers ‘Any Data’ via a ‘Full Suite of Analytic Tools’, Pre-Configured in ‘Packaged Analytic Applications’, Engineered together on Exalytics (one of Oracle’s ‘Engineered Systems’)

Oracle delivers Packaged Analytic Applications in roughly two different flavors:

  • Informatica 7.9.6.x
  • ODI 11g

There will be no more upgrades on Oracle BIA 7.9.6.x (Informatica release). A few months ago there was a rumor that there would come an Oracle BIA 11g (Informatica release). This is not going to happen.

What are the options?

If you read the SOD for OBIA, existing Oracle BIA 7.9.6.x-Customers are left with three options:

  1. Remain on Oracle BIA 7.9.6.x
  2. Move to ODI 11g
    • New separate instance
    • Migrate to a new instance
  3. Move to the Cloud

Remain on Oracle BIA 7.9.6.x

Remain on Oracle BIA 7.9.6.x

If a client wants to stay on Oracle BIA 7.9.6.x, please check Oracle’s Lifetime Support Policy. You will find the Oracle BIA Lifetime Support Details under the Oracle Business Intelligence EE Releases.

OBIA Lifetime Support - 2014

There are three different Support Levels.

  • Premier
  • Extended
  • Sustained

Check the Oracle Software Technical Support Policies for more details about these Support Levels.

Of course if you want to benefit from new content and new functionality, its better to choose one of the two following options.

Check the Oracle picture below for the OLTP Coverage for OBIA

Oracle BI Applications OLTP Coverage for

Move to ODI 11g

Move to ODI 11g


Move to ODI 11g and benefit from:

  • New Content
  • New Adapters
  • Common Enhancements

Prebuilt Solutions for Orale eBS, PeopleSoft, Siebel, JD Edwards, Fusion Applications, etc.

Move to the Cloud

Move to the Cloud

There will be different Cloud offerings for OBIA.

  • Oracle Transactional Business Intelligence for Oracle SaaS Applications
    • OBIA embedded within every Oracle SaaS Application (CRM, HCM, Finance, Supply Chain, etc.)
  • Oracle Transactional Business Intelligence – Enterprise