Intellisense for MDX?
I am starting out with MDX and OLAP databases and wondering if there is an extension for SSMS that anyone knows to help write MDX. Due to some nerve damage with his right hand, he dials my right-most two fingers to constantly hit all the braces. I am looking into something that can recognize measure groups and dimension names and automatically wrap them in a braset.
source to share
Unfortunately, there is no MDX Intellisense support in SQL Server 2008, although many people would love to have it , and Google discovers very few third party party tools. MDX Studio is often mentioned very positively and is still available, although no longer supported.
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 might have some ideas.
source to share
You can try the third party MDXHelper tool (www.mdx-helper.com) which is an IDE for efficiently recording, analyzing, tweaking, debugging MDX and has the following 5 keys:
1. Copy Autocomplete Code Library 2.Code 3.Selecting 4.SQL definition and reassignment formula for dependent base measure (s) 5.MDX Profile collection is parallel
source to share