SQL Developer 4.1 : ODM Repository upgrade

Earlier today (4th May) SQL Developer 4.1 was released :-)

For those of you who use the Oracle Data Miner tool (that is part of SQL Developer) you will need to upgrade your repository. The following steps will walk you through the process.

1. Download SQL Developer  (you do need to have Java 8 installed) This download does not come with the JRE built into it. This usually comes a few days after the (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...)

Turning down the always on aspects of Life

There was has been various on going discussions about the every growing “always on” or “always available” aspect of modern life. 

Most of us do something like the follow each day:

  • check email, twitter, Facebook, etc before getting out of bed
  • checking emails and responding to emails and various social media before you  before you leave the house
  • spending a long day in the office or moving between multiple clients
  • spending your lunch time (more...)

Viewing Models Details for Decision Trees using SQL

When you are working with and developing Decision Trees by far the easiest way to visualise these is by using the Oracle Data Miner (ODMr) tool that is part of SQL Developer.
Developing your Decision Tree models using the ODMr allows you to explore the decision tree produced, to drill in on each of the nodes of the tree and to see all the statistics etc that relate to each node and branch of the (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

Changing REVERSE Transformations in Oracle Data Miner

In my previous blog post I showed you how you can have a look at the transformations that the Automatic Data Preparation (ADP) feature of Oracle Data Mining produces. I also gave some example of the different types of ADF that are performed for different algorithms.

One of the features of the transformations produced is that it will generate a REVERSE_EXPRESSION. This will take the scored results and apply the inverse of the transformation that (more...)

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...)

ODM : View Transformations generated by Automatic Data Prepreparation

A very powerful feature of Oracle Data Mining and one that I think does not get enough notice is called Automatic Data Preparation.

Data Preparation is one of the most time consuming, repetitive and boring parts of the work that a Data Miner or Data Scientist performs as part of their daily tasks. Apart from gathering the data, integrating the data, getting the data into the required formation the most interesting part of the work (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...)

Oracle Magazine – Fall 1997

The headline articles of Oracle Magazine for Fall 1987 (the Second issue) were on Enhancing cellular communications for Canadian Cellular, using Oracle to combat predatory starfish on Australia's Great Barrier Reef and breaking the 640K barrier using powerful microcomputers.

This was a bumper issue in comparison to the very first edition.


OM Fall 1997

Other articles included:

  • Oracle (International) User Week was held during week 27th September. This coincided with Oracle's 10th anniversary, and have over 1000 attendees. (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...)

OTech article on Predictive Queries

Last week the Spring 2015 edition of OTech Magazine was published.

Check out the link to the it here.

Otech 1

I was lucky to have an article accepted and published in this edition and the topic of the article was on Predictive Queries.

I've given a presentation on Predictive Queries at a few Oracle User Group conferences over the past 6 months or so, and this article covers what I talk about in that presentation.

The (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 11.1.1.7.0+ is in the following location and it does not include Windows 8. 

http://www.oracle.com/technetwork/middleware/bi/bi-11gr1certmatrix-ps6-1928219.xls

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.
image

The problem statement:

(more...)

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: http://server.domain.com:7002/em
  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...)

Automatic Analytics is So main stream. Not something new.

Everyone is doing advanced analytics. Right? Hmm

Everyone is talking about advanced analytics? Yes that is true.

Everyone is an expert in advanced analytics? This is so not true. Watch out for these Great Pretenders. You know what I mean! You know who I mean! Maybe you know some of them already? If not, watch out for these Great Pretenders!!!

Some people are going around talking about data mining, predictive analytics, advanced analytics, machine learning (more...)