…brew your own Business Intelligence


Latest Posts

  • MDX Script: Calculated Members (vs Named Sets)
    In the previous blog post I discussed the benefits of defining MDX calculations in the cube (instead of in the query using the WITH-clause). The primary benefit was having named sets computed ahead of time (when the MDX Script is executed) and available via the global cache which greatly improves...
    Read more
  • 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
PASS Summit 2015