Creative Aggs Part I : Introduction

Introduction This is part 1 in a series of articles I plan to write over in the coming weeks regarding the use of Aggregate Tables in Analysis Services databases. Some of the techniques covered in this series have been developed after working on some of the largest models around. The series will cover : Introduction Continue reading Creative Aggs Part I : Introduction

Row-based Time Intelligence

For this blog, I want to share an interesting data modelling technique which you might consider when having performance problems with time intelligence calculations. This particular pattern works well on very large data-sets, especially for visuals that contain multiple measures and multiple periods. The idea is to create a Time Intelligence table which contains blocks Continue reading Row-based Time Intelligence

Analysis Services Memory Tip (processing partitions)

The Tip: Convert calculated columns in your model to physical columns (where practical). The Detail If you encounter memory issues when processing partitions in an Analysis Services (AS) database, one option you might consider to resolve this is to convert calculated columns in the offending tables to physical columns. When processing partitions, the AS engine Continue reading Analysis Services Memory Tip (processing partitions)