RittmanMead BI Forum 2010 – Notes III

As said in one the earlier postings about this forum Emiel continued whith his own way of modelling Oracle BI EE. His presentation is a sequel to his last year’s winning presentation.

A few of the things he addressed:

  • User Centric Approach
  • Level of Information
    • BI Maturity (growth)
    • Validation
  • Business Model
    • Know your business
  • Use the (power of) the database
  • Reuse your data

Adam Bloom gave us an impression of the Action Framework in the new (11g ?) release. This new framework consists of:

  • Insight into Action
  • BI on the Business Process
  • BI in the Business Process

It seems like a very powerfull addition to Oracle BI Systems.

Adrian Ward has been given the privillige to host the RittmanMead BI Quiz. This quiz consists of all things you are supposed to know, but sadly overlooked.

The nerdy part of the day started with a debate about modelling your BI System. The debate was hosted by Emiel and Christian.

They divided the debate in;

….  to model what;

  • external information
  • internal information
  • internal processes
  • externalprocesses

….and where to model;

  • Presentation side
  • BI Server
  • Database / DWH
  • (ERP -) System

This subject lead to a lively discussion. In the end I think there is no wrong or right. What I do think is, that when you look at Adam’s presentation, it’s possible that the ERP-system and the BI systems get more and more integrated. The Datawarehouse could be serving as a hub to store and retrieve the data.

We ended with a nice meal and an opportunity to beat Börkur as the ‘Last man standing’. What happened in Brighton stays in Brighton.

More to come.

RittmanMead BI Forum 2010 – Notes II

Some more notes about the RittmanMead BI Forum.

Oracle (Phil Bates, Mike Durran, Adam Bloom) came by to show us something about the 11g Release. The closer they get, the lesser they say about release dates. We have to be patient.

The RittmanMead party committee (Ragnar and Paul) took me out for a night on the town. Thanks for that guys!

This morning had some useful tips from Robin about Performance testing in OBIEE.

  • (Stick to your) Method
  • Use the iterative approach
  • Documentation

Elio did his presentation about Complex Modelling. He started by thanking all the (B)loggers out here. Modelling will be one of the key  subjects for the rest of the day.

Keep you posted.

RittmanMead BI Forum 2010 – Notes I

Today we had a kick-off of the RittmanMead BI Forum with a Masterclass of Kurt Wolff. Kurt is one of the founders of Oracle BI EE as we know the product today. He was there when the product was developed by NQuire in the late nineties.

It was nice to get a whole new perspective on Oracle BI EE. Because he was there from the beginning Kurt is able to clearify some design issues.

Kurt does not preach a best practice, but a possible practice (Kurt’s practice). Some of his statements lead to new insights and several discussions. Maybe some open doors, but absolutely valuable.

Check back to the RittmanMead BI Forum to find the handouts.

A few short notes:

MUD (Multi User Development) –> Kurt has his own ideas of working with repositories. If you start from scratch, you will do it in offline mode. From the moment the RPD is promoted to production, you can manage it in online mode. 

Make sure you have a local copy so you can always go back. Working in online mode shouldn’t be  a problem if the number of developers is limited. Working in timeshifts and in different area’s of the RPD makes this approach even more worth a try.

LTS – Logical Table Sources –> There is a lot to say and to learn about LTS. Kurt goes for one logical fact table with multiple LTS’s (one for each source physical table). Exception for the compound fact column with multiple physical source tables.

I was in the assumption that the BI Server randomly chose a possible LTS. It turns out that picks the LTS based on the smallest Logical Level defined in the Dimension Hierarchy. Each LTS is candidate.

Server Complex Aggregate –> Sometimes, when you defined a calculation in your answer, totals are wrongly calculated. You can put the aggregation rule to; Server Complex Aggregate. It tells the BI Server to go back to the RPD and do calculation by itself as is the column defined in the Logical Layer.

Some nice to know notes:

When you fire a query, it shows ‘Searching’. ‘Querying’ makes more sense. Oracle BI EE was originally meant as some kind of search-engine for structured data.

Answers comes from a ‘Ask Jeeves’ like functionality. Pick up the phone, ask de desired output and the computer provides the output without human interference.

Kurt provided a lot of other handy stuff, which I have to work out for myself. All in all a very nice way to start this forum.

Check Alex’ blog for his notes about this Masterclass.

Looking forward to the rest.

Keep you posted.

RittmanMead BI Forum 2010 – Stay informed

Tomorrow the second RittmanMead BI Forum will start (http://www.rittmanmead.com/2010/05/18/the-day-before-the-bi-forum-2010/). I think it will be informative and fun as well. If you weren’t lucky enough to make it this year, you could still stay informed.

As Mark says, keep an eye out for blogs from some of the attendees and Twitter posts (hashtag #biforum). I will try to post some notes the following days.

The start of OBIBB

Today I started blogging. Yet another blog about Oracle BI related subjects. Working with OBIEE is one of my day to day activities. OBIBB (Oracle BI By Bakboord) will be my platform to share my experiences.  

I will try to express my views on all sorts of subjects related to Oracle and Oracle Business Intelligence. My first posts will cover the Rittman Mead forum (http://www.rittmanmead.com/biforum2010/) , which I will attend later this week