September 14, 2017

|

by: pete.scott

|

Categories: Oracle 12c, SQL, Tips

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 […]

March 31, 2017

|

by: Phil Goerdt

|

Categories: Exalytics, OBIEE, Oracle 12c, Tips

Red Pill Analytics recently performed the installation of OBIEE 12c on an Exalytics machine for one of our customers. There is no option to use the Domain Management Utility for installing OBIEE 12c… that’s still only capable of installing OBIEE 11g. Therefore OBIEE 12c is a manual install on Exalytics, but it’s very similar to installing OBIEE […]

March 7, 2017

|

by: Phil Goerdt

|

Categories: OBIEE, Oracle 12c, Tips

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 […]

December 20, 2016

|

by: Phil Goerdt

|

Categories: OBIEE, Oracle, Oracle 12c

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 […]

December 13, 2016

|

by: Phil Goerdt

|

Categories: Oracle 12c, Tips

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 […]

August 26, 2016

|

by: Stewart Bryson

|

Categories: OBIEE, Oracle 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 […]

February 29, 2016

|

by: Renee Miller

|

Categories: OBIEE, Oracle 12c

Open the dashboard editor in 12c, you’ll see a few changes. What Changed?? Well, dashboard development has never been the sexiest task, but it is a little simpler now. You can browse to BI content in the Shared Folders, just as you could before, but now you can also browse to dashboard content. In the […]