Meet the Oracle ACE Directors Panel – January 9 – Seattle


I will be in Seattle on Thursday, January 9th for the Meet the Oracle ACE Directors Panel.  It is at the Sheraton Seattle from 4 - 6 pm and will feature several other ACE Directors including Martin D'Souza, Kellyn Pot'Vin, Tim Gorman, and my longtime friend and collaborator, Cameron Lackpour.  

Data Densification in Oracle APEX


Data is often stored in sparse form and business often wants to see data in a more organized and explicit fashion. Report developers working across reporting tecnologies face a requirement to show a record with a '0' in the measures columns if no data exsists for a particular combination of (more...)

Smart View Internals: Exploring the Plumbing of Smart View

Ever wonder how Smart View stores the information it needs inside an Excel file?  I thought I would take a look to see what I could learn.  First, I created this simple multi-grid retrieve in Smart View.



Note that the file was saved in the Excel 2007 and higher format (more...)

Upgrading to SQL Dev 4 & Oracle Data Miner 4

The production release of SQL Developer 4 and Oracle Data Miner 4 has just been released. If you are like me you will want to upgrade and start using this latest release. For me I particularly want to be using the new Oracle Data Miner 4.  Over the past (more...)

Creating dynamic breadcrumb chains in Oracle APEX


This article is borrowed from one of the topics of my book (http://www.packtpub.com/oracle-apex-4-2-reporting/book) on Oracle APEX 4.2 reporting. I wish to talk about the process to engineering breadcrumbs of varying lengths in this article. Let me explain the motive with an example.


Let us say (more...)

ODI 11g Repository Book Out Now

The book is for free. All you need to do is contact us. We will then send you a PDF version of the book. All we ask you to do is to permanently link from your blog, website, Facebook etc. to our site.

Alternatively, you can buy the book on (more...)

Oracle Endeca Demo Environments

Just a quick note to let you everyone know that the latest version of Endeca is available as a demo environment (hosted by Oracle).

The environment is hosted by Oracle and can be accessed with the credentials below.

URL: http://slc02oku.oracle.com:7101/eid/web
Userid = publicuser@oracle.com
Password = Admin123

Note: (more...)

Running PL/SQL Procedures in Parallel

As your data volumes increase, particularly as you evolve into the big data world, you will be start to see that your Oracle Data Mining scoring functions will start to take longer and longer.  To apply an Oracle Data Mining model to new data is a very quick process. (more...)

Non-running workflows in ODMr 4 EA3

If you are brave enough to be using the early adopter releases of ODMr you may have run into the issue with your workflows not running.

When you go to run your workflow you will get the following window and nothing else happens.

image

To get passed this you will need (more...)

UKOUG TECH13

The UKOUG TECH13 conference is starting on Sunday and this year things a bit different. In previous years there was one big conference that covered (almost) everything and this conference had been in Birmingham.

This year Birmingham has been replaced by Manchester and the conference will focus on Database, Development (more...)

New Oracle Magazines for my Collection

You may or may not know that I have been collecting Oracle Magazines. It all began back when I had my very first job as a graduate consultant with Oracle in Ireland. A few days ago I received a package that contained the following Oracle Magazines.  You will see (more...)

Dodeca 6.6.0.4194 Now Available for Download!

This past Friday, November 22nd, we completed our work on the newest version of the Dodeca Spreadsheet Management System and made Dodeca 6.6.0.4194 available for download from our website.  This blog entry is a sneak peek at some of the new features in version 6.6, as (more...)

Save $250 on Kscope14 Registration Now!

If you work in the Essbase, Oracle EPM, or Oracle BI world, *the* place to be every June is the annual Kscope conference.  Registration is open for the next conference, Kscope14, coming next June in Seattle, WA.  If you are not currently a full ODTUG member, let me tell you (more...)

How To Find Size Of Table In Hive / HDFS

| Nov 19, 2013

Hi All

Volume on BigData being the constant challenge, as an administrator, you will have to keep a tab on the data growth, at the same time you need to make sure there is spurge growth of unwanted objects or folders. Typically you would want to be worried about the (more...)

2014 Oracle User Group Conferences

Over the past few days I've put together a list of Oracle User Group Conferences from around the World that will be on in 2014.

This list is not complete and I’m sure I have left out some very well known conferences.  If I have left a conference out (more...)

Tracking the running reports in OBIEE 11G

 
I faced a rather strange but relatively simple requirement a few days back. The client had employed a resource to refresh the sessions page and capture the running queries from it and mail it to a team that dealt with performance tuning. This is certainly not the most efficient (more...)

Hyperion 11.1.2.3 Update – Kscope14 Street Team Meetup in Seattle – November 8th

If you are in or near Seattle on Friday, November 8th, don't miss the opportunity to see the new features of the Hyperion 11.1.2.3 release.  Oracle representatives are teaming together with the Kscope14 Street Team to bring you this 2-hour mini-session at the Fred Hutchison Cancer Research (more...)

Junk Viz – When More is Less

There are examples of junk visualizations, and then there are examples of junk charts that just take your breath away.

The Indian news portal, FirstPost.in, which describes itself as a "trusted guide to the crush of news and ideas around you", published a story titled Shivraj (more...)

Need ODI Training? Learn Oracle Data Integrator from the experts.

I am proud and delighted to announce that we are now offering ODI classes.

Learn from a combined 18+ years hands on ODI experience and get the following benefits.

Top Quality

Choose world class ODI training from THE ODI gurus. Don’t settle for less.

Value-Priced

Unrivaled in quality AND affordable (more...)

OBIEE 11.1.1.7.131017 Bundle Patch Now Available

A new bundle patch for Oracle Business Intelligence became available last week. This is OBIEE Bundle Patch 11.1.1.7.131017, and is available on the following platforms:
  • HP-UX  Itanium
  • IBM AIX on POWER Systems (64-bit)
  • Linux x86
  • Linux x86-64
  • Microsoft Windows (32-bit)
  • Microsoft Windows (64-bit)
  • Oracle Solaris on (more...)