SSAS
4 05 2012
I haven’t posted on this for a while as I’ve been neck-deep in a fairly decent sized Business Intelligence project in SQL Server Analysis Services 2008 R2, but have subsequently learnt an enormous amount with regards to performance. So I thought I’d share a list of the biggest things I’ve learnt from various places (mostly […]
28 08 2010
I’ve been dipping my toes into the black art of MDX (or MultiDimensional Expressions) and I had a requirement whilst building a KPI that I needed to get the current date from a Dimension I had called “Date”. I had been linked to this blog: http://my.opera.com/duncans/blog/using-custom-sets-in-analysis-services-to-deliver-special-date-ranges-to-end-use but couldn’t for the life of me get his first […]