Here Comes Summer

Spring is here, Have you not noticed going to work in daylight?  Of course I am referring to the Northern Hemisphere.  For those down under now is the time to pack your bags and head north to the sun.

There are many things you can get online, soo much fun to be had coding OBIEE, playing PS4 (look out for Club OBIEE on drive club), shopping, skyping, etc BUT you can’t get Physical weather, proper contact with friends and family, risking limb skiing, the smell of the sea, and the feeling of the sun on your faces.

So, read the articles below, then go outside and live a little before it’s too late…

BTW One way to mix OBIEE and the sun is to head over to Miami for the ODTUG conference in June.  See you there..

Blogs of the week

1.  Simplifying ETL : Part1 – Overview

Umesh Kakkad writes, “This entry is the first installment of a series where we plan to share the ETL framework and standards, reusable utilities and general guidelines that Just Analytics has developed over multiple years of experience in executing small to large size BI/DW projects.”

He says that the next few entries will cover:

  • JBS (Job Management system)
  • Oracle to Oracle data loading utility
  • Data Quality and Reconciliation Framework
  • Post Load Processing (PLP) Engine


Mitul Patel says, “The term application deployment refers to the process of making an application or module available for processing client requests in a WebLogic Server domain. Application deployment generally involves the following tasks.”

  • Preparing Applications and Modules for Deployment
  • Configuring Applications for Production Deployment
  • Exporting an Application for Deployment to New Environments
  • Deploying Applications and Modules with weblogic.Deployer
  • Redeploying Applications in a Production Environment
  • Managing Deployed Applications

Read the full blog for more information.

3. KPI Partners Joins Oracle for Big Data Discovery Fast Track Program

“The Oracle Fast Track Partner Program for Big Data Discovery will help us enhance the value of KPI Partners consulting services for organizations who use Hadoop,” said Sid Goel, Co-Founder. “KPI offers a broad set of services that enable users transform raw data into business insight in minutes. Joining the Oracle Fast Track Partner Program for Big Data Discovery provides us with a range of technical, go-to-market, and support benefits to serve our customers.”

4. Perception of Colors of Dresses and Data Visualization

Dan Vlamis writes, “Finally, people are talking about color perception! Everybody is talking about the white/gold/blue/black dress that has gone viral as people discover that color perception is not absolute. We cover this in our recent Oracle Press book on Data Visualization for Oracle Business 11g. From page 273: ‘We the authors often show a handful of optical illusions involving color perception/misperception during our data visualization workshops to drive home the point that we humans don’t see color as much as we “experience” it as our brains attempt to construct a color model for a given situation.”


5. OBIEE Answers Another Great Print Options

Steve Yeung blogs, “Continuing from my on PDF Print with Page Breaks, I’ll expand on some other great features and a hidden command for print options.”

He looks at:

1. Creating a Sample Answer

2. Print Options

3. PDF Footer results

6. OBIEE – Selecting columns dynamically – part2, simple Prompt

Boris Dahav says, “In previous post I talked about column selectors. They are not enough in complex cases, for example:

  • Single selection of columns for several reports.
  • Using the same column selection in several columns of the same analysis.
  • Dependency between selection of columns (for example, I can select “Target Revenue” in measures only if “Year” selected in one of the dimensions.)
In this post I will create an example where selecting a column from prompt would influence 2
columns in analysis.”

Bojie He blogs, “What does Python have to do with BI report? Well maybe not much directly in enterprise environment, but python can be very useful for my garage project. I want to build a Data visualization product that shows real time update of certain market driven products and get users to subscribe to it for a monthly fee, that’s what python can be handy for my ETL process.”

8.  US President talks about Data Science

In this video, the video of US President talks about Data Science and the first Chief Data Scientist of the USA talks about his mission:


Kashinathan K says, “Oracle Flashback technology was introduced in Oracle 9i and added on to higher version. It provides a set of features using which we can view as well as recover data from Logical corruptions. Most of the Flashback technologies depend on the available UNDO data to retrieve older data. Some of the Advantages of Flashback Technology are faster database point in time recovery and less performance overhead.”

10. Part 2 – Why SQL is the natural language for data analysis

Keith Laker writes about ‘powerful framework’ in this blog post.

He looks at four basic principles:

  1. Projection
  2. Filter
  3. Join
  4. Aggregate

He says, “In my next post, which will probably appear towards the end of this week, I will explore why SQL’s transparent optimization is such a critical feature. ”

This week on Twitter

Gokhan Atil tweeted Oracle Private Database Cloud REST APIs

Boris Dahav shared OBIEE – Selecting columns dynamically – part2, simple Prompt posted Running two oracle installations from the same terminal

This week on LinkedIn

Ian Bristow shared Business Analytics Monthly Index – February 2015

Hemanta Banerjee posted Simplifying ETL : Part1 – Overview

Sanket Suri posted OBIEE Advance Analytics Video Tutorials

Stories from Oracle Database.

Videos such as Understanding the Oracle Social Network Web Client

and Webinar: A Mix of Art & Science: How to Achieve High Performance Business Intelligence