Rittman Mead Blog - Dimensional Modelling

Tagged

Dimensional Modelling

A collection of 52 posts

Oracle BI Suite EE

MDS XML versus MUDE Part 3: Configuring MDS XML with Git

In the previous installment of this series [https://www.rittmanmead.com/blog/2013/06/mds-xml2/], I gave an overview of MUDE (multi-user development environment), and described it's strengths and weaknesses, hopefully presenting a fair assessment on both sides. For a recap, here are three properties that

Using OBIEE against Transactional Schemas Part 5: Complex Facts

I've finally gotten around to finishing this series... I believe it's actually been a year in the making. I'm planning on being more proactive with getting content on the blog. Actually... the main reason I'm putting this one to bed is I

Using OBIEE against Transactional Schemas Part 4: Complex Dimensions

You guessed it... more on transactional schemas. For a quick recap, here are the posts to date: Using OBIEE against Transactional Schemas Part 1: Introduction [https://www.rittmanmead.com/blog/2012/06/using-obiee-against-transactional-schemas-part-1-introduction/] Using OBIEE against Transactional Schemas Part 2: Aliases [https://www.

Using OBIEE against Transactional Schemas Part 3: Simple Dimensions and Facts

This could be the longest series of blog posts in Rittman Mead history... not in number of posts (this is only the third), but in length of time from start to finish. I don't think that's a record anyone is actively pursuing, nor am I proud

Using OBIEE against Transactional Schemas Part 2: Aliases

It seems like a different life when I posted the introduction to reporting against transactional schemas [https://www.rittmanmead.com/blog/2012/06/using-obiee-against-transactional-schemas-part-1-introduction/] . Since that time, we've had some exciting new customers come aboard, which has required a lot of

Using OBIEE against Transactional Schemas Part 1: Introduction

What’s the pervasive myth surrounding the Oracle Business Intelligence Enterprise Edition (OBIEE) product suite? OBIEE is only useful for reporting against star schemas. It’s true that the Business Model and Mapping (BMM) layer in OBIEE always presents a dimensional model, or star schema, to report developers, but our

Business Insights

Agile Data Warehousing with Exadata and OBIEE: ETL Iteration

This is the fourth entry in my series on Agile Data Warehousing with Exadata and OBIEE. To see all the previous posts, check theintroductory posting [https://www.rittmanmead.com/blog/2011/12/agile-data-warehousing-with-exadata-and-obiee-introduction/] which I have updated with all the entries in the

Business Insights

Agile Data Warehousing with Exadata and OBIEE: Model-Driven Iteration

After laying the groundwork with anintroduction [https://www.rittmanmead.com/blog/2011/12/agile-data-warehousing-with-exadata-and-obiee-introduction/] , and following up with a high-level description of the requiredpuzzle pieces [https://www.rittmanmead.com/blog/2011/12/agile-exadata-obiee-puzzle-pieces/], it's time to

Business Insights

Agile Data Warehousing with Exadata and OBIEE: Puzzle Pieces

In the previous post [https://www.rittmanmead.com/blog/2011/12/agile-data-warehousing-with-exadata-and-obiee-introduction/] , I laid the groundwork for describing Extreme BI: a combination of Exadata and OBIEE delivered with an Agile spirit. I discussed that the usual approach to Agile data warehousing is not

Business Insights

Agile Data Warehousing with Exadata and OBIEE: Introduction

Over the last year, I've been speaking at conferences on one subject more than any others: Agile Data Warehousing with Exadata and OBIEE. Although I've been busy with client work and growing the US business, I realize I need to dedicate more time to blogging again,

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

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

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

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

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

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

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

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

Oracle BI EE 10.1.3.4.1 – Modeling Measure Dimensions on Relational Sources – Essbase Style

One of the biggest differences between Essbase and most other reporting/OLAP tools like BI EE/Oracle OLAP etc is in the way Measures are treated(comparison only in terms of data modeling and reporting and not on physical implementation). In Essbase, every data/value(cell) is attributed by a

Oracle BI EE 10.1.3.4.1 – Modeling Degenerate dimensions – Fact attributes

Degenerate dimensions are quite common when we do a Data Warehouse implementation. They are nothing but a set of dimensions that can be classified as Fact attributes and are hence maintained in the fact table itself instead of separate dimension tables. One of the key advantages of using Degenerate dimensions

Oracle BI EE 10.1.3.4.1 – Understanding Logical Calculations & Native DB Calculations – Repository Modeling

Ever wondered what is the actual difference between the logical calculated measures in the repository and the native DB calculated measures? I have had this question asked to me quite a few times in the recent past that i thought it made sense to create a separate blog entry for

Oracle BI EE 10.1.3.4.1 – Level Based Measures & Grand Totals

One of the features that Oracle could add to BI EE, is in opening up the BI Server in the form of updatable APIs. Currently, the biggest stumbling block is if there are any lack of features we will have to completely depend on Oracle to add that feature. I