In a presentation I’ve been delivering lately, Bus Matrix – the Foundation of your Dimensional Data Model, I briefly cover the hierarchy of an enterprise and how it can be conceptually broken down and mapped into … Continue reading Types of Fact Tables
The Best Book On Dimensional Modeling
The Data Warehouse Toolkit by Ralph Kimball has been read cover to cover by most Data Warehousing and Business Intelligence industry professionals. It is perhaps the most popular text on dimensional modeling known to mankind. … Continue reading The Best Book On Dimensional Modeling
MDX: ParallelPeriod Is Not Calendar Aware (Part 2)
In the last post, we explored the ParallelPeriod function in a bit of detail and then used a contrived example to highlight a particular edge case that needs to be explicitly handled when the number … Continue reading MDX: ParallelPeriod Is Not Calendar Aware (Part 2)
MDX: ParallelPeriod Is Not Calendar Aware
ParallelPeriod is one of the more commonly used MDX functions out there. It’s primary use is in “prior period” calculations such as Prior Year sales (which in turn can be used to calculate Year-over-Year Change … Continue reading MDX: ParallelPeriod Is Not Calendar Aware