Jul 06 2009

SQL Aggregate Versus Universe Projection

Categories: Universe Design Dave Rathbun @ 9:55 am

Measure objects are – in my opinion – the most critical objects in your universe. Without them you can only make lists. While lists might be good for a grocery store or library, they don’t do much to help someone run their business. Measures give your universe purpose. They also are the source of most of the design challenges like fan or chasm traps.

In this post I’m going to go back to a basic concept and talk about SQL aggregation and universe projection and how they work together. Continue reading “SQL Aggregate Versus Universe Projection”