Rittman Mead Blog - Technical Insights

Real-time BI: EDW with a Real-time Component

I apologize for the long delay in getting this last portion of the Real-time discussion in place. Since I wrote the first two installments, we've had the BI Forum (US and UK versions), plus a flurry of activity around Rittman Mead in the US, followed up by KScope11.

Business Insights

OBIEE 11g Bootcamp Scheduled for August 1st - 5th in Atlanta

This is just a quick note to announce that we have scheduled another OBIEE 11g Bootcamp course in Atlanta in early August. We've been working on the OBIEE 11g material since we received the first beta release, and we've run successive versions of this material through

Oracle BI Suite EE

Oracle BI EE 11g - Reporting on Hyperion Financial Management (HFM) - Part 1

This has been my second longest sabbatical since i started blogging 4.5 years back. More than a month since my last post. Rather than going into the reasons of why(& sounding cliched) i thought i will kick start my postings again with one another new BI EE 11g

Oracle BI Suite EE

OBIEE Calculations, MDX Functions, Flattened Measures, and Essbase Sources

When you starting working with Essbase sources and OBIEE, how you create calculations quickly becomes one of the more interesting aspects of working with the two technologies. With Essbase, you've got a powerful multi-dimensional database that features many functions and calculation capabilities that you'd like to

Business Insights

Rittman Mead at ODTUG Kscope 2011

I'm still not used to saying "Kscope"... it sounds like a medical screening that I know I should get when I turn 40. Regardless, I'm looking forward to the event for all the usual reasons: seeing good friends, seeing all the great speakers in

Oracle BI Suite EE

Incremental Essbase Metadata Imports Now Possible with OBIEE 11g

If you were an early adopter of Essbase integration with OBIEE, the 10g release had a number of restrictions that made it hard to use in production. Chief amongst these was the lack of any ability to refresh the physical model of the Essbase database within the Oracle BI Repository,

Oracle BI Suite EE

What Skills Does an Oracle BI Developer Need in 2011?

Back in 2009, I wrote a blog post entitled "What Skills Does an Oracle BI Developer Need in 2009" [http://www.rittmanmead.com/blog/2009/03/what-skills-does-an-oracle-bi-developer-need-in-2009/] . At the time, OBIEE 11g was in the planning stage, Oracle had recently acquired Hyperion and so Essbase and Planning were

Technical

Rittman Mead at the UKOUG EPM Conference, July 2011

Over the past few days the UKOUG has been running it's UKOUG Conference Series: EPM & Hyperion 2011 [http://hyperion.ukoug.org/] event in Weybridge, near London, and Jon Mead and I went along yesterday to take part. Thank you to everyone who came to my session on

Technical

ODI 11g New Mapping and Interface Features - Part 3 - OBIEE Lineage

In the first two parts of this min-series, I looked at the new mapping and interface features with ODI 11.1.1.3 [https://www.rittmanmead.com/blog/2011/06/odi-11g-new-mapping-and-interface-features-part-1/], and yesterday I took a look at Load Plans [https://www.rittmanmead.com/blog/2011/06/odi-11g-new-mapping-and-interface-features-part-2-load-plans/] , a new

Technical

ODI 11g New Mapping and Interface Features - Part 2 - Load Plans

Yesterday I posted on the blog an overview of some of the new interface (mapping) features in the original, 11.1.1.3 release of Oracle Data Integrator 11g [https://www.rittmanmead.com/blog/2011/06/odi-11g-new-mapping-and-interface-features-part-1/]. In today's posting, I'm going to look at the

Technical

ODI 11g New Mapping and Interface Features - Part 1

About a year or so ago I posted an entry on this blog highlighting the new architectural features of Oracle Data Integrator 11g [http://www.rittmanmead.com/blog/2010/09/odi-11g-now-available-for-download/]. At the time, I talked about the new user interface, integration with WebLogic Server and Enterprise Manager, and how

Business Insights

Data Warehouse Global Leaders Forum, Athens

Mark and I have just spent the last couple of days at the DW Global Leaders Forum in Athens. The DW Global Leaders Forum is an Oracle-run customer program that connects a number of EMEA Data Warehouse clients with each other, Oracle and a small number of partners. The main

Business Insights

Last Two Days for the ODTUG Kscope11 $250 Discount!

Just a quick note to remind any who's not yet registered, that the cu [http://odtug.wordpress.com/2011/06/07/the-time-is-now/]t-off date for registering for ODTUG KScope'11 with the $250 discount [http://odtug.wordpress.com/2011/06/07/the-time-is-now/] is June 9th, just two

Business Insights

OBIEE 11g for Hyperion Users - Are We There Yet?

In a couple of weeks time it's the OUG Conference Series EPM & Hyperion 2011 Conference [http://hyperion.ukoug.org/default.asp] in the UK (now there's a mouthful), and along with such Hyperion luminaries and Oracle ACE Directors as Edward Roske and Eric Helmer, I&

Business Insights

Rittman Mead Public Training Courses - June 2011

<title></title>  <table width="600" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="20"> </td> <!-- LEFT

Oracle BI Suite EE

Oracle BI EE 11.1.1.5 - Repository Command Line Switches - Importing New Projects into RPD

One of the hidden features of BI Admin Tool is the ability to run certain commands from command line. I have written about some of the use cases of this here [http://oraclebizint.wordpress.com/2008/05/02/oracle-bi-ee-101332-automating-password-updates-of-connection-pools-and-users-command-line-options/] . In addition to the ones that i have written there are

Business Insights

Geography Hierarchies

I have been thinking about address a lot recently, in part it was moving house and all of the 1001 people that need to be notified. In the main, though, it was thoughts inspired by a data warehouse project I am working on. For this DWH people are geo-located by

Technical

Not The Only 11.1.1.5.0 In Town

Just a short posting to mention that earlier this month Oracle released version 11.1.1.5.0 of Data Integrator Look out for more Rittman Mead postings on ODI over the coming months

Oracle BI Suite EE

BI Applications 7.9.6.3 - What's New?

Along with BI EE 11.1.1.5, there was also a major release of BI Apps 7.9.6.3. This is a major release not because of the new features but instead this is the first release that uses BI EE 11g natively. In fact this release does

Business Insights

Real-time BI: Federated OLTP/EDW Reporting

The typical approach in Federated OLTP/EDW reporting environments is to use a BI tool such as OBIEE to do horizontal federation. This means combining data from multiple sources at the same grain in a single logical table. One note of clarification: my use of the word "federated"

Oracle BI Suite EE

Oracle BI EE 11.1.1.5 - New JDeveloper Extensions

As covered by Mark earlier [https://www.rittmanmead.com/blog/2011/05/whats-new-in-obiee-11-1-1-5-ps1/], BI EE 11.1.1.5 has some significant new features and is a definite upgrade for customers using BI EE 11.1.1.3(even for 10g customers). I know the release is only a week

Oracle BI Suite EE

OBIEE 11.1.1.5 and Oracle OLAP Support

One of the welcome (but strangely unheralded) new features introduced with OBIEE 11.1.1.5 is support for Oracle OLAP as a data source. Earlier releases of OBIEE supported Oracle OLAP through SQL access, either directly through SQL views or through cube-organized materialized views, and there was even a

Oracle BI Suite EE

Real-time BI: An Introduction

Discussing real-time data warehousing is difficult because the meaning of real-time is dependent on context. A CIO of an organization that has weekly batch refresh processes might view an up-to-the-day dashboard as real-time, while another organization that already has daily refresh cycles might be looking for something closer to up-to-the-hour.

Oracle BI Suite EE

Oracle BI EE 11g - Decoding Essbase Connectivity - Part 5 - Security

I was actually compiling all my findings of the last 4 posts as a summary post but then realized i haven't actually covered another important part of the Essbase Connectivity i.e. Essbase Security. In today's post let's look at how Essbase Security is

Oracle BI Suite EE

Oracle BI EE 11g - Decoding Essbase Connectivity - Part 4 - Logical SQL Generation

In the last 3 posts we saw how BI EE generates the MDX and what major factors influence the MDX generated. As a recap, there are 4 main things that we noticed. 1. BI EE generates the most optimal MDX as long as we have all the attribute or Hierarchical