my Oracle Data Miner Book

Some of you may be aware that I have been writing a on Oracle Data Miner. Actually the book covers the Oracle Data Miner GUI that is part of SQL Developer, the SQL and PL/SQL functions, procedures and packages that form the Oracle Data Mining option in the database and lots of other topics for the DBA, Developer and BI/DW people.
Today is a bit day for this book as it is officially released and (more...)

Oracle Magazine-November/December 2000

The headline articles of Oracle Magazine for November/December 2000 were on how application service providers are changing the way that business operate, everything from project management collaboration, professional services, online marking and how to go about becoming one.


Ora mag 2000 nov dec

Other articles included:


  • Tom Kyte has an article on how working with Java is simpliernow that it is a native part of the Oracle database. He gives some examples of how to get some of the typical (more...)

Drill-able charts in OBIEE 11g


This is a discovery more than a solution. OBIEE 11g lets us use Hierarchical column as dimensional attributes for charts.

Using hierarchical columns in chart enables us to create drill-able charts. The default view can be the top level view and the user can then drill to a more granular view in the chart on the fly.

Consider the following Analysis. I have dragged hierarchical time dimension column and a measure column. I have created (more...)

Formatting levels of a hierarchical column in OBIEE 11g


I had a requirement to indent the levels in a hierarchical column. The solution isn't really innovative but I thought of sharing this because finding the option can become a treasure hunt.

The objective is to attain the following.

















Note that the values in every consecutive level is indented compared to the previous level.

Steps:

1. Drag a hierarchical column, expand its levels and select Hierarchy Level Properties as shown below.








2. You will land (more...)

Tokenizing a String : Using Regular Expressions

In my previous blog post I gave some PL/SQL that performed the tokenising of a string. Check out this blog post here.

Thanks also to the people who sent me links examples of how to tokenise a string using the MODEL clause. Yes there are lots of examples of this out there on the interest.

While performing the various searches on the internet I did come across some examples of using Regular Expressions to extract (more...)

THINK and UNDERSTAND before you give "advice"


One tag. Rant.

Every now and then when I'm on the OTN forums, I run into gems like this: https://community.oracle.com/thread/3589607

The problem isn't the question - it's the "answer" which is both mind-blowingly wrong on so many levels and ends with the usual childish "Gimme points, I crave attention!" footer. I'm not going to go into details on the technical solution since that's covered in my response to the thread itself, but (more...)

BUCKET_WIDTH: Calculating the size of the bucket

Some time ago I had some blog posts introducing some of the basic Statistical function available in Oracle. Here are the links to these.

Oracle Data Integrator and Hadoop. Is ODI the only ETL tool for Big Data that works?

Both ODI and the Hadoop ecosystem share a common design philosophy. Bring the processing to the data rather than the other way around. Sounds logical, doesn’t it? Why move Terabytes of data around your network if you can process it all in the one place. Why invest millions in additional servers and hardware just to transform and process your data?

In the ODI world this approach is known as ELT. ELT is a marketing concept (more...)

Why Oracle Big Data SQL Potentially Solves a Big Issue with Hadoop Security

Oracle announced their Big Data SQL product a couple of weeks ago, which effectively extends Exadata’s query-offloading to Hadoop data sources. I covered the launch a few days afterwards, focusing on how it implements Exadata’s SmartScan on Hive and NoSQL data sources and provides a single metadata catalog over both relational, and Hadoop, data sources. In a Twitter conversation later in the day though, I made the comment that in my opinion, the biggest (more...)

Capturing Environment Variables in Oracle APEX


 This post focuses on the Environment variables as they are vital in coding conditional statements.

Check https://apex.oracle.com/pls/apex/f?p=81782:2:0::::: to have a look at the possible variables in a typical APEX environment.

Let me share a screenshot of the page

The page shown above has the following 2 regions.

1. Using USERENV
2. CGI Variables

Let us talk about these one by one.

Using USERENV region: This region displays information captured using the (more...)

Tokenizing a String

Over the past while I've been working a lot with text strings. Some of these have been short in length like tweets from Twitter, or longer pieces of text like product reviews. Plus others of various lengths.

In all these scenarios I have to break up the data into individual works or Tokens.

The examples given below illustrate how you can take a string and break it into its individual tokens. In addition to tokenising (more...)

String aggregation in OBIEE


In the BI world, we talk about measures and aggregation but we don't talk a lot about string aggregation. String aggregation is about concatenating strings for a certain dimensional value. Let me give an example. Let us say that we have a purchase order (Lets call it PO1) raised for a set of items (Lets say I1,I2 and I3). Lets say that the supplier does not have I1 in stock and wants a larger order (more...)

Still here

Hi everyone
I am still here. Just wanted to let you know that I am still in the business of working with Discoverer even though Oracle recently announced that it would be de-supported. If you need help just get in touch.

Also, you may not be aware but we have updated our Discoverer Handbook with the latest 11g version. You can find it on Amazon

Using DB Link in OBIEE


This blog talks about the process to use DB Links on OBIEE.

Since we are talking about linking data from 2 different databases, I will like to mention that OBIEE gives the freedom to join tables across databases in the physical layer.
BI Publisher in 11g also lets us join data sets but the join is currently an equi join. This join is called a "Link" in BI Publisher world and you can find more (more...)

Using BIP parameters in OBIEE dashboards without creating prompts


This is a simple trick that presents the process to have a parametrized BIP report in OBIEE without the need to create new prompts in OBIEE.


Steps:

1. Edit the dashboard and drag Embedded Content in an OBIEE dashboard section.

2. Put the following URL in the Embedded Content Properties
http://<OBIEE presentration server>:<OBIEE presentation server port>/xmlpserver/<BIP report xdo file path starting from shared folders>?&_xmode=2

For example,

http://<OBIEE presentration server>:<OBIEE presentation server port>/xmlpserver/Supply+Chain/Item (more...)

Permissions for both HDFS and local fileSystem paths

| Jul 18, 2014

Hi All,

Permission issues is one of the key error , while setting up Hadoop Cluster, while debugging some error found below table on http://hadoop.apache.org/ . It’s a good scorecard to keep handy.

 

Permissions for both HDFS and local fileSystem paths

The following table lists various paths on HDFS and local filesystems (on all nodes) and recommended permissions:

Filesystem Path User:Group Permissions
local dfs.namenode.name.dir hdfs:hadoop drwx——
local dfs.datanode.data.dir (more...)

Taking a Look at the New Oracle Big Data SQL

Oracle launched their Oracle Big Data SQL product earlier this week, and it’ll be of interest to anyone who saw our series of posts a few weeks ago about the updated Oracle Information Management Reference Architecture, where Hadoop now sits alongside traditional Oracle data warehouses to provide what’s termed a “data reservoir”. In this type of architecture, Hadoop and its underlying technologies HDFS, Hive and schema-on-read databases provide an extension to the more structured (more...)

OTN Latin America (North) Tour 2014

For a few years now I (and I'm sure you have too) have heard about and followed the various Oracle User Group tours that OTN arranges/facilitates. A tour consists of a number of Oracle User Groups in a region coordinating together to have their conferences organised so that they can get speakers from across the world to come and present.

For most presenters it involves lots of travel. So instead of them doing all that (more...)

War of the Hadoop SQL engines. And the winner is …?

You may have wondered why we were quiet over the last couple of weeks? Well, we locked ourselves into the basement and did some research and a couple of projects and PoCs on Hadoop, Big Data, and distributed processing frameworks in general. We were also looking at Clickstream data and Web Analytics solutions. Over the next couple of weeks we will update our website with our new offerings, products, and services. The article below summarises (more...)

Vishal Sikka’s Appointment as Infosys CEO



My article in the DNA on Vishal Sikka's appointment as CEO of Infosys was published on June 25, 2014.

This is the full text of the article:


Vishal Sikka's appointment as CEO of Infosys was by far the biggest news event for the Indian technology sector in some time. Sikka was most recently the Chief Technology Officer at the German software giant SAP, where he led the development of HANA - an in-memory analytics appliance (more...)