Rittman Mead Blog - Oracle BI Suite EE

Rittman Mead's Development Cluster, EM12c and the Blue Mendora VMware EM Plugin

For development and testing purposes, Rittman Mead run a VMWare VSphere cluster made up of a number of bare-metal servers hosting Linux, Windows and other VMs. Our setup has grown over the years from a bunch of VMs running on Mac Mini servers [https://www.rittmanmead.com/blog/2013/08/

Technical

Enable Your Dashboard Designers to Concentrate on User Experience Rather Than Syntax (or How to Add a Treemap in Two Lines)

JavaScript is a powerful tool that can be used to add functionality to OBIEE dashboards. However, for many whose wheelhouses are more naturally aligned with Stephen Few [http://www.amazon.com/Stephen-Few/e/B001H6IQ5M] rather than John Resig [http://ejohn.org/about/], adding JavaScript to a dashboard can be intimidating.

Technical

Concurrent RPD Development in OBIEE

OBIEE is a well established product, having been around in various incarnations for well over a decade [https://www.rittmanmead.com/blog/2007/09/a-potted-history-of-oracle-bi-suite-enterprise-edition/]. The latest version, OBIEE 11g, was released 3.5 years ago, and there are mutterings of OBIEE 12c already [https://www.rittmanmead.com/blog/2014/

Technical

Using Oracle Big Data SQL to Add Dimensions and Attributes to Hadoop Reporting

In a previous post I looked at using Oracle’s new Big Data SQL product with ODI12c [https://www.rittmanmead.com/blog/2014/10/using-oracle-big-data-sql-odi12c-hive/], where I used Big Data SQL [http://www.oracle.com/us/products/database/big-data-sql/overview/index.html] to expose two Hive tables as Oracle external

Technical

Connecting OBIEE11g on Windows to a Kerberos-Secured CDH5 Hadoop Cluster using Cloudera HiveServer2 ODBC Drivers

In a few previous posts and magazine articles [http://www.oracle.com/technetwork/issue-archive/2014/14-sep/o54ba-2279189.html] I’ve covered connecting OBIEE11g to a Hadoop cluster [https://www.rittmanmead.com/blog/2014/01/obiee-11-1-1-7-cloudera-hadoop-hiveimpala-part-2-load-data-into-hivehcatalog-analyze-using-impala/] , using OBIEE 11.1.1.7 and Cloudera CDH4 and CDH5 as the examples. Things

Technical

OBIEE and ODI on Hadoop : Next-Generation Initiatives To Improve Hive Performance

The other week I posted a three-part series (part 1 [https://www.rittmanmead.com/blog/2014/12/going-beyond-mapreduce-for-hadoop-etl-pt-1-why-mapreduce-is-only-for-batch-processing/] , part 2 [https://www.rittmanmead.com/blog/2014/12/going-beyond-mapreduce-for-hadoop-etl-pt-2-introducing-apache-yarn-and-apache-tez/] and part 3 [https://www.rittmanmead.com/blog/2014/12/going-beyond-mapreduce-for-hadoop-etl-pt-3-introducing-apache-spark/] ) on going beyond MapReduce for Hadoop-based ETL, where I l

Technical

Rittman Mead BI Forum 2015 Call for Papers Now Open!

I’m very pleased to announce that the Call for Papers for the Rittman Mead BI Forum 2015 [https://docs.google.com/a/rittmanmead.com/forms/d/18XWPmrzr3te55rloDJyB8vFP9j8AUNKKryvOToGHBlA/viewform] is now open, with abstract submissions open to January 18th 2015. As in previous years the BI Forum will run over

Technical

OBIEE SampleApp v406 Amazon EC2 AMI - available for public use

I wrote a while ago about converting Oracle's superb OBIEE SampleApp from a VirtualBox image into an EC2-hosted instance [https://www.rittmanmead.com/blog/2014/09/obiee-sampleapp-in-the-cloud-importing-virtualbox-machines-to-aws-ec2/] . I'm pleased to announce that Oracle have agreed for us to make the image (AMI) on Amazon available publicly.

Technical

Rittman Mead anuncia su catálogo de cursos en Español y en Portugués.

[https://www.rittmanmead.com/blog/content/images/2016/05/07698Spanish_Portuguese_Training.png] [http://www.rittmanmead.com/rittman-mead-announces-its-training-catalog-in-spanish-and-portuguese/] [http://www.rittmanmead.com/rittman-mead-anuncia-o-seu-catalogo-de-cursos-em-espanhol-e-em-portugues/] Tenemos el agrado de anunciarles que desde ahora Rittman Mead ofrece su catálogo completo de cursos en Español y en Portugués. Esta es una gran noticia para

Technical

Auditing OBIEE Presentation Catalog Activity with Custom Log Filters

A question that I’ve noticed coming up a few times on the OBIEE OTN forums goes along the lines of “How can I find out who deleted a report from the Presentation Catalog?”. And whilst the BI Server’s Usage Tracking is superb for auditing who ran what report,

Technical

Monitoring OBIEE with Elasticsearch, Logstash, and Kibana

Monitoring the health of an OBIEE system and diagnosing problems that may occur is a vital task for the system’s administrator and support staff. It’s one that at Rittman Mead we help customers with implementing themselves, and also provide as a managed service [http://www.rittmanmead.com/support/

Technical

News and Updates from Oracle Openworld 2014

It’s the Saturday after Oracle Openworld 2014 [http://www.oracle.com/openworld], and I’m now home from San Francisco and back in the UK. It’s been a great week as usual, with lots of product announcements and updates to the BI, DW and Big Data products we

Technical

EPM and BI Meetup at Next Week's Openworld (and details of our Oracle DI Speakeasy)

Just a short note to help publicise the Oracle Openworld 2014 EPM and BI Meetup [http://www.meetup.com/Oracle-Open-World-Essbase-EPM-meetup/events/205491072/] that’s running next week, organised by Cameron Lackpour and Tim Tow from the ODTUG board. This is an excellent opportunity for EPM and BI developers and customers

Technical

Introduction to Oracle BI Cloud Service : Service Administration

Earlier in the week we’ve looked at the developer features within Oracle BI Cloud Service (BICS), aimed at departmental users who want the power of OBIEE 11g without the need to stand-up their own infrastructure. We looked at the process of uploading spreadsheets and other data to the Oracle

Technical

Introduction to Oracle BI Cloud Service : Building Dashboards & Reports

This week we’ve been looking at the new Oracle BI Cloud Service (BICS), the cloud version of OBIEE11g that went GA at the start of this week. Rittman Mead were part of the beta program for BICS and spend a couple of weeks building a sample BICS application to

Technical

Introduction to Oracle BI Cloud Service : Creating the Repository

Earlier in this series we’ve looked at the overall product proposition for Oracle BI Cloud Service (BICS) [https://www.rittmanmead.com/blog/2014/09/introduction-to-oracle-bi-cloud-service-product-overview/] , and how you upload data to the Database Schema Service [https://www.rittmanmead.com/blog/2014/09/introduction-to-oracle-bi-cloud-service-provisioning-data/] that comes with it. Today, we’

Technical

Introduction to Oracle BI Cloud Service : Provisioning Data

In the first post in this series I looked at the new Oracle BI Cloud Service [https://cloud.oracle.com/business_intelligence], which went GA over the weekend and which Rittman Mead have been using these past few weeks as part of a beta release. In the first post I

Technical

Introduction to Oracle BI Cloud Service : Product Overview

Long-term readers of this blog will probably know that I’m enthusiastic about the possibilities around running OBIEE in the cloud [https://www.rittmanmead.com/blog/2013/11/thoughts-on-running-obiee-in-the-cloud-part-1-the-bi-platform/] , and over the past few weeks Rittman Mead have been participating in the beta program for release one of Oracle’s

Technical

OBIEE SampleApp in The Cloud: Importing VirtualBox Machines to AWS EC2

Virtualisation has revolutionised how we work as developers. A decade ago, using new software would mean trying to find room on a real tin server to install it, hoping it worked, and if it didn’t, picking apart the pieces probably leaving the server in a worse state than it

Technical

Taking a Look at the Oracle Database 12c In-Memory Option

The In-Memory Option for Oracle Database 12c became available a few weeks ago with the 12.1.0.2 database patchset, adding column-store and in-memory capabilities to the Oracle Database. Unlike pure in-memory databases such as Oracle TimesTen, the in-memory option adds an in-memory column-store feature [http://docs.oracle.com/

Technical

Rittman Mead and Oracle Big Data Appliance

Over the past couple of years Rittman Mead have been broadening our skills and competencies out from core OBIEE, ODI and Oracle data warehousing into the new “emerging” analytic platforms: R and database advanced analytics, Hadoop, cloud and clustered/distributed systems. As we talked about in the recent series of

Technical

Simple Ways to Simplify: Quick Fixes to Enhance OBIEE Visuals

Over the past couple of months I worked with a few clients in order to conduct an assessment on dashboard and analysis design. In most cases I was noticing that the dashboards were overflowing with content to the point that there was really no discernible “story” or “flow” to the

Technical

Going Beyond the Summary Advisor with TimesTen for Exalytics

I’m over in Seattle at the moment for ODTUG KScope’14 [http://kscope14.com], and one of the topics I’m presenting on this week is the use of TimesTen with OBIEE; what I’m going to talk about is taking TimesTen beyond its current use as an in-memory

Technical

SampleApp v406 - Automatic startup of OBIEE

Last week Oracle released v406 of SampleApp [http://www.oracle.com/technetwork/middleware/bi-foundation/obiee-samples-167534.html] . SampleApp is a one-stop-shop for a demonstration of pretty much any conceivable thing that OBIEE is capable of, and then some more on top of it. It is a VirtualBox [https://www.virtualbox.org/