Rittman Mead Blog - Technical Insights

To BICC Or Not To BICC (Part 2)

In my last post, I opened up some of my thoughts about how much BICC activity is happening in the real world. Continuing on from there, I'm now going to turn my attention to some of the important things that I think need to be addressed in the

Technical

Running the OBIEE Administratiol tool on Unix using Wine

The other day I was playing with getting OWB11gR2, which at the time of this writing, has only been released under Linux and Solaris, to run under Windows [https://www.rittmanmead.com/blog/2009/12/10/owb11gr2-on-windows/]. In the pursuing comments Jon Mead threw down the gauntlet and asked if

Technical

To BICC Or Not To BICC (Part 1)

If your organisation has been using Business Intelligence in a strategic way for some time, then you will have already seen your BI solution evolve, grow and change from its original incarnation. You will probably also have an appreciation of the importance of somehow taking ownership of this process of

Technical

Oracle EPM 11.1.1.3 - Installing Hyperion Components on Multiple Machines

In any EPM deployment, rarely do all the components get installed on a single machine. In majority of the cases, you will see that each component is actually installed on separate machines with their own application and web servers. So, how does this all work and how do we go

Technical

Cognos 8 & Oracle BI EE 10.1.3.4.1 - Reporting using Cognos on BI EE Metadata - BI Server ODBC

In the last blog entry i had given a high level overview of the various components comprising the Cognos 8 BI Suite. One of the most common questions that we tend to get in conferences is how do we go about using Cognos to report out of the model designed

Technical

Capturing Change (Part 1)

Shortly after I joined Rittman Mead I wrote a small article [http://www.rittmanmead.com/files/DataW_Getting_Real.pdf] on real-time Business Intelligence , there is also a link to it on our "Articles" tab [http://www.rittmanmead.com/articles/]. One of the techniques I mentioned in passing

Technical

UKOUG Tech and EBS Conference, Day 1

I'm now back in my hotel room, having escaped from the Focus Pubs at the end of Day 1 of the UKOUG Technology and E-Business Suite Conference in Birmingham. It's been a long day, with an 8am meeting on the stand in the exhibition, a stint

Technical

Oracle BI EE 10.1.3.4.1 & Essbase Connectivity – Enriching Essbase reports with relational attributes

If you had attended our training days event or one of our Open World sessions, you will have noticed that we had covered the various aspects of integration between Essbase and relational sources using BI EE. The presentations are available here [http://www.rittmanmead.com/articles/]. One of the scenarios

Technical

Oracle BI EE 10.1.3.4.1 – Single Table Repository Design – Modeling Statistics of common Sports – Tennis, Football etc – Part 2

In the last blog entry i had shown a simple scenario of creating a BMM layer for one physical table. In today’s entry i will be covering a practical use case of creating a BMM layer from one physical table. This is a very interesting use case and can

Technical

Oracle BI EE 10.1.3.4.1 – Single Table Repository Design – Part 1

One of the best ways to understand the BI EE repository design is to start designing the Business Model Layer for a single Physical table. Any person who is new to BI EE will always start with testing the repository for a single physical table. This is where BI EE

Technical

Inside Oracle's Analytic Applications for Financial Services

If you've been to any of the Oracle BI Applications roadmap presentations, you may well have seen a slide that sets out "Oracle's Integrated Analytic Solution", which looks like this: (from Oracle Business Intelligence Applications Roadmap, Oracle Open World 2009) Now we all know

Technical

Oracle BI EE 10.1.3.4.1 – Multi-Select Prompts, String Aggregation

One of the issues that people often face while using BI EE is the lack of control on Multi-Select prompts. One cannot set Multi-Select prompts to a presentation variable & similarly one cannot display the multi-selected values in a report (only filter view supports the display of all the selected

Technical

Oracle BI EE 10.1.3.4.1 & Essbase Connectivity – Direct MDX Requests – Multiple Measure Dimensions, Varying Attributes & Format Strings

In the last blog entry, i had shown a very simple work around to use direct database requests in BI EE. This capability has quite a few advantages and actually provides a means wherein one can actually create reports using this, wherever BI Server directly cannot(due to inherent limitations

Technical

Oracle BI EE 10.1.3.4.1 – Direct Database Requests & Essbase - Workaround

I got an email (almost 2 weeks back) from one of the BI EE engineers who works on the BI EE – Essbase connectivity. Looks like one of the bugs that i had pointed out in a very old blog entry here [http://oraclebizint.wordpress.com/2008/08/07/bi-ee-10134-bi-publisher-and-mdx-essbase-connectivity/] has

Technical

Oracle EPM 11.1.1.3 – Essbase Clustering for High Availability

Its been almost a couple of weeks since i last blogged due to a flurry of events like Open-World, Training Days, Client Engagements etc. Getting the materials completed took most of my time and since then i haven't had a chance to blog. But now that the busiest

Technical

Early News on the Oracle BI Apps - Essbase Integrator

I was recently going through the recorded Open World sessions using Oracle Open World on Demand [http://openworld.vportal.net/], and came across an interesting session by Alaric Thomas and Mike Nader on the forthcoming Oracle BI Applications to Essbase Integrator. This is a technology project going on within Oracle

Technical

OWB 11gR2 Workspace Creation Issues

First of all, I'd like to thank David Allan of the OWB Product Team for helping me solve the problem I discuss below... and also for identifying what he thinks to be the cause. A few days after Oracle Database 11gR2 was available, I went about building my

Technical

Upgrading an OWB Project to 11gR2

Mark has been out front and center in demonstrating the new features of OWB 11gR2, both in the OWB Unconference [https://www.rittmanmead.com/blog/2009/10/13/calling-all-owb-developers-oow-2009/] and in numerous blog postings [http://www.rittmanmead.com/category/oracle-warehouse-builder/] over the last few months. But one thing we haven&

Technical

Oracle BI EE 10.1.3.4.1 and Essbase Connectivity – Fragmentation on Essbase Sources

In our BI EE – Essbase session in OOW, we covered 2 important use cases in bringing BI EE and Essbase together. They are 1. Horizontal Federation 2. Vertical Federation There is one more use case that only BI EE as a reporting tool can do on an Essbase source(not

Technical

YouTube Video of my "Oracle BI Apps 7.9.5.2 and ODI" Open World Presentation

If you didn't make it to Open World but you were interested in my presentation on ODI and the Oracle BI Applications 7.9.5.2, I just noticed that "aortabisolutions" on Youtube recorded some of the highlights and uploaded the video [http://www.youtube.com/

Technical

Oracle BI EE 10.1.3.4.1 & Essbase Connectivity – Time Based Aggregation and Multiple Queries

A good question came up on our OOW session the other day on BI EE & Essbase connectivity for a means of doing Time Based aggregation on Essbase cubes. Time Based aggregation is a pretty common requirement while doing an Essbase implementation. For more details on what this means, refer

Technical

OLAP 10gR2 and Dense Looping

I'd like to take a moment to express my appreciation to several of the folks at the OLAP product team for their assistance with the project mentioned below, including A.A. Hopeman, Jameson White, Marty Gubar, and especially David Greenfield. The sky's the limit for Oracle

Technical

Oracle Essbase 11.1.1.3 and BI EE 10.1.3.4.1 – Displaying Member Properties – UDAs, Attributes and Alias Tables

Evaluate based MDX functions in BI EE currently do not support the display of quite a few member properties like Generation Number, Level Number, Alias Tables etc. These member properties can be very useful for reporting and sometimes these member properties drive the formatting of data, reporting layouts etc. Though

Technical

Oracle Essbase 11.1.1.3 – Integration with Relational Sources and Applications

In the past i have covered a wide range of integration possibilities of Oracle Essbase with relational sources. This is probably one area that will always evoke interest as from a reporting perspective it is not always possible to maintain the data in only one source(either be it Essbase

Technical

Oracle Buys (Bits Of) Hyperroll

The news hit the wires last night [http://twitter.com/eddieawad/status/4479863911] that Oracle were buying (certain assets of) Hyperroll [http://www.hyperroll.com], a technology company out of Israel with a head office in the USA. Hyperroll have been around for as long as I've been