Tagged

Oracle BI Suite EE

A collection of 400 posts

Big Data

Replicating Hive Data Into Oracle BI Cloud Service for Visual Analyzer using BICS Data Sync

In yesterday’s post on using Oracle Big Data Discovery with Oracle Visual Analyzer in Oracle BI Cloud Service [https://www.rittmanmead.com/blog/2015/06/combining-oracle-big-data-discovery-and-oracle-visual-analyzer-on-bics/] , I said mid-way through the article that I had to copy the Hadoop data into BI Cloud Service so that Visual Analyzer could

Technical

Introducing Rittman Mead's New User Engagement Service

[http://www.rittmanmead.com/wp-content/uploads/2015/06/RMA-UE-Datasheet.pdf] Although you’ve been hearing a lot on the blog recently about extending Oracle BI&DW with Hadoop and big data technologies, another initiative Rittman Mead have been working on over the past couple of months is user engagement.

Big Data

Combining Oracle Big Data Discovery and Oracle Visual Analyzer on BICS

So now that Oracle Visual Analyzer is out as part of Oracle BI Cloud Service [https://www.rittmanmead.com/blog/2015/06/new-in-oracle-bi-cloud-service-oracle-visual-analyzer-and-data-mashups-in-va/] , and Visual Analyzer (VA) is due to ship on-premise as part of OBIEE12c sometime in the next twelve months, several of our customers have asked us if

Technical

New In Oracle BI Cloud Service - Oracle Visual Analyzer, and Data Mashups in VA

Oracle released an update to Oracle BI Cloud Service a few weeks ago that included Oracle Visual Analyzer, along with some other improvements including support for full Oracle Database-as-a-Service as the database backend, the ability to upload RPDs and run them in the cloud, and support for a new utility

Technical

OBIEE 11.1.1.9: New Features for Front-End Developers and Business Users

OBIEE 11.1.1.9 [https://blogs.oracle.com/proactivesupportEPM/entry/obiee_111190] was released this May and Robin and Mark wrote great posts about New Features from System Administrators [https://www.rittmanmead.com/blog/2015/05/whats-new-in-obiee-11-1-1-9-for-systems-administrators-and-developers/] and the new support for HiveServer2 and Cloudera Impala [https://www.rittmanmead.

Technical

Deploying Oracle BI Mobile HD within Good, Oracle OMSS and Other Secure MDM Containers

A few months ago ODTUG announced their ODTUG Mobile Day in Utrecht, Netherlands [http://www.odtug.com/mobile_day_utrecht] and asked if I’d like to put forward an abstract for a presentation. Something that’s been on my mind for a while is the issues some of our

Technical

New Oracle Magazine article on Oracle BI Cloud Service

The May/June 2015 edition of Oracle Magazine is now out, and my Business Intelligence article in this edition is on Oracle BI Cloud Service (BICS). In “Upload, Model, Analyze and Report” [http://www.oracle.com/technetwork/issue-archive/2015/15-may/o35ba-2541604.html] I focus on the “departmental power-user” use-case where

Big Data

Connecting OBIEE 11.1.1.9 to Hive, HBase and Impala Tables for a DW-Offloading Project

In two previous posts this week I talk about a client request to offload part of their data warehouse top Hadoop, taking data from a source application and loading it into Hive tables on Hadoop for subsequent reporting-on by OBIEE11g. In the first post [https://www.rittmanmead.com/blog/2015/

Big Data

Using HBase and Impala to Add Update and Delete Capability to Hive DW Tables, and Improve Query Response Times

One of our customers is looking to offload part of their data warehouse platform to Hadoop, extracting data out of a source system and loading it into Apache Hive tables for subsequent querying using OBIEE11g. One of the challenges that the project faces though is how to handle updates to

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

Big Data

Presentation Slides and Photos from the Rittman Mead BI Forum 2015, Brighton and Atlanta

It’s now the Saturday after the two Rittman Mead BI Forum 2015 [http://www.rittmanmead.com/biforum2015/] events, last week in Atlanta, GA and the week before in Brighton, UK. Both events were a great success and I’d like to say thanks to the speakers, attendees, our friends

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

Last Chance to Register for the Brighton Rittman Mead BI Forum 2015!

It’s just a week to go until the start of the Brighton Rittman Mead BI Forum 2015 [http://www.rittmanmead.com/biforum2015/], with the optional one-day masterclass starting on Wednesday, May 6th at 10am and the event opening with a reception and Oracle keynote later in the evening. Spaces

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

Big Data

Previewing Four Sessions at the Atlanta Rittman Mead BI Forum 2015

In a post earlier this week I previewed three sessions at the upcoming Brighton Rittman Mead BI Forum 2015 [https://www.rittmanmead.com/blog/2015/04/previewing-three-sessions-at-the-brighton-rittman-mead-bi-forum-2015/] ; in this post I’m going to look at four particularly interesting sessions at the Atlanta Rittman Mead BI Forum 2015 [http://www.

Technical

OBIEE and the Oracle Database 12c In-Memory Option - Article and New Services from Rittman Mead

My latest Business Intelligence column for Oracle Magazine is on the In-Memory Option for Oracle Database 12c [http://www.oracle.com/technetwork/issue-archive/2015/15-jan/o15ba-2398995.html] , and using it to speed-up dashboards and reports in OBIEE11g. In the article I go through the basics of the in-memory option explaining

Technical

Take Part in the BI Survey 15, and Have Your Voice Heard!

Long-term readers of this blog will know that we’ve supported for many years the BI Survey, an independent survey of BI tools customers and implementors. Rittman Mead have no (financial or other) interest in the BI Survey or its organisers, but we like the way it gathers in detailed

Technical

Previewing Three Sessions at the Brighton Rittman Mead BI Forum 2015

As well as a one-day masterclass by myself and Jordan Meyer [http://www.rittmanmead.com/biforum2015/optional-masterclass-delivering-the-oracle-information-management-big-data-reference-architecture/] , a data visualisation challenge [http://www.rittmanmead.com/biforum2015/bi-forum-2015-data-visualization-challenge/] , keynotes and product update sessions from Oracle and our guest speaker [https://www.rittmanmead.com/blog/2015/03/announcing-the-special-guest-speakers-for-brighton-atlanta-bi-forum

Big Data

Realtime BI Show with Kevin and Stewart - BI Forum 2015 Special!

Jordan Meyer and I were very pleased to be invited onto the Realtime BI Show podcast last week, run by Kevin McGinley and Stewart Bryson, to talk about the upcoming Rittman Mead BI Forum running in Brighton and Atlanta in May 2015 [http://www.rittmanmead.com/biforum2015]. Stewart and Kevin

Technical

Lifting the Lid on OBIEE Internals with Linux Diagnostics Tools

There comes the point in any sufficiently complex or difficult problem diagnosis that the log files in OBIEE alone are not sufficient for building up a complete picture of what’s going on. Even with the debug/trace data that Presentation Services [https://www.rittmanmead.com/blog/2014/11/auditing-obiee-presentation-catalog-activity-with-custom-log-filters/

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

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