Joining it all up

Joining It All Up

When I start a new ETL project I often find it useful to have some idea how the source tables relate to each other. If I’m lucky there is documentation to guide me or even a diagram showing me how the tables link up (I do dream a lot). Of course, I could pull the […]

Read More

Which Version Was It Again?

Recently I had to verify the version of an OBIEE installation for a client. As I was already ssh-ed into the Linux machine, I figured there was a way to determine the version without having to log into the presentation server. Turns out, I was right, but for thoroughness sake, I’ll cover both approaches. Using […]

Read More

Cluster Func 

Clustering. Whether we’re talking about headaches, compute nodes, or uh, well, I’ll let you fill in the blank… isn’t anything worth doing, worth doing together? Clustering can be a powerful tool for understanding the relationships between data, and in this post I’ll walk through how to use the OBIEE 12c Advanced Analytics Cluster Function. As […]

Read More

Trending Up

Trending Up Using the Trend Line Function in OBIEE 12c One of the new features in OBIEE 12c is the availability of an “internal” R instance. This instance will allow the execution of R scripts, and the folks at Oracle have been kind enough to include some functions out of the box with the OBIEE 12c […]

Read More

OTN Appreciation Day: Oracle Data Integrator 12c Flexibility

Well… it looks like Oracle ACE Director and former colleague Michael Rainey beat me to the topic. But as I read his story… I realized I could approach this in a slightly different way, so I decided to press on with my own take on ODI 12c Flexibility for Oracle Technology Network (OTN) Appreciation Day. […]

Read More

Groovy, Web Services and OBIEE 12c

If you’ve followed me for any length of time, you know I’m a fan of the Groovy language. It’s unfettered support for closures has made it a popular choice for writing domain-specific language (DSL) projects such as Gradle and Jenkins, and the healthy dose of syntactic sugar spooned in at runtime means that developers spend less time boiler-plating and more time […]

Read More

Does Oracle Database 12c Just Not Work on Windows?

I’m super-excited about a presentation I’m giving with Kellyn PotVin-Gormanat RMOUG Training Days next month, called Performance Analytics: Visualizing the Power of the AWR Warehouse. Alright… if you insist… I’ll give a quick plug. Kellyn and the team have been working to build the AWR Warehouse component of Enteprise Manager to store Automatic Workload Repository (AWR) history for the […]

Read More
Page 1 of 212