Author Archives: bimatters1403

Hello world!

Welcome to This is your first post. Edit or delete it and start blogging! Advertisements

Posted in Uncategorized | 1 Comment

Regular Expressions for MDX

Introduction Nearly two years ago, Darren Gosbell put online a project to help parsing calculated measures in a MDX script. The implementation was based on the use of regular expressions. Regular expressions can be useful to decompose a MDX query … Continue reading

Posted in MDX | 100 Comments

UPDATE CUBE in subcubes

Introduction Excerpt from BOL: "subcube is a subset of a cube on representing a filtered view of the underlying data". Subcubes can be used for different purposes: Simplify user navigation by displaying only needed cube items. Improve query performance by … Continue reading

Posted in Analysis Services | 9 Comments

Simulating Parent-Child dimension with data on leaf members only

Introduction Parent-child dimensions When SQL Server introduced Parent-Child dimensions with Analysis Services 2000, it came with different options regarding members associated data, also called Data Members. This option could be set via Members With Data property. Excerpt from SSAS 2000 … Continue reading

Posted in Analysis Services | 7 Comments

Analysis Services 2008 Personalization Extensions

Introduction SQL Server Analysis Services 2008 introduces a new feature called Personalization Extensions. As said in book online, "Analysis Services personalization extensions enable developers to create new Analysis Services objects and functionality and to provide these objects and functionality dynamically … Continue reading

Posted in Analysis Services 2008 | 3 Comments

SSAS 2008 MOLAP Writeback (2)

Introduction In a recent post, I started investigating around a new Analysis Services 2008 feature: writeback partition with MOLAP storage. Unfortunately, I got stopped by a bug in SQL Server 2008 CTP 5 which disallowed me from committing my updates. … Continue reading

Posted in Analysis Services 2008 | 7 Comments

SSAS Performance Seeker Bag Pack

Introduction One of the things I have to deal with in an Analysis Services project is performance improvement: faster query, using minimum resources, with maximum concurrency. Performance problems can sometimes be tricky to identify. I’ve set up a bunch of … Continue reading

Posted in Performance | 4 Comments