Tagged

obiee

A collection of 131 posts

Big Data

OBIEE 11.1.1.9 Now Supports HiveServer2 and Cloudera Impala

As you all probably know I’m a big fan of Oracle’s BI and Big Data products [http://www.rittmanmead.com/biforum2015/optional-masterclass-delivering-the-oracle-information-management-big-data-reference-architecture/] , but something I’ve been critical of [https://www.rittmanmead.com/blog/2014/12/connecting-obiee11g-on-windows-to-a-kerberos-secured-cdh5-hadoop-cluster-using-cloudera-hiveserver2-odbc-drivers/] is OBIEE11g’s lack of support for HiveServer2 connections to Hadoop

Technical

What's New in OBIEE 11.1.1.9 for Systems Administrators and Developers

After over two years since the last major release of OBIEE, Oracle released version 11.1.1.9 in May 2015. You can find the installers here [http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bi-downloads-2537285.html] and documentation here [https://docs.oracle.com/middleware/11119/biee/docs.htm]. 11.

Technical

BI Forum 2015 Preview -- OBIEE Regression Testing, and Data Discovery with the ELK stack

I’m pleased to be presenting at both of the Rittman Mead BI Forums [https://www.rittmanmead.com/blog/biforum2015/] this year; in Brighton it’ll be my fourth time, whilst Atlanta will be my first, and my first trip to the city too. I’ve heard great things about

Technical

OBIEE nqcmd Tidbits

nqcmd is the ODBC command line tool that always has, and hopefully always will, shipped with OBIEE. It enables you to manually fire queries directly at the BI Server, rather than through the usual way of Presentation Services generating Logical SQL and sending it to BI Server. This can be

Technical

Announcing the BI Forum 2015 Data Visualisation Challenge

The Rittman Mead BI Forum 2015 [http://www.rittmanmead.com/biforum2015]is running in Brighton from May 6th-8th 2015, and Atlanta from May 13th - 15th 2015. At this year’s events we’re introducing our first “data visualization challenge” [http://www.rittmanmead.com/biforum2015/bi-forum-2015-data-visualization-challenge/] , open to all attendees

Technical

Instrumenting OBIEE Database Connections For Improved Performance Diagnostics

Nearly four years ago I wrote a blog post entitled “Instrumenting OBIEE - The Final Chapter” [https://rnm1978.wordpress.com/2011/10/10/instrumenting-obiee-the-final-chapter/] . With hindsight, that title suffix (“The Final Chapter”) may have been a tad presumptuous and naïve of me (or perhaps I can just pretend to be

Big Data

Rittman Mead BI Forum 2015 Now Open for Registration!

I’m very pleased to announce that the Rittman Mead BI Forum 2015, running in Brighton and Atlanta in May 2015, is now open for registration [http://www.rittmanmead.com/biforum2015/]. Back for its seventh successful year, the Rittman Mead BI Forum once again will be showcasing the best speakers

Technical

Why and How to use Oracle Metadata Management 12c. Part 2: Importing and Relating Metadata

In the first post [https://www.rittmanmead.com/blog/2015/01/why-and-how-to-use-oracle-metadata-management-12c-part-1-getting-started/] of this series we have seen how to install and configure OEEM to start working with it. In this new post we are going to see how we import the metadata into OEMM from different sources like Oracle

Technical

OBIEE Monitoring and Diagnostics with InfluxDB and Grafana

In this article I’m going to look at collecting time-series metrics into the InfluxDB database and visualising them in snazzy Grafana dashboards. The datasets I’m going to use are OS metrics (CPU, Disk, etc) and the DMS metrics from OBIEE, both of which are collected using the support

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

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

TIMESTAMPS and Presentation Variables

TIMESTAMPS and Presentation Variables can be some of the most useful tools a report creator can use to invent robust, repeatable reports while maximizing user flexibility.  I intend to transform you into an expert with these functions and by the end of this page you will certainly be able to

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

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

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

The Business Value In Training

One of the main things I get asked to do here at Rittman Mead, is deliver the OBIEE front-end training course (TRN 202). This a great course that has served both us, and our clients well over the years. It has always been in high demand and always delivered with

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

Visual Regression Testing of OBIEE with PhantomCSS

Earlier this year I wrote a couple of blogs posts (here [https://www.rittmanmead.com/blog/2014/01/obiee-regression-testing-an-introduction/] and here [https://www.rittmanmead.com/blog/2014/01/automated-regression-testing-for-obiee/]) discussing the topic of automated Regression Testing and OBIEE. One of the points that I was keen make was that OBIEE

Technical

Mobile App Designer mis-configuration error

I've been doing some work recently with OBIEE's new Mobile App Designer [https://www.rittmanmead.com/blog/2013/08/a-first-look-at-the-obiee11g-mobile-app-designer/](MAD). It's a great bit of software that I'm genuinely impressed with, but it's got its little v1 quirks, and

Technical

The State of the OBIEE11g World as of May 2014

I’m conscious I’ve posted a lot on this blog over the past few months about hot new topics like big data, Hadoop and Oracle Advanced Analytics, and not so much about OBIEE, which traditionally has been the core of Rittman Mead’s business and what we’ve written

Technical

BI Forum 2014 preview - No Silver Bullets : OBIEE Performance in the Real World

I'm honoured to have been accepted to speak at this year's Rittman Mead BI Forum [http://www.rittmanmead.com/biforum2014/], the sixth year of this expert-level conference that draws some of the best Oracle BI/DW minds together from around the world. It's running

Technical

Visualising OBIEE DMS metrics with Graphite

Assuming you have set up obi-metrics-agent and collectl as described in my previous post [https://www.rittmanmead.com/blog/2014/03/installing-obi-metrics-agent-graphite-and-collectl], you have a wealth of data at your disposal for graphing and exploring in Graphite, including: * OS (CPU, disk, network, memory) * OBIEE's metrics * Metrics about DMS

Technical

The Secret Life of Conditional Formatting in OBIEE

When dealing with conditional formatting the GUI allow us to add as many formats as we want, but every single format has a unique and single condition, not more, not less. In this post I am going to show how it is possible in OBIEE to use multiple conditions to

Oracle BI Suite EE

OBIEE 11g Presentation Server Catalog Replication Across Redundant Servers

The thing about OBIEE 11g, is that there is no single way to get things "up and running". Over the past year I have performed countless OBIEE installs and almost every one has been different to the last, due to infrastructure challenges, scale requirements or requirements for high-availability

Oracle BI Suite EE

Date formatting in OBIEE 11g - setting the default Locale for users

A short and sweet blog post this one, simply to plug a gap in Google that I found when trying to do achieve this today. How user’s see things like date formats in OBIEE is determined by their locale, which is usually related to language but not always the