Rittman Mead Blog - Oracle Corporation

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

ThanksODC

ODC Appreciation Day: Oracle Cloud PSM Cli

Oracle Developer Community (ODC) Appreciation Day [https://oracle-base.com/blog/2018/09/27/oracle-developer-community-odc-appreciation-day-2018-thanksodc/] (previously know as OTN Appreciation Day) is a day, started from an initiative of Tim Hall [https://oracle-base.com], where everyone can share their Thanks to the Oracle community by writing about a favourite product, an

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

odtug

Rittman Mead at Kscope 2018

Kscope 2018 is just a week away! Magnificent location (Walt Disney World Swan and Dolphin Resort [https://www.swandolphin.com/groupres/KSCNR/]) for one of the best tech conferences of the year! The agenda is impressive (look here [https://kscope18.odtug.com/page/presentations]) spanning over ten different tracks from

obiee

Rittman Mead at OUG Norway 2018

This week I am very pleased to represent Rittman Mead by presenting at the Oracle User Group Norway [http://ougn.no] Spring Seminar 2018 delivering two sessions about Oracle Analytics, Kafka, Apache Drill and Data Visualization both on-premises and cloud. The OUGN conference it's unique due to both

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

Oracle

First Steps with Oracle Analytics Cloud

Preface Not long ago Oracle added a new offer to their Cloud - an OBIEE in a Cloud with full access. Francesco Tisiot made an overview [https://www.rittmanmead.com/blog/2017/04/oracle-analytics-cloud-product-overview/] of it and now it's time to go a bit deeper and see how

obiee

Oracle Analytics Cloud: Product Overview

We at Rittman Mead are always helping our customer solving their problems, many times we heard them * being unsure about the sizing of their server * being worried about the upfront cost of the licensing * having recurring nightmares about patching * willing to try the cloud but couldn't find the

Oracle

Metadata Modeling in the Database with Analytic Views

12.2 [http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html] , the latest Oracle database release provides a whole set of new features [https://docs.oracle.com/en/cloud/paas/exadata-express-cloud/csdbf/oracle-database-12-2-new-features.html#GUID-D0673E3E-DF05-47C3-B1E2-BEF91FA36CEF] enhancing various aspects of the product including JSON support, Auto-List Partitioning and APEX news

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)"

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

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

OBIEE12c

Performing a 12c Upgrade with a New Install

Software updates often include new features, and while useful, these new features are often the only driving factors in upgrading software. There's no harm in wanting to play around with the shiny new toy but many software updates also include much more significant changes, such as resolving bugs

ODVD

Data Visualization Desktop 12.2.2.0: Data Flow Component

My previous post [https://www.rittmanmead.com/blog/2016/10/data-visualisation-desktop-12-2-2-0-new-features-2/] contained a brief description of Data Visualization Desktop (DVD) new features in 12.2.2.0, in terms of sources, visualisations and components. In this post we're going to simulate a typical analyst use case and understand

ODVD

Data Visualization Desktop 12.2.2.0

Yesterday Data Visualization Desktop (DVD) Version 12.2.2.0 [http://www.oracle.com/technetwork/middleware/oracle-data-visualization/downloads/oracle-data-visualization-desktop-2938957.html] was released. DVD, since its first release, aims to extend Oracle's Data Visualization portfolio by adding a desktop tool allowing data visualization capabilities directly to end users without

obiee

OTN Appreciation Day : OBIEE's BI Server

Oracle Technology Network [http://www.oracle.com/technetwork/index.html] (OTN) is one you'll be familiar with if you do anything with Oracle software, from downloading the installers [http://www.oracle.com/technetwork/indexes/downloads/index.html], reading the documentation [http://www.oracle.com/technetwork/indexes/documentation/index.

Technical

Becky's BI Apps Corner: OBIA Back-to-Beginnings - Naming Conventions and Jargon

It's easy to talk about a technology using only jargon. It's much harder to talk about a technology without using jargon. I have seen many meetings between business and IT break down because of this communication barrier. I find it more discouraging when I see this

hdfs

An Introduction to Apache Drill

Apache Drill [https://drill.apache.org/] is an engine that can connect to many different data sources, and provide a SQL interface to them. It's not just a wanna-be SQL interface that trips over at anything complex - it's a hugely functional one [https://drill.apache.

Technical

OBIEE 12.2.1.1.0 - New Feature Guide

Oracle has recently released version 12.2.1.1.0 [http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/business-intelligence-3046226.html] for OBIEE 12c, which has a variety of exciting new features for Data Visualization, BI Publisher, Dashboards in OBIEE, and ODBC connections. It can be performed as an in-place upgrade

obiee

Announcing OBI Remote Training

Since the release of OBIEE 12c in 2015, we have received countless inquiries about how we would be offering our training. Our customers are familiar with our ability to provide on-site private training for a team and we are well known for hosting training classes in our offices in the

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

Rittman Mead at Collaborate 16: Data Integration Focus

It’s that time of year again when Oracle technologists from around the world gather in Las Vegas, Nevada, to teach, learn, and, of course, network with their peers. TheCollaborate 16 [http://collaborate.ioug.org/]conference, running for 10 years now, has been a collaboration, if you will, between the

Technical

New OTN Article - OBIEE Performance Analytics: Analysing the Impact of Suboptimal Design

I’m pleased to have recently had my first article published on the Oracle Technology Network (OTN) [http://www.oracle.com/technetwork/index.html]. You can read it in its full splendour and glory(!) over there [https://community.oracle.com/docs/DOC-993649], but I thought I’d give a bit

Technical

The Importance of BI Documentation

Why Is BI Documentation Important? Business intelligence systems come with a lot of extra information. Even beautifully constructed analyses have piles of background information and histories. Administrators might often have memos and updates that they’d like share with analysts. Sales figures might have anomalies that need further explanation. But