Technical

Real World OBIEE: Demystification of Variables Pt. 1

OBIEE has some very powerful features and capabilities when it comes to how we visualize and present our data. There are some features which almost everyone uses (filters, prompts, rename columns ect.) and then some that are less common. In part, I think there is a lot of "noise&

Performance

New Performance Analytics Release

Poor performance is one of the most common complaints we hear upon arrival to customer sites, and often for good reason. When users have time to “make the rounds” before the system returns a result (if it returns a result at all), they have the right to be frustrated. Unfortunately,

obiee

OBIEE 11.1.1.7: Is It Still Supported?

Last week, during a quiet working morning, my colleague Robin Moffatt [https://www.rittmanmead.com/blog/author/robin-moffatt/] sent me a link that changed my working focus for few hours. The link was to "OBIEE 11g: Required and Recommended Bundle Patches and Patch Sets (Doc ID 1488475.1)"

DVD

Data Preparation for "Analysing Elections Data with Oracle Data Visualisation Desktop"

In the previous post [https://www.rittmanmead.com/blog/2017/02/analysing-elections-data-with-oracle-data-visualisation-desktop/] I wrote about some interesting insights we can get from the elections data. And this post concentrates on the data preparation for it. As the first one, it doesn't work as a guide and aimed to

DVD

Analysing Elections Data with Oracle Data Visualisation Desktop

Disclaimer #1 This post is not about politics. Its dataset is about politics, but that's a coincidence. It could be about immunisation or transport or anything else. If you are strictly against any politics, here is a link to watch cute kittens [https://www.google.ru/search?q=

time series

OBIEE 12c Time Dimension: Logical Sequence Number

The key component of any successful OBIEE implementation is the metadata model known as the repository (RPD). Doing it right is sometimes considered "black magic", and small mistakes in the RPD can impact all the exposed Subject Areas, resulting in poor performances or, even worse, wrong results. Working

training

Introducing Advanced Analytics Training from Rittman Mead!

Rittman Mead is proud to release our new training course: Advanced Analytics with Oracle's R Technologies [https://www.rittmanmead.com/advanced-analytics-oracle-r/]. Oracle has made significant investments in the R language with Oracle R, ROracle and Oracle R Enterprise. Using these tools, data scientists and business intelligence practitioners can

OBIEE12c

Financial Reports - which tool to use? Part 2

Financials in BI Publisher## I find it interesting that BI Publisher is mostly known for the creation of pixel perfect repeating forms (invoices, labels, checks, etc) and its ability to bursting them. To me, BI Publisher is the best kept secret for the most challenging reports known to mankind. In

OBIEE12c

Financial Reports - which tool to use? Part 1

One of the treats of working in the Business Intelligence world is that we are asked to analyze different aspects of a business. In fact, we are asked to analyze many different types of businesses, too. Most of us using BI tools have come from some previous background. Be it

obiee

Enabling Concurrent OBIEE RPD Development - for free

One of the most common and long standing problems with developing in OBIEE is the problem of multiple developers working on the RPD at the same time. This blog explains the problem and explores the solution that we’ve developed and have been successfully using at clients over the last

obiee

Working with OBIEE Data in Excel using ODBC

Look at this picture. I'm sure you've recognised the most favourite data analysis tool of all times - Excel. But what you can't see in this picture is the data source for the table and charts. And this source is OBIEE's BI

Conferences

Join Rittman Mead at the 2017 BIWA Summit!

We invite you to come join us at the annual 2017 BIWA Summit [http://www.biwasummit.org/]. This year we are proud to announce that Robin Moffatt, Head of Research and Development, will be presenting on: Analysing the Panama Papers with Oracle Big Data Spatial and Graph January 31, 2017

training

What's new in Training in 2017?

2016 - Thank you for a great year! Rittman Mead would like to thank everyone that attended or showed an interest in our Training courses in 2016. Since we started back in 2007, Training has been a mainstay of our service offerings. My personal opinion is that Q3 & Q4

Conferences

Rittman Mead at BIWA Summit 2017

I'm excited to be attending my first ever BIWA Summit [http://www.biwasummit.org/sessions/] next week (which will take me to Oracle HQ at Redwood Shores for the first time too!). This three day conference is one of the major dates in the conference calendar for all

training

Race Against the Machine - Skilling in the Name

Firstly apologies for the awful title. We’ll see by the end of this post whether the pun works! At Rittman Mead we see the Data & Analytics market and indeed the broader technology market continually changing. Investment in technology to move organisations ahead of their competitors seems higher than

kibana

Time Series Visualisations: Kibana or Grafana?

Grafana [http://grafana.org/] has rapidly become one of the de-facto “DevOps” tools for real time monitoring dashboards of time series metrics. In addition to its powerful visualisations, Grafana is not tied to a particular stack or vendor, and supports multiple backend data sources including InfluxDB [https://www.influxdata.com/

Oracle

Analyse Your Data on the Go with Oracle Synopsis App

How many times did you receive an email on your phone with an Excel or CSV attachment you wanted to analyse immediately in an app on your mobile, without having to wait until you reach the laptop? Not only viewing raw numbers but also creating graphs and summaries with the

Spark Streaming

Data Processing and Enrichment in Spark Streaming with Python and Kafka

In my previous blog post [https://www.rittmanmead.com/blog/2017/01/getting-started-with-spark-streaming-with-python-and-kafka/] I introduced Spark Streaming and how it can be used to process 'unbounded' datasets. The example I did was a very basic one - simple counts of inbound tweets and grouping by user. All very

spark

Getting Started with Spark Streaming, Python, and Kafka

Last month I wrote a series of articles [https://www.rittmanmead.com/blog/2016/12/etl-offload-with-spark-and-amazon-emr-part-5/] in which I looked at the use of Spark for performing data transformation and manipulation. This was in the context of replatforming an existing Oracle-based ETL and datawarehouse solution onto cheaper and more elastic

obiee

Web-Based RPD Upload and Download for OBIEE 12c

I was among the people who were dancing and singing after finding out some of the OBIEE 12c new features. The feature I liked the most was a scripted deploy of an RPD file from a developer’s computer. I hate to make dozens of clicks for every deploy of

odi

ETL Offload with Spark and Amazon EMR - Part 5 - Summary

This is the final article in a series documenting an exercise that we undertook for a client recently. Currently running an Oracle-based datawarehouse platform, the client asked for our help in understanding what a future ETL and reporting platform could look like, given the current landscape of tools available. You

ETL Offload with Spark and Amazon EMR - Part 4 - Analysing the Data

We recently did a project we did for a client, exploring the benefits of Spark-based ETL processing running on Amazon's Elastic Map Reduce (EMR) Hadoop platform. The proof of concept we ran was on a very simple requirement, taking inbound files from a third party, joining to them

emr

ETL Offload with Spark and Amazon EMR - Part 3 - Running pySpark on EMR

In the previous articles (here [https://www.rittmanmead.com/blog/2016/12/etl-offload-with-spark-and-amazon-emr-part-1], and here [https://www.rittmanmead.com/blog/2016/12/etl-offload-with-spark-and-amazon-emr-part-2-code-development-with-notebooks-and-docker/] ) I gave the background to a project we did for a client, exploring the benefits of Spark-based ETL processing running on Amazon's Elastic Map Reduce

spark

ETL Offload with Spark and Amazon EMR - Part 2 - Code development with Notebooks and Docker

In the previous article [https://www.rittmanmead.com/blog/2016/12/etl-offload-with-spark-and-amazon-emr-part-1/] I gave the background to a project we did for a client, exploring the benefits of Spark-based ETL processing running on Amazon's Elastic Map Reduce (EMR) Hadoop platform. The proof of concept we ran was on

obiee

ETL Offload with Spark and Amazon EMR - Part 1 - Introduction

We recently undertook a two-week Proof of Concept exercise for a client, evaluating whether their existing ETL processing could be done faster and more cheaply using Spark. They were also interested in whether something like Redshift [http://docs.aws.amazon.com/redshift/latest/mgmt/welcome.html] would provide a suitable