Rittman Mead (Page 46)

We help people get the most out of their investment in Oracle Data, Analytics and AI.

Oracle BI EE 10.1.3.4.1 – Currency Conversions & FX Translations – Part 1

One of the common requirements when implementing BI EE is the ability to handle multiple input currencies. This is a pretty common requirement especially in business scenarios where multiple countries/currencies are involved. In such cases, many of the finance related measures like Sales etc will come in local currencies.

Oracle BI EE 10.1.3.4.1 – Do we always need AGO and ToDate functions for Time Series Analysis?

In my last blog post, i basically showed how we can do multi-dimension OLAP aware reporting by altering the physical data-warehouse model. Along similar lines, one other common thing that i have found recently in many implementations is the extensive use of AGO and ToDate functions. AGO and ToDate are

Oracle Magazine Article on OWB11gR2 and OBIEE Integration

[http://www.oracle.com/technology/oramag/oracle/10-jul/index.html]Oracle have just published my latest article, on the integration between Oracle Warehouse Builder 11g Release 2 and Oracle Business Intelligence Enterprise Edition, in the July/August 2010 [http://www.oracle.com/technology/oramag/oracle/10-jul/index.html] edition of

Oracle BI EE 10.1.3.4.1 – Do we need measures in a Fact Table?

I know this blog title can be classified as a deviation from my more conventional ones but i have been planning on writing this for a while now, so hopefully this should be of some interest to everyone. As we start working with BI EE more and more, we get

Realtime Data Warehouse Challenges - Part 1

In a previous part of my notes on Realtime Data Warehousing I mentioned some of the challenges of reducing latency. The piece picked up quite a few comments - to which I say thanks to all that posted responses. One of the comments from Matt Hosking mentioned some of the

Rittman Mead BI Forum 2010 Round-Up

Well it's the Monday after the week of the BI Forum in Brighton [http://www.rittmanmead.com/biforum2010], and as promised here are some photos, and a link to the presentations, for anyone that couldn't make it. The three days went very well, starting with the

Rittman Mead America is Recruiting

While most of Rittman Mead in the UK is attending the second annual Rittman Mead BI Forum [http://www.rittmanmead.com/biforum2010/], I'm still in the US finishing up a project with a client this week, wishing I was in Brighton for some of the great sessions going

The Day Before the BI Forum 2010

Well it's the day before our second annual BI Forum in Brighton [http://www.rittmanmead.com/biforum2010], and after a bit of last minute panic about the ash cloud coming back, people should be traveling over today and tomorrow to get to the Hotel Seattle in Brighton. In

Suncoast Oracle Users Group, May 27, 2010

I'm honored and excited to be speaking at the Suncoast Oracle Users Group (SOUG) [http://soug.acomp.usf.edu/] monthly meeting on May 27th, 2010, at the PricewaterhouseCoopers [http://soug.acomp.usf.edu/meetings.php] facility at 3109 W. Martin Luther King Blvd., Tampa, FL 33607. Much appreciation

Passing Parameters to Mappings

I received a question from a client today about the best way to add a date parameter to a mapping. In this case, they were looking for the max date in a particular table, and they wanted to use that date as a source in a mapping. Below I'

Realtime Data Warehouse Loading

Last time I wrote about the use of replication to provide a source for realtime BI. This time I am going to look at putting data in to a data warehouse in "realtime". Note the quotes, when we speak of realtime there is always some degree of latency:

Oracle EPM 11.1.2 - Allocations in Essbase ASO Cubes - Using MaxL scripts

In the last 2 blog entries, i showed how the calculations in ASO work. Today lets look at another new feature in ASO cubes i.e the ability to run allocations directly. In a BSO cube, Allocations and Calculations are all driven through a set of calculation commands. Some Allocation

Adding Default Rows with OBIEE

When looking at a typical dimensional model, there are cases when the application of one or more dimension tables may not make sense for particular fact rows. We handle these situations with special rows in the dimension table that specify this lack of relationship, sometimes known generically as "default&

Oracle EPM 11.1.2 - Essbase Calculations on ASO Cubes - Part 2 - Maxl scripts and EAS

In the last blog post, i covered the new calculation manager feature to run calculations on an ASO cube. But to be honest, i somehow felt it was an overkill atleast for running ASO specific calculations alone. The advantage of calc manager can become apparent if you are using Planning

Oracle EPM 11.1.2 - Essbase Calculations on ASO Cubes - Part 1 - Using Calc Manager

One of the significant new features of EPM 11.1.2 release, is the ability to write custom calculation scripts for calculating & allocating data to level-0 members in an ASO Cube. Till now, in many cases/implementations, BSO option had to be used in some form or the other

Rittman Mead India - Call for very good Oracle BI Developers/Architects

As Mark mentioned in his blog posting a couple of weeks back [https://www.rittmanmead.com/blog/2010/03/28/an-update-on-the-bi-forum-obiee-emg-and-us-conferences/] , we now have an office in India. We now have a total of 3 people working out of our India office currently with myself overseeing the operations. Personally this

Oracle Warehouse Builder 11g Release 2 and Heterogeneous Databases

[http://www.oracle.com/technology/oramag/oracle/10-may/index.html]Oracle Magazine [http://www.oracle.com/technology/oramag/oracle/10-may/index.html] has recently gone through a re-design, and the May/June 2010 edition comes with a new article by myself on "Oracle Warehouse Builder 11g Release 2 and

Realtime BI Is Not Realtime DW

This posting is slightly edited to clarify that the majority of the post is about using transactional or transactionally structured sources for reporting. One of the points I make early on in my talk "Getting Real Data Warehouse Loading as it Happens" is that realtime business intelligence is

What Happens at Collaborate...

Well I'm currently sitting the in the departures lounge at the Las Vegas Airport, about to catch a flight ... to Denver. Like Jon, Pete and Venkat, I was caught by the airspace restrictions in place earlier this week, except like Jon, I was trapped in the States rather

Wrapping up Collaborate 10

It's been a fun week in good old Las Vegas. Though in the end I broke even at the tables, I enjoyed holding a large amount of the Mandalay Bay's money for them for two or three days, just to give it all back to them

EPM 11.1.2 - Getting Started and Installation

I have finally managed to download & install the necessary binaries for the EPM 11.1.2 Essbase installation. When i started the download, i was actually wary of downloading the 64 bit Essbase since 11.1.2 is a significant rewrite when compared with the previous 11.1.1.

Oracle EPM 11.1.2 – Finally released and available on E-Delivery

After checking non-stop for the last couple of weeks, finally managed to start the download of EPM 11.1.2. Yes, its officially released for download now and is available in E-Delivery [http://edelivery.oracle.com]. Some of the significant new features in this release are 1. Oracle Financial Close

Oracle BI EE 10.1.3.4.1 – Number of Members in a Level & Aggregate Navigation

One of the less known/less used capabilities of BI EE is the ability to switch between Aggregate tables based on the number of members in a level. For example, lets consider the screenshot shown below In most cases, we will not have the necessity to alter the number shown

Collaborate 10 - The Early Days

One of the things I had expected to do this week was to write about some of my BI and DW highlights from Collaborate 10. However, that is not to be. I am currently sitting at home in the UK, a victim of a cloud of volcanic ash that has

Oracle EPM 11.1.1.3 & Oracle OLAP 11g – Reporting on Oracle OLAP using Essbase Excel Add-in/Smartview - XOLAP

This is the week of Colloborate 2010 [http://www.collaborate10.org/] conference. Mark, myself, Pete and Stewart were scheduled to present this year but due to the European Airspace closure, myself and Pete haven’t been able to actually travel this year. Its a real shame as we all really