PMML in Oracle Data Mining

PMML (Predictive Model Markup Langauge) is an XML formatted output that defines the core elements and settings for your Predictive Models. This XML formatted output can be used to migrate your models from one data mining or predictive modelling tool to another data mining or predictive modelling tool, such as Oracle.

Using PMML to migrate your models from one tool to another allows for you to use the most appropriate tools for developing your models (more...)

R (ROracle) and Oracle DATE formats

 When you comes to working with R to access and process your data there are a number of little features and behaviours you need to look out for.

One of these is the DATE datatype.

The main issue that you have to look for is the TIMEZONE conversion that happens then you extract the data from the database into your R environment.

There is a datatype conversions from the Oracle DATE into the POSIXct format. (more...)

Understanding OBIEE RPD – Chapter 1

The most skilled task in the world of Oracle Business Intelligence is to design and code the RPD. While we are all aware of the general concepts of Business models, logical tables, joins and hierarchies, the RPD is essentially a query generating tool. The query generated by the tool depends on a sound understanding (more...)

Flipkart and Focus 3 – There’s Something (Profitable) About Your Privacy

The third in my series on Flipkart and focus appeared in DNA on April 18th, 2015.

Part III – There’s Something (Profitable) About Your Privacy
Why do so many companies hanker after apps? Smartphone apps, tablet apps, iOS apps, Android apps, app-this, app-that….
Leave aside for a moment the techno-pubescent excitement that accompanies the launch of every new technology (if you are not old enough to remember words like “client-server[1]”, then “soa[2] (more...)

OBIEE released – link library

OBIEE went GA yesterday and is available for download on OTN here.

Oracle Documentation for is here.

And most importantly the 3 "New Features Guides" in detail:


Flipkart and Focus – 2 – Mobile Advertising Numbers Can Be Misleading

The second part of my series of articles on why I believed Flipkart was at losing focus, at the wrong time, when faced with its most serious competition to date. This one focused on why a fascination with mobile advertising numbers could be very misleading.
It was published in DNA on April 14, 2015.

The Numbers Game Can be Very Misleading
According to the Internet Trends report of 2014, mobile internet advertising spend grew 47% (more...)

New OlapUnderground Utility – The Essbase Outline Viewer

Have you ever wanted your users to see an Essbase database outline structure, but had trouble giving them access to Essbase Administrative Services ("EAS") for fear that they may have access to change things they shouldn't change?  Maybe you didn't want to give them EAS and have to deal with the version of Java installed on their machine?  We have the solution to your problems.  After a bit of fits and starts, we have finally (more...)

Making OBIEE 11g Evaluate function dynamic

We know that we can use the evaluate function to call any function stored on the database and pass arguments to it. What if we have a requirement to use different database functions for the same column based on different selections made by the user.
This article talks about a method to handle this (more...)

Oracle Business Intelligence Cloud Service Data Sync is out on OTN

A typical Oracle BI Cloud Service (BICS) flow looks like the following: Load your data to the Cloud Model and Secure your data Author Analyzes,Visualizations and Interactive Dashboards Use and Share BICS content In the current version of BICS you have to upload your data into the Cloud. There are several ways to load the…Read more Oracle Business Intelligence Cloud Service Data Sync is out on OTN

Handouts – Introducing Oracle’s Information Management Reference Architecture

One of the great things of working in the Oracle Business Analytics industry is the fact that there is a very active community. Both online as well as offline. Oracle supports these activities where possible. Last week I attended an offline session at Oracle HQ in the Netherlands. This session was a event organized by…Read more Handouts – Introducing Oracle’s Information Management Reference Architecture

Introducing Oracle Analytics Cloud

I recently joined Quistor as a Senior Oracle BI Consultant working from the Netherlands. Quistor already has an Oracle BI Practice working from Spain. As a well-respected Oracle BI Partner in Spain it only seemed logical to start expanding the Practice from the Netherlands. The place where it al has began for Quistor. Why Quistor?…Read more Introducing Oracle Analytics Cloud

Flipkart and Focus – 1 – Losing It?

This is the first of a series of articles I wrote for DNA in April on why I believed Flipkart (India's largest online retailer and among the most highly valued startups in the world) was at losing focus, at the wrong time, when faced with its most serious competition to date.

"Why Flipkart seems to be losing focus", appeared in DNA on Sunday, April 12, 2015.

Part I
Among all start-ups that have (more...)

Accessing HDFS files on local File system using mountableHDFS – FUSE

Hi All

Recently we had one requirement wherein we had to merge the files post Map and Reducer job. Since the file needed to be given to the outbound team outside of Hadoop development team, having these files on local system would have been ideal. The customer IT team worked with cloudera and gave us a mount point using a utility/concept called “mountableHDFS” aka FUSE (Filesystem in Userspace)  .

mountableHDFS, helps allowing HDFS to be mounted (more...)

How to read HDFS fsImage file

During one of the sizing exercise the  ask for server capacity  was more than the actual usage of cluster . Knowing the data and usage, I was not convinced that we should be asking for more memory space. That triggered the thought of

Conceptually FSIMG file is the balancesheet of all the file and their existence and location. If somehow we could read the metadata withing the file and make sence out of it, than it could help (more...)

OBIEE 11g query tracking mechanism

We had a requirement of tracking a query fired from OBIEE. This was to help us find out the Analysis that consume the most database resources.
It is possible that some user might be selecting a huge date range resulting in the problem at the database. So the trouble in this case might be (more...)

Installing OBIEE 11g Client tool on Windows 8

OBIEE 11g client tool is not certified with Windows 8. 
The certification matrix for OBIEE version is in the following location and it does not include Windows 8.

This blog talks about a way to to install admin tool on Windows 8 machine.

We can download both the 64 bit and 32 bit windows installer for client tool from OBIEE portal.

The problem statement:


OBIEE 11g dashboard pages outside of a dashboard

We had a strange requirement. The user did not want the dashboard to be published and he hated the fact that he had to expand the dashboard to see the pages in it.

Since the requirement is strange so will be the solution.

One option is to create the shortcut of each page and then hide the dashboard.  This option is recommended but will lead to creation of a shortcut for each page.

The (more...)

Might need to use Tunneling with Discoverer 11g

I have noticed a few instances recently of Discoverer 11g Plus failing to open or taking an awful long time to open. In both of the cases where this has been reported to me by my clients, changing the plus communication protocol from Default to Tunneling did the trick.

To enable tunneling for use with Discoverer Plus, use this workflow:

  1. Launch Enterprise Manager using something like:
  2. Enter your Username and Password. Username (more...)

3 way switch in OBIEE 11g

While we all know about using conditions on sections in a dashboard, and while we all have used presentation variables to show or hide a report using these conditions, this blog talks about a process to use conditions on sections to implement a 3 way decision rather than just a boolean (true/false) decision.

Lets say that we have to show one section based on one value of a presentation variable, another based on another value (more...)

Meet Sonra at CeBIT 2015

We will be presenting the Sonra Hadoop Quick Start Appliance at CeBIT next week in Hanover. Meet and greet us in Hall 2, Stand D52 (C58).

At Sonra we understand the difficulties faced by businesses when they begin their Big Data journey. We help you get started in days or weeks and immediately reap the benefits of Big Data. Sonra have packaged optimised Hadoop Supermicro hardware with MapR, the prime Hadoop distribution, and added our (more...)