I'm beginning to learn MDX and OLAP databases and was wondering if there's an extension for SSMS that anyone knows about to help writing MDX. Because of some nerve damage to my right hand it wears my right-most two fingers out to hit all the brackets constantly. I'm learning for something that could recognize the measure groups and dimension names and automatically wrap them in the brakcets.
Unfortunately, there is no Intellisense support for MDX in SQL Server 2008 although many people would like to have it and Google finds very few third-party tools. MDX Studio is often mentioned very positively and is still available although it's no longer maintained.
According to MSDN, there is Intellisense for MDX in SQL Server 2012.
But I know very little about MDX so hopefully someone with more hands-on experience may have some ideas.