Rittman Mead Blog - Oracle BI Suite EE

Automated RPD Builds with OBIEE

Introduction Some time ago, I wrapped up a four-part series on using MDS XML as a basis for RPD development [https://www.rittmanmead.com/blog/2013/05/mds-xml1/]. Of course... you can (re-) read the blog posts to get up to speed on the concept... but I'll offer

Oracle BI Suite EE

Rittman Mead BI Forum 2014 Call for Papers Closing Soon - And News on This Year's Masterclass

Its a couple of days to go until the call for papers for the Rittman Mead BI Forum 2014 closes [https://docs.google.com/a/rittmanmead.com/spreadsheet/viewform?formkey=dEdBdDNJb0JUTVBrNTJhaS00MmFjRXc6MA] , with suggested topics this year including OBIEE (of course), Essbase, Endeca, Big Data, Visualizations, In-Memory analysis and data integration.

Oracle BI Suite EE

Exploring OBIEE Web Services through Python

My very first blog post for Rittman Mead [https://www.rittmanmead.com/blog/2011/11/calling-bi-publisher-11g-web-services-from-bpel/] was on the subject of Web Services in BI Publisher 11g, and now I want to return to the subject here, looking at the Web Services of OBIEE itself. Web Services are basically a

Oracle BI Suite EE

Automated Regression Testing for OBIEE

In the first article of this series [https://www.rittmanmead.com/blog/2014/01/obiee-regression-testing-an-introduction] I explored what regression testing is, why it matters, and by breaking down the OBIEE stack into its constituent parts where it is possible to do it for OBIEE. In this posting, I explore some

Oracle BI Suite EE

OBIEE 11.1.1.7, Cloudera Hadoop & Hive/Impala Part 2 : Load Data into Hive Tables, Analyze using Hive & Impala

In yesterday’s post on analyzing Hadoop data using Cloudera CDH4, Amazon EC2 and OBIEE 11.1.1.7 [https://www.rittmanmead.com/blog/2014/01/obiee-11-1-1-7-cloudera-hadoop-hiveimpala-part-1-install-and-set-up-an-ec2-hadoop-cluster/] , I went through the setup process for Cloudera Manager Standard and then used it to set up a four-node Hadoop cluster in Amazon

Oracle BI Suite EE

OBIEE 11.1.1.7, Cloudera Hadoop & Hive/Impala Part 1 : Install and Set-up an EC2 Hadoop Cluster

I’ve been over in San Francisco this last week for BIWA Summit 2014 [http://www.rittmanmead.com/blog/2014/01/rittman-mead-at-biwa-summit-2014-san-francisco/] , and one of the things I demo’d during the week was OBIEE 11.1.1.7 connecting to a Hadoop cluster running on Amazon EC2, and analysing

Oracle BI Suite EE

OBIEE Regression Testing - An Introduction

In this article I’m going to look at ways to test changes that you make to OBIEE to ensure that they don’t break existing functionality. In all but the simplest IT systems it’s common for one (planned) action to inadvertently cause another (unplanned). What IS Regression Testing?

Oracle BI Suite EE

Rittman Mead BI Forum 2014 Call for Papers Now Open!

It’s that time of year again when we start planning out next year’s BI Forum, which like this year’s event will be running in May 2014 in Brighton and Atlanta. This will be our sixth annual event, and as with previous year’s the most important part

Oracle BI Suite EE

Thoughts on Running OBIEE in the Cloud : Part 2 - Data Sources and ETL

In yesterday’s post on running OBIEE in the cloud [https://www.rittmanmead.com/blog/2013/11/thoughts-on-running-obiee-in-the-cloud-part-1-the-bi-platform/] , I looked at a number of options for hosting the actual OBIEE element; hosting it in a public cloud service such as Amazon EC2, using Oracle’s upcoming BI-as-a-Service offering, or partner

Oracle BI Suite EE

Thoughts on Running OBIEE in the Cloud : Part 1 - The BI Platform

One of the major announcements at this year’s Oracle Openworld in San Francisco was around "OBIEE in the cloud” [https://www.rittmanmead.com/blog/2013/09/oracle-openworld-2013-reflections-on-product-announcements-and-strategy/] . Part of a wide-ranging set of announcements around services and infrastructure in the cloud from Oracle, the idea with this service

Oracle BI Suite EE

Make Use of OBIEE's Command Line Tools with Reduced Exposure of Plain Text Passwords

Introduction We all love a good commandline utility. It gives us that warm feeling of control and puts hairs on our chests. Either that, or it means we can script the heck out of a system, automate many processes, and concentrate on more important matters [http://phoboslab.org/ztype/]. However,

Oracle BI Suite EE

Why ODI, DW and OBIEE Developers Should Be Interested in Hadoop

Over the past few months I’ve been posting a number of articles about Hadoop, and how you can connect to it from ODI and OBIEE. From an ODI perspective, I covered Hadoop as one of a number of new data sources ODI11g could connect to [https://www.rittmanmead.com/

Oracle BI Suite EE

Creating a Multi-Node Hadoop/Impala Cluster as a Datasource for OBIEE 11.1.1.7

The other day I posted an article on the blog about connecting OBIEE 11.1.1.7 to Cloudera Impala [http://www.rittmanmead.com/blog/2013/11/connecting-obiee-11-1-1-7-to-cloudera-impala/] , a new “in-memory” SQL engine for Hadoop that’s much faster than Hive for interactive queries. In this example, I connected OBIEE

Oracle BI Suite EE

Connecting OBIEE 11.1.1.7 to Cloudera Impala

A few months ago I posted a series of articles about connecting OBIEE 11.1.1.7 [http://www.rittmanmead.com/blog/2013/04/obiee-odi-and-hadoop-part-1-so-what-is-hadoop-mapreduce-and-hive] , Exalytics [http://www.rittmanmead.com/blog/2013/07/accelerating-hadoophive-obiee-queries-using-exalytics-and-the-summary-advisor/] and ODI [http://www.rittmanmead.com/blog/2013/04/obiee-odi-and-hadoop-part-3-a-closer-look-at-hive-hfds-and-cloudera-chd3/] to Apache Hadoop through Hive [http:

Oracle BI Suite EE

OEM12cR3: Holistic BI Platform Monitoring using Systems and Services

Over the past few weeks myself and some of my colleagues have been posting articles on the blog about monitoring OBIEE using Enterprise Manager 12cR3’s BI Management Pack [https://www.rittmanmead.com/blog/2013/04/obiee-oem12cr2-and-the-bi-management-pack-part-1-introduction-to-oem12cr2/] . In the various articles we’ve looked at managing individual OBIEE installations and

Oracle BI Suite EE

Monitoring OBIEE Performance for the End User with JMeter from EM12c

This is the third article in my two-article set of posts (h/t [https://en.wikipedia.org/wiki/Trilogy_in_five_parts]) on extending the monitoring of OBIEE within EM12c. It comes after a brief interlude discussing Metric Extensions [https://www.rittmanmead.com/blog/2013/11/collecting-usage-tracking-data-with-metric-extensions-in-em12c/] as an alternative

Oracle BI Suite EE

Collecting Usage Tracking Data with Metric Extensions in EM12c

In my previous post [https://www.rittmanmead.com/blog/2013/11/building-alerts-in-em12c-with-obiee-usage-tracking-data/] I demonstrated how OBIEE’s Usage Tracking data could be monitored by EM12c through a Service Test. It was pointed out to me that an alternative for collecting the same data would be the use of EM12c’s

Oracle BI Suite EE

Building alerts in EM12c with OBIEE Usage Tracking data

Introduction Enterprise Manager 12c is the latest and greatest incarnation of Oracle’s toolset for Enterprise Management (the clue’s in the name), of which Cloud Control (neé Grid Control) is one of the key tools. It can be used for a unified overview of disparate services including servers, databases,

Oracle BI Suite EE

Rittman Mead / ODTUG India BI Masterclass Tour Roundup

Over the past week Venkat, myself and the Rittman Mead India team have been running a series of BI Masterclasses [http://www.rittmanmead.com/indiabimasterclass2013/] at locations in India, in conjunction with ODTUG, the Oracle Development Tools User Group. Starting off in Bangalore, then traveling to Hyderabad and Mumbai, we

Oracle BI Suite EE

OBIEE "Act As" (ActAs) vs "Impersonate"

There will come a point in the lifecycle of an OBIEE deployment when one user will need to access another user’s account. This may be to cover whilst a colleague is on leave, or a support staff trying to reproduce a reported error. Password sharing aside (it's

Oracle BI Suite EE

Tips and Tricks for the OBIEE linux sysadmin

As well as industry-leading solution architecture, consultancy and training on Oracle BI, here at Rittman Mead we also provide expert services in implementation and support of such systems. In this blog I want to share some of the things I find useful when working with OBIEE on a Linux system.

Oracle BI Suite EE

Openworld is Over - Now We're Coming to India..!

Oracle Openworld 2013 is now over [https://www.rittmanmead.com/blog/2013/09/oracle-openworld-2013-reflections-on-product-announcements-and-strategy/] , but no sooner have we unpacked from that trip, we're packing again for our next one - our BI Masterclass Tour for India [http://www.rittmanmead.com/indiabimasterclass2013/], starting in a few week'

Oracle BI Suite EE

Oracle Openworld 2013 : Reflections on Product Announcements and Strategy

I'm sitting writing this at my desk back home, with a steaming mug of tea next to me and the kids pleased to see me after having been away for eight days (or at least my wifepleased to hand them over to me after looking after them for

Oracle BI Suite EE

Oracle Openworld 2013 Days 3 & 4 : Oracle Cloud, OBIEE and ODI Futures

It's getting to the end of day 4 of Oracle Openworld, with Team Oracle USA coming back from 8-1 down and pulling-off the unlikeliest of comeback victories [http://www.bbc.co.uk/sport/0/sailing/24274103], and Openworld sessions covering OBIEE, ODI and Oracle Cloud futures. Here'

Oracle BI Suite EE

Oracle Openworld 2013 Day 2: Exalytics, TimesTen and Essbase Futures

Monday's almost over at Oracle Openworld 2013 in San Francisco, and it started for me today with a presentation on Enterprise Manager 12c and the BI Management Pack, alongside Henrik Blixt (PM for the BI Management Pack) andDhananjay Papde [http://dhananjaypapde.blogspot.co.uk], author of a book