Stewart Bryson - Rittman Mead (Page 2)

Oracle OLAP 11gR2 and Single-line Indexed Attributes

Just a quick post today to demonstrate an issue I ran into with an Oracle OLAP 11gR2 dimension today. I was maintaining the dimension when I encountered the following error: [https://www.rittmanmead.com/blog/content/images/2016/05/05273single-level-dimensions.png] I found Oracle support document1258925.1 [https://support.oracle.

Oracle BI Suite EE

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

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

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

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 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

RMOUG in the Books

It was another excellent year at RMOUG, or the Rocky Mountain Oracle Users Group for the laymen in the audience. This is the first Oracle conference I can remember where I was the sole Rittman Mead speaker. That is because Mark Rittman has been so busy lately with Oracle Master

Oracle BI Suite EE

Looking forward to RMOUG

I'm currently on a plane headed to Denver for the annual RMOUG Training Days conference. This is my second year speaking at RMOUG, which is the largest regional Oracle user group conference in the country (or so they tell me). RMOUG always has a strong database and DBA

OBIEE 11g Migrations

Mark and Venkat have covered OBIEE migration methodologies in the past (see here [https://www.rittmanmead.com/blog/2010/09/oracle-bi-ee-11g-incremental-web-catalog-migration-patching-web-catalogs/] , here [https://www.rittmanmead.com/blog/2010/09/oracle-bi-ee-11g-%E2%80%93-patching-repositories-and-migration-from-development-to-production/] and here [https://www.rittmanmead.com/blog/2010/07/obiee-11gr1-incremental-patches-to-the-rpd/]), but I decided to throw my hat

Technical

Transcend Part 2: Dimensions

In the last post [https://www.rittmanmead.com/blog/2010/12/01/transcend-part-1-mappings/], I described the concept of a "Mapping" entity in Transcend as a bundling of pre- and post-mapping processes that can be executed with a single call. The "Dimension" entity is very similar. In

Technical

Transcend Part 1: Mappings

If you read the blog regularly, then you know that Rittman Mead offers a product called Transcend that is designed to interact with the Oracle Database to make some of the heavy-lifting in ETL mappings very simple. Because we recently released version 2.5 of Transcend, I thought I'

Technical

Partitioning Fact Tables, Part 1

I'm dogmatic about certain aspects of data warehousing. For instance, fact tables should be range partitioned by DATE. I tell my clients all the time: you will have a very difficult time persuading me otherwise. But they always try: they argue about all the attributes that are more

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,

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

Technical

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'

Technical

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&

Technical

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

Technical

Transcend and Segment-Switching

As you read this most recent post on the capabilities of Transcend, I'd like to pose a question to you: would you consider using Transcend in your environment if it was open-sourced? Currently, we implement Transcend as part of the Rittman Mead Rapid Deployment Framework for our clients,

Technical

Atlanta BI Users Group Meeting

Rittman Mead is proud to announce our sponsorship of the February meeting of the Atlanta BI Users Group [http://communities.ioug.org/Home/BIRUGs/AtlantaBIUsersGroup/tabid/104/Default.aspx] , a regional special interest group with involvement from IOUG, ODTUG the IOUG BIWA SIG, and the Georgia Oracle Users Group (GOUSER)

Technical

Off to Denver

I'm sitting in the Atlanta airport waiting for my flight to Denver to go to the RMOUG Training Days, which I described here [https://www.rittmanmead.com/blog/2010/01/27/rmoug-training-days/]. It's snowing (again) in Atlanta, but not very much this time, and I think

Technical

Data Warehouse Fault Tolerance Part 3: Restoring

Hopefully you've read the introduction [https://www.rittmanmead.com/blog/2010/02/02/data-warehouse-fault-tolerance-an-introduction/], Part 1 [https://www.rittmanmead.com/blog/2010/02/08/data-warehouse-fault-tolerance-part-1-resuming/], and Part 2 [https://www.rittmanmead.com/blog/2010/02/10/data-warehouse-fault-tolerance-part-2-restarting/]. Those posts detailed methods for building fault-tolerant ETL code, with a

Technical

Data Warehouse Fault Tolerance Part 2: Restarting

In my last post [https://www.rittmanmead.com/blog/2010/02/08/data-warehouse-fault-tolerance-part-1-resuming/], I described the First "R" in data warehouse fault tolerance: Resuming. As I mentioned in the introduction [https://www.rittmanmead.com/blog/2010/02/02/data-warehouse-fault-tolerance-an-introduction/] to this series, my goal is a triage approach

Technical

Data Warehouse Fault Tolerance Part 1: Resuming

In the introduction [https://www.rittmanmead.com/blog/2010/02/02/data-warehouse-fault-tolerance-an-introduction/] to this series of posts, I spoke briefly about data warehouse fault tolerance and the unique challenges resulting from high data volumes combined the batch load window required to create them. I then defined the goal: a layered