O'Reilly logo

Business Intelligence with MicroStrategy Cookbook by Davide Moraschi

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Restricting rows – evaluate on moving dates

Dates are at the core of every BI project and possibly the most used filter conditions in reports. The debate about how to deal with date dimensions is as old as the data warehouse business. I personally am a "surrogate key orthodox" in the sense that I would put surrogate keys on everything that moves. Being a reasonable person I also understand that too much is too much. In small databases with modern SSD drives, the point of creating SK for the date dimension has probably less sense. And—yes, I agree—the calendar isn't likely to change in the lifespan of our BI projects... so the Ides of March will always be the same date.

Hence, the debate goes on, having primary keys as integers or as date datatypes. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required