Rittman Mead Blog - Analytics

Oracle APEX - replacing OAS/OAC/OBI write-back

In today's fast-paced business environment, organisations need powerful and flexible tools to make informed decisions quickly. Oracle Analytics (OAC/OAS), once Business Intelligence (OBI), has long been a reliable choice for business intelligence and analytics. However, as technology evolves, so do the requirements of businesses. One such requirement

analytics

Rittman Mead sponsoring RMOUG

After enjoying a successful 2020 in the North American data and analytics market, we’re excited to announce that we’re sponsoring Rocky Mountain Oracle Users Group (RMOUG) this year! Running from 8th - 11th February, the agenda is jam packed with content including interactive workshops and technical sessions all

OAC

Getting Smart View to work with OAC

I wanted to demonstrate what I thought would be a simple task to a client today, however it turned out to be a little more complex than I first anticipated, so I thought I would publish here. All I needed to do was get Smart View connecting to OAC. Prerequisites

advanced analytics

Timestamp Functions and Presentation Variables in Oracle Cloud Analytics

One of the most popular Rittman Mead blog posts over the last 10 years is Timestamps and Presentation Variables [https://www.rittmanmead.com/blog/2014/12/timestamps-and-presentation-variables/]. As we are seeing more and more migrations to OAC, we decided to review and revise this post for the latest version of

kscope19

Rittman Mead at Kscope 2019

June is time for one of my favourite conferences: Kscope! This year the location is Seattle and the Agenda [https://kscope19.odtug.com/page/speakers-presentations] is impressive. The event starts on Sunday with the Symposiums driven by Oracle Product Managers and divided by stream of interest. The main conference is

OAC

OAC 18.3.3: New Features

I believe there is a hidden strategy behind Oracle's product release schedule: every time I'm either on holidays or in a business trip full of appointments a new version of Oracle Analytics Cloud is published with a huge set of new features! OAC 18.3.3

json

Parsing Badly Formatted JSON in Oracle DB with APEX_JSON

Using APEX_JSON to parse malformed JSON documents allowing the extraction of all the information contained.

OAC

Oracle Analytics Cloud Workshop FAQ

A few weeks ago, I had the opportunity to present the Rittman Mead Oracle Analytics Cloud workshop in Oracle's head office in London. The aim of the workshop was to educate potential OAC customers and give them the tools and knowledge to decide whether or not OAC was

OAC

DevOps in OAC: Scripting Oracle Cloud Instance Management with PSM Cli

This summer we unselfish Italians decided to not participate to the World Cup to give another country the opportunity to win (good luck with that England!). This decision, which I strongly support, gives me lot of time for blogging! As already written, two weeks ago while in Orlando for Kscope18

got

The Week After: Game of Thrones S07 E06 Tweets and Press Reviews Analysis

Another week is gone, another "Game of Thrones" episode watched, only one left until the end of the 7th series. The "incident" [http://www.independent.co.uk/arts-entertainment/tv/news/game-of-thrones-season-7-episode-6-leaks-online-full-hbo-spain-torrents-download-reddit-watch-jon-a7895636.html] in Spain, with the episode released for few hours on Wednesday screwed all my

analytics

Analyzing Wimbledon Twitter Feeds in Real Time with Kafka, Presto and Oracle DVD v3

Last week there was Wimbledon, if you are a fan of Federer, Nadal or Djokovic then it was one of the events not to be missed. I deliberately excluded Andy Murray from the list above since he kicked out my favourite player: Dustin Brown. Two weeks ago I was at

DVD

Oracle Data Visualization Desktop v3

The ODTUG Kscope17 [http://kscope17.com] conference last week in San Antonio was a great event with plenty of very interesting sessions and networking opportunities. Rittman Mead participated during the thursday deep dive BI session and delivered three sessions [https://www.rittmanmead.com/blog/2017/06/rittman-mead-at-kscope-2017/] including a special

Tableau

Getting Smarter in Renting with Tableau 10

Preface Not a long time ago a friend of mine spent a significant amount of time trying to find a flat to rent. And according to what he said it wasn't an easy task. It took him a decent time and efforts to find something that is big

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

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

Technical

Connecting Oracle Data Visualization Desktop to OBIEE

Recently at Rittman Mead we have been asked a lot of questions surrounding Oracle’s new Data Visualization Desktop tool and how it integrates with OBIEE. Rather than referring people to the Oracle docs on DVD, I decided to share with you my experience connecting to an OBIEE 12c instance

Technical

Oracle's New Data Visualization Desktop

A recent addition to the Oracle lineup of visualization tools is the Oracle Data Visualization Desktop. Described by Oracle as a “single user desktop application that provides Oracle Data Visualization functionality to business users,” DVD is an easy-to-install data visualization tool for Windows 7, 8 or 10 that packs some

Big Data

OBIEE 12c - Your Answers After Upgrading

Several blogs have already been written about new functionality in OBIEE 12c. Mark Rittman, for example, posted a good one here [https://www.rittmanmead.com/blog/2015/10/oracle-business-intelligence-12c-now-available-improving-agility-and-enabling-self-service-for-bi-users/] . Now, I've personally had the chance to play with it for a few weeks, mostly in Answers and some

Big Data

Introduction to Oracle R Training

Rittman Mead is thrilled to announce our new Introduction to Oracle R courses! With the launch of 12c comes an exciting extension to OBIEE’s analytical capabilities—embedded R execution. Oracle has made several investments in the R language and its related technologies (Oracle R, ROracle, ORAAH, and Oracle R

Big Data

Upgrade to ODI 12c: Repository and Standalone Agent

This is my first post, and I hope to have many more to come. My name is Brian Sauer, and I am fairly new here at Rittman Mead and proud to be here. I have close to 5 years of experience with Oracle Data Integrator, both 10g and 11c. I

Technical

Introducing the Rittman Mead OBIEE Performance Analytics Service

Fix Your OBIEE Performance Problems Today OBIEE is a powerful analytics tool that enables your users to make the most of the data in your organisation. Ensuring that expected response times are met is key to driving user uptake and successful user engagement with OBIEE. Rittman Mead can help diagnose