…brew your own Business Intelligence

Blog

MDX Performance Tip: Move Calculations From the Query to the MDXScript

In the world of business intelligence, most people prefer to embed as much business logic as possible into the ETL and materialize it in the data model (i.e. data mart, cube, tabular model, etc). After all, if we can take the hit during our batch processing window – then that’s […]

Read more

Documenting SSAS Configuration Changes Over Time

I hate documenting just as much as the next developer, which is one of the reasons why I spent some time last week (while on vacation…and by ‘vacation’ I mean ‘nearly breaking my neck snowboarding’ in Telluride) coming up with a method for dynamically capturing SSAS server-level configuration properties.  (definitely […]

Read more

Moving a Cube Partition Without Unprocessing It

Last week I spent some time redesigning a SSAS multidimensional cube and part of that effort involved re-partitioning the measure group by customer (instead of date) and redistributing the partitions across a new set of drives. Initial testing shows serious performance improvement (which I plan to blog about in a […]

Read more

Building an OLAP Farm in the Cloud with Azure Virtual Machines – Part 3

This is the third part in a series of posts on the “OLAP Farm” – which is an Analysis Services architecture that makes use of remote partitions on the backend and linked dimensions and linked measure groups on the front end in order to support solutions where datasets and latency […]

Read more

Building an OLAP Farm in the Cloud with Azure Virtual Machines – Part 2

FYI: the features needed to implement the OLAP Farm architecture (Remote partitions, Remote linked measure groups, Linked dimensions) have been deprecated as of SQL 2014. This is the second part of a series of posts on the “OLAP Farm” – which is an Analysis Services architecture that makes use of remote […]

Read more

SSAS Tabular: Scale-Out Query Architecture

Earlier this week, while discussing high-concurrency architecture options for SSAS multidimensional, a colleague asked about options for SSAS tabular and mentioned there was very little information available online specific to tabular…and so, a blog post is born. The short answer is that Scale-Out Query Architecture for Tabular is essentially identical […]

Read more

Speaking at SQL Saturday #320 – Raleigh, NC

I know, I know… a terrible lack of content here over the past 2 months. Work has been crazy busy since July (read: 65+ hr weeks) and culminated in a (mostly) disconnected and work-free vacation with my favorite wife involving an in-no-hurry drive up the Pacific Coast Highway from San […]

Read more

Jar-O-Skittles: Benefits of Table Partitioning

Quick note to the regular reader: don’t worry, still planning on finishing the series on Building a Scale-Out OLAP Farm in the Cloud with Azure VMs. But I’m afraid there’s not much time to work on that until we ship some important code (which I’ve been working around the clock […]

Read more

Building an OLAP Farm in the Cloud with Azure Virtual Machines – Part 1

FYI: the features needed to implement the OLAP Farm architecture (Remote partitions, Remote linked measure groups, Linked dimensions) have been deprecated as of SQL 2014. The “OLAP Farm” is an Analysis Services architecture that makes use of remote partitions on the backend and linked dimensions and measure groups on the […]

Read more

SSAS Scale-Out Architectures

Processing can be a very resource intensive task which will absolutely interfere with query performance when using a single server deployment. Most clients can get around this issue by simply processing after hours and/or designing and implementing a complex incremental processing scenario (e.g. process add + process partitions). However, when […]

Read more