Next Generation Outline Extractor – New Version Available

Today we released a new version of the Next Generation Outline Extractor, version  Here are the release notes from this new version:

Version supports the following Essbase versions:

11.1.2. (more...)

Ephemeral Port Issue with Essbase Has Been Fixed!

The issue that has plagued a number of Essbase customers over the years related to running out of available ports has finally been fixed!

This issue, which often manifested itself with errors in the Essbase error 10420xx range, was caused by how the Essbase Java API communicated with the server. In essence, whenever a piece of information was needed, the Essbase Java API grabbed a port from the pool of available ports, did its business, (more...)

Hadoop User Group Ireland Meetup

HUG_Ireland_logoJoin MapR and Sonra for the Hadoop User Group Ireland Meetup on 23 February at 6 pm at the Wayra offices (O2/Three building). You’ll learn more about the MapR distribution for Apache Hadoop through use cases, case studies and an introduction to the benefits of using the MapR platform.

Come by for this content-packed first event ending with the opportunity to socialise over beer and pizza kindly provided by Sonra.



What is (more...)

My OTN 2 Minute Tech Tip: Predictive Queries

A few days ago I recorded a 2-minute tech tip with Bob Hubbard of OTN.

My topic was on Predictive Queries which are a new feature in the Oracle 12c Database.

The challenge was to talk about the topic within 2 minutes. That is a lot harder than you time. Believe me.

Check out the video on the Bobs OTN 2-Minute Tech Tip channel or click on the link below.

It was fun doing this (more...)

Essbase VB API is Officially Dead

It is with a sad heart that bring you the news that, as of Essbase, the Essbase VB API is officially dead.  I cut my teeth in Essbase working with that API way back in the mid-1990's, but the writing had been on the wall for some time.  Microsoft stopped supporting VB years ago, so it was only a matter of time before this time would come.  That being said, I (more...)

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…Read more Oracle Business Analytics Update

Big changes ahead for India’s IT majors

My article on challenges confronting the Indian IT majors was published in DNA in January 2015.

Here is the complete text of the article - Big changes ahead for India's IT majors:

Hidden among the noise surrounding the big three of the Indian IT industry - TCS, Wipro, and Infosys - was a very interesting sliver of signal that points to possibly big changes on the horizon. Though Cognizant should be counted among these (more...)

Evaluating Classification Models in ODM (Part 2)

In a previous blog post I talked about and showed some of the typical statistical methods to evaluate the classification models that you develop. Click to see this (first) blog post.

In this blog post I want to show you how you can go about evaluating your classification models that you develop using Oracle Data Miner (part of SQL Developer).

What I'm not going to show you here is how to develop classification models using (more...)

Get Hadoop Certified with Free Training from MapR

If you want to upskill and get certified on Hadoop you can now do so for free. Thanks to MapR. Over the next couple of weeks they are rolling out their on-demand Hadoop training courses. The highlight of the first batch of courses is Developing Hadoop Applications on Yarn.

Related posts

Evaluating Classification Results

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.

Typically the model build process consists of 2 steps (I'm assuming all data preparation etc has been completed:

  • Build the model: During this step you will feed in a portion of your data set to the data mining algorithm. Typical this data (more...)

Pulling Large Database tables in R

As the volume of the data in your tables grows, particularly in the big data world, you may run into some memory issues or package restrictions with pulling down the tables to your R environment.

Some of the R packages and drivers have some recommended numbers or limits for the number of records that can be fetched.

In the following example I'm looking at downloading a table with 300K records from an Oracle Database. I've (more...)

Flipakart’s Billion Dollar Sale, And A Few Questions

My article on Flipkart's Billion Dollar Sale and an article that appeared in a business daily on the preparations that went into it was published in  DNA on December 29, 2014.

This is the full text of the article:

A Billion Dollar Sale, And A Few Questions, by Abhinav Agarwal, published in DNA, Dec 29 2014
An article published on an online news portal (reproduced from a business daily) claimed that "Flipkart's 'Big Billion Day' was planned over more than 700,000 man hours (six months of work put in by 280 (more...)

VC Investment Data visualization and analytics

Using the data from and easy to use dashboard software we perform analytics on a huge dataset that spans 20 years of Venture capital investment data from 1995 onward. Having data that goes far into the history should give us enough to extract the necessary analytical juice out of it.


VC investment by industry

Change in investment pattern between 2000 and 2014

The year 2000 was definitely the peak for VC investment craziness. A whopping 105 Billions was pumped into startups and bringing them (more...)

Creating a Word Cloud of Oracle’s OAA webpages in R

The following is not something new but something that I have put together this evening, and I mainly make the following available as a note to myself and what I did. If you find it useful or interesting then you are more than welcome to use and share. You will also find lots of similar solutions on the web.

This evening I was playing around the the Text Mining (tm) package in R. So I (more...)

Who made Profits for the Government on the Bailout money?

Lot of the entities have already paid the amount back to the government with interest and the government has made profits! Government has also lost money on lot of other organizations/companies that failed to repay back.

Government Bailout money visualization

Profit loss on bailout money

Checkout the full Visualization on the profit/loss analysis of Government Bailout money

And Here is the big list of all companies/organizations that made profit/loss and the percentage

government money bailout profit loss companies

Click on the image to see the full list

2014 A review of the year as an ACED

As 2014 draws to a close I working on finishing off a number of tasks and projects. One of these tasks is an annual one for me. The task is to list all the things I've done as an Oracle ACE Director. If has been a very busy year, not just with ACE activities but also work wise too. That will explain why I have been a bit quiet on the blogging side of things (more...)

ODMr 4.1 EA1 Repository Upgrade

If you are downloading the EA1 of SQL Developer that includes Oracle Data Miner (ODMr), and you intend to use Oracle Data Miner then you will need to update the ODMr Repository.

You could do it the hard way and run the upgrade repository sql scripts that are located in the ...sqldeveloper- directory.

Or you could do it the easy way and let the inbuilt functionality in Oracle Data Miner do (more...)

What makes MapR superior to other Hadoop distributions?

These days Hortonworks with their IPO and Cloudera sitting on $1bn of cash grab all the headlines. However,the real visionary in the field is someone else. Someone blasting the previous world record in TeraSort . A Hadoop distribution on both Amazon Web Services and the Google Compute Engine. A company that Google is invested in. While their competitors have been in skirmishes with each other, MapR has been quietly working away and innovating.

MapR-FS: Features and (more...)

Oracle Data Miner (SQL Dev) 4.1 EA1

A few days ago the first Early Adaptor release of SQL Developer 4.1 (EA1) was made available. You can go ahead and download it from here and make sure to check out the blog post by Jeff Smith on some install and setup that is required around the latest version of Java.

I've been using SQL Developer since its very first release, so getting my hands on a new release is very exciting. There (more...)

Easy method to create BIP 11g reports on top of OBIEE dashboards

This blog talks about a quick way to create BIP reports on top of OBIEE dashboards.

I have used 2 graphs from Sample Sales catalog for the purpose of this demo.

Edit the dashboard

Select the Print Options link

Select Custom Print Layouts -> Create Layouts

Thats it, OBIEE will do all the work of creating a layout and a data model for you.

Hit the View Report button to see your report.

You will (more...)