Rittman Mead Blog - Business Intelligence

Tagged

BI (General)

A collection of 81 posts

Business Insights

OBIEE11G Scripting – generate XUDML and change the password of the connection pools

Imagine that you want to migrate your RPD to different environments. By using scripting utilities you can generate a new RPD and make changes for the new RPD in the generated file. The original RPD will be exported to UDML or XUDML , in the generated file you can make changes

Business Insights

More Notes on Right-Time BI

Over the past couple of years Stewart Bryson and I have been looking into things "right time" (or is that realtime?). It is great to have him around to trade ideas (and graphics for presentations!). Most of what we have been discussing has been about "traditional reporting&

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

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 Data Warehouse Global Leaders Webcast

I'm honored to be delivering a webcast for the Oracle Data Warehouse Global Leaders Program on Tuesday, March 22 at Noon EST. This is an elite program for key global data warehousing customers and is managed by the Oracle data warehousing product management team. It also provides a

Oracle BI Suite EE

Oracle BI EE 11g - Released & Available for Download

Looks like BI EE 11g silently made it to OTN yesterday. The software is available for download now. It can be downloaded from here [http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bus-intelligence-11g-165436.html] . Currently its available only for Windows (32 bit & 64 bit) & Linux (32 bit &

Oracle BI Suite EE

Kaleidoscope is a Wrap

Every year, ODTUG shows why Kaleidoscope is the premier conference for the technical hacks in all of us. I can't remember a time when I learned so much, had so many great conversations, and felt more at home than this year. The content was spectacular across the board,

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

Oracle 11g Pivot

One of the things that I often come across is the "up-dateable fact", that is a fact that starts life "incomplete" and changes overtime. Examples include things such as support calls that start life as "open" then progress through "responded", "resolved&

To BICC Or Not To BICC (Part 3)

In this, my final post on the BICC subject (well, for now at least...), I take a look at the softer side of BI management... The Balancing Act Put simply, if BI is delivered well it should generate two things.....firstly, answers [no pun intended] to the questions that the

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

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

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

Visualizing relational data as Essbase/OLAP cubes – Partition Outer Joins and MODEL Clauses – Part 3

In a prior blog entry here [http://oraclebizint.wordpress.com/2009/05/16/oracle-bi-ee-10-1-3-4-1-%e2%80%93-report-sum-and-pivot-calculations-%e2%80%93-an-alternative-sql-on-oracle-10g-and-above-%e2%80%93-equivalence-to-mdx-%e2%80%93-model-clause-%e2%80%93-part-2/] , i had shown the advantages of using the MODEL clause. I also showed how the MODEL clause can be used to

Using a PARTITION BY JOIN to Fill In The Gaps

As a quick introduction, I'm Stewart Bryson, Technical Director for North America. It seems strange to be posting an entry on this blog after so many years of reading it, and learning from it. The momentum it has in the community is something I do not take lightly,

Breaking Silence

It is February and I have just realised that I have not added anything to the Rittman Mead Blog this year. Like all of my colleagues, I have been busy working with clients - so far this year I have worked on projects on OBIEE reporting over Oracle e Business

Oracle BI Training Days

Over the past few months the team at Rittman Mead have been busy developing new course content and seeking out suitable venues for our first ever public course, the Oracle BI Training Days [https://www.rittmanmead.com/blog/oracle-bi-training-days-october-22nd-24th-london-uk/] . This course is a fantastic opportunity to learn more about designing,

BI information security

These days there are a wealth of restrictions or regulations (SOX, UK Data Protection Act to name but two) on data access and coupled with the simple commercial need to hide sensitive information that means unfettered access to data warehouse data is a thing of the past. Fortunately products such

Looking at the unstructured

Curt Monash has been talking about text mining [http://www.dbms2.com/2007/10/05/the-four-horsemen-of-data-warehousing/] a lot this week, he also notes [http://www.dbms2.com/2007/10/05/the-four-horsemen-of-data-warehousing/] that, from a text point of view, that the four preeminent database vendors (data store not query tool) are

Data-centric BI trends

I managed to miss Mark Rittman's recent keynote addresses in two locations this week, but I did take a look at the slide deck and the blog [https://www.rittmanmead.com/blog/2007/10/05/five-oracle-bi-trends-for-the-future/] post. Mark is making five very sound points on the Oracle BI

Meetings and other stuff

First up in this hotch-potch (or is it hodge-podge?) is a reminder of a BI meeting in London in a few weeks time; Tuesday September 25 in fact. The UKOUG BIRT SIG meeting [http://ukoug.org/calendar/show_event.jsp?id=2895] (wasn't BIRT SIG a Punk Rocker?

Product dimensions

The other day a colleague invited me to sit in on workshop session with a customer to discuss changes to an attribute of product. On the face of it it sounds a bit of overkill to spend two hours discussing the meaning of just one attribute, but when that attribute

Time series in BI revisited

But before that: > Why are recruitment companies so unnecessarily secretive ?I have just seen an ad for a senior role at a leading Global BI vendor that goes out of its way to hide the name of the company recruiting - it's a bit sad though that

Pattern matching

Tom Kyte posts [http://tkyte.blogspot.com/2007/04/so-in-your-opinion.html] an interesting paper and invites comment. It is not an easy read, and really needs a reasonable understanding of analytic functions, but persevere if you can. To my mind the best place to find patterns is as close to

So what do you call large databases?

I have written recently about the trend towards ever larger databases. But what should we call these VLDB systems? A few years back a set of terms seem to fit well, DSS, MIS, data warehouse, datamart; sometimes the distinction between them was very blurred. But by and large we were