SQLBI - Marco Russo : MDX, SSAS

Learn more about MDX every day

Marco Russo (SQLBI) — Wed, 16 Nov 2011 08:05:37 GMT

I started learning MDX in 1999 and after so many years of using it and teaching it to other people, I still discover something new every day. Not only because I use it in strange ways (well, this doesn’t happen every day, at least!) but because there...(read more)

The Many-to-Many Revolution 2.0 #ssas #mdx #dax #m2m

Marco Russo (SQLBI) — Wed, 09 Nov 2011 12:17:00 GMT

In September 2006 I had announced in this blog the release of the first version of The Many-to-Many Revolution, a whitepaper that describes how to leverage the many-to-many dimension relationships feature that had being available since Analysis Services...(read more)

#MDX Cookbook : a new must read for #SSAS developers

Marco Russo (SQLBI) — Thu, 25 Aug 2011 09:21:38 GMT

There are not so many books about MDX and it’s strange considering that it is a very sophisticated languages that requires years for learning (I’m not kidding). I started learning MDX in 1999 and after so many years, I still have to learn something. I’ve...(read more)

Vote a bug and a missing feature in #powerpivot #denali #ctp3 on #connect

Marco Russo (SQLBI) — Tue, 19 Jul 2011 07:24:00 GMT

If you have 30 seconds available, please vote the following items on Connect: https://connect.microsoft.com/SQLServer/feedback/details/679618/import-attribute-key-from-ssas-in-powerpivot When you import data coming from an Analysis Services cube in PowerPivot,...(read more)

The Microsoft BI Roadmap: BISM, UDM and Beyond

Marco Russo (SQLBI) — Mon, 15 Nov 2010 13:05:00 GMT

Microsoft recently announced a new roadmap for its BI architecture. The next version of SQL Server, codenamed “Denali”, is going to introduce a new semantic model named BISM (Business Intelligence Semantic Model). Analysis Services will host it and it...(read more)

SSAS Performance Tools

Marco Russo (SQLBI) — Sat, 28 Apr 2007 22:31:00 GMT

Chris Webb has recently released a really interesting tool: MDX Script Performance Analyzer. It's a really interesting idea that will save me (and you) a lot of time trying to understand the root of a performance issue into an MDX Script of a cube. Thank you Chris, if I only had this tool three months ago! :-)

Chris has also posted the news of an Analysis Services Load Testing tool that is available on CodePlex. More than the tool, it is the available documentation (which is a draft) that deserves most of your attention, beacuse illustrate you how to setup all the test environment using Visual Studio 2005.

Finally, another interesting document is this post from the SQLCat team about warming up cache in SSAS.