Cloud

OAC: Essbase – Loading Data

After my initial quick pass through Essbase under OAC here [https://www.rittmanmead.com/blog/2017/06/oac-essbase-and-dvcs/], this post looks at the data loading options available in more detail. I used the provided sample database ASOSamp.Basic, which first had to be created, as a working example. Creating ASOSamp

Technical

Exploring the Rittman Mead Insights Lab

What is our Insights Lab? The Insights Lab offers on-demand access to an experienced data science team, using a mature methodology to deliver one-off analyses and production-ready predictive models. Our Data Science team includes physicists, mathematicians, industry veterans and data engineers ready to help you take analytics to the next

Tableau

Using Tableau to Show Variance and Uncertainty

Recently, I watched an amazing keynote presentation from Amanda Cox [https://openvisconf.com/#acox-video-item] at OpenVis. Toward the beginning of the presentation, Amanda explained that people tend to feel and interpret things differently. She went on to say that, “There’s this gap between what you say or what you

OBIEE12c

OBIEE 12c Catalog Validation: Command Line

I wrote a blog post [https://www.rittmanmead.com/blog/2016/11/performing-a-catalog-validation/] a while ago describing the catalog validation: an automated process performing a consistency check of the catalog and reporting or deleting the inconsistent artifacts. In the post I stated that catalog validation should be implemented regularly as

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

Kscope17

Rittman Mead at Kscope 2017

Rittman Mead will be well represented in San Antonio, Texas next week for Kscope 17 with some of our best from both sides of the Atlantic! Our very own Francesco Tisiot and Jordan Meyer will present various topics as well as participate in the conference events. Also, the newly named

Unify

Unify: Could it be any easier?

Rittman Mead’s Unify is the easiest and most efficient method to pull your OBIEE reporting data directly into your local Tableau environment. No longer will you have to worry about database connection credentials, Excel exports, or any other roundabout way to get your data where you need it to

Unify

Unify - An Insight Into the Product

Monday, 12 Jun [https://www.rittmanmead.com/blog/2017/06/unify-see-your-data-from-every-perspective/] saw the official release of Unify [https://unify.ritt.md], Rittman Mead's very own connector between Tableau and OBIEE. It provides a simple but powerful integration between the two applications that allows you to execute queries through

Tableau

Unify: See Your Data From Every Perspective

Ad hoc access to accurate and secured data has always been the goal of business intelligence platforms. Yet, most fall short of balancing the needs of business users with the concerns of IT. Rittman Mead has worked with hundreds of organizations representing all points on the spectrum between agility and

Cloud

OAC: Essbase and DVCS

Finally managed to get around to having a proper look at Essbase within Oracle Analytics Cloud Service (OAC) after a busy couple of months. This post focusses mainly on initial impressions on the ‘out of the box’ the Essbase side of this - which we will explore in more detail

Cloudera

Overview of the new Cloudera Data Science Workbench

Recently Cloudera released a new product called Cloudera Data Science Workbench [https://www.cloudera.com/products/data-science-and-engineering/data-science-workbench.html] (CDSW) Being a Cloudera Partner, we at Rittman Mead are always excited when something new comes along. The CDSW is positioned as a collaborative platform for data scientists/engineers and analysts,

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 upgrades and Windows vulnerabilities

These two topics may seem unrelated; however, the ransomware attacks [http://www.bbc.co.uk/news/technology-39915440] over the last few days provide us with a reminder of what people can do with known vulnerabilities in an operating system. Organisations consider upgrades a necessary evil; they cost money, take up

OBIEE12c

A focus on Higher Education, HEDW 2017

First, before I get into a great week of Higher Education Data Warehousing and analytics discussions, I want to thank the HEDW board and their membership. They embraced us with open arms in our first year of conference sponsorship. Our longtime friend and HEDW board member, Phyllis Wykoff, from Miami

Oracle Data Integrator

The Case for ETL in the Cloud - CAPEX vs OPEX

Recently Oracle announced [https://www.oracle.com/corporate/pressrelease/launches-integration-cloud-service-021317.html] a new cloud service for Oracle Data Integrator. Because I was helping our sales team by doing some estimates and statements of work, I was already thinking of costs, ROI, use cases, and the questions behind making a decision

Impala

SQL-on-Hadoop: Impala vs Drill

I recently wrote a blog post about Oracle's Analytic Views [https://www.rittmanmead.com/blog/2017/04/metadata-modeling-in-the-database-with-analytic-views/] and how those can be used in order to provide a simple SQL interface to end users with data stored in a relational database. In today's post I&

Technical

OBIEE Component Status Notifications

At Rittman Mead, we often hear requests for features or solutions generally not provided by Oracle. These requests range from commentary functionality to custom javascript visualizations. There are many ways to implement these functionalities, but organizations often lack the in-house resources to engineer an acceptable solution. Rittman Mead has the

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

Real World OBIEE: Demystification of Variables Pt. 3

In part two [https://www.rittmanmead.com/blog/2017/03/real-world-obiee-demystification-of-variables-pt-2/] of this blog series, I went over using Repository, System and Presentation Variables to make reports dynamic for any series of time. In part three, I am going to talk about making reports dynamic for periods of time using

Real World OBIEE: Demystification of Variables Pt. 2

In part one [https://www.rittmanmead.com/blog/2017/03/real-world-obiee-demystification-of-variables-pt-1/] of this blog series, I went over using bins and presentation variables to dynamically create groups and switch between them in a report and on a dashboard. In part two, I am going to talk about making reports dynamic

performance analytics

A Performance Analytics Application Case Study: Challenges and Successes

The Performance Analytics application is a collection of open source technologies that aids users in: identifying performance bottlenecks, identifying causes for slow report execution, discovering areas for performance optimization, and gathering meaningful insights into the health of an OBIEE environment. This post focuses on lessons learned after a successful Performance

property graph

Property Graph in Oracle 12.2

The latest release of Oracle (12.2) includes support for Property Graph, previously available only as part of the Big Data Spatial and Graph tool. Unlike the latter, in which data is held in a NoSQL store (Oracle NoSQL, or Apache HBase), it is now possible to use the Oracle

odi12c

Accelerating Your ODI Implementation, Rittman Mead Style

Introduction Over the years, at Rittman Mead, we've built up quite a collection of tooling for ODI. We have accelerators, scripts, reports, templates and even entire frameworks at our disposal for when the right use case arises. Many of these tools exploit the power of the excellent ODI

DVD

Create Your Own DVD Plugin in 22 minutes

Introduction Oracle DVD played well for the task of elections data analysis [https://www.rittmanmead.com/blog/2017/02/analysing-elections-data-with-oracle-data-visualisation-desktop] . But I faced some limitations and had to curtail my use of one of my favourite charts - Scatter chart. While DVD’s implementation of it looks good, has smooth