MDX Studio with Intellisense

Post Reply
User avatar
Eric
MVP
Posts: 373
Joined: Wed May 14, 2008 1:21 pm
OLAP Product: TM1
Version: 9.4
Excel Version: 2003
Location: Chicago, IL USA

MDX Studio with Intellisense

Post by Eric »

How lame am I. In my free time I was reading up on some MDX stuff and look what I found

http://sqlblog.com/blogs/mosha/archive/ ... tudio.aspx
Haven't had time to check it out, but seems like a tool that could be useful for all of us.
Regards,
Eric
Blog: http://tm1-tipz.blogspot.com
Articles: http://www.google.com/reader/shared/use ... /label/TM1


Production: 32 bit 9.0 SP2, Windows 2000 Advanced Server. Web: 32 bit 9.0 SP2, Windows 2000 Server. Excel 2003
robertb
Posts: 2
Joined: Mon Apr 04, 2011 12:37 pm
OLAP Product: TM1
Version: 8.4+9.52
Excel Version: 2003

Re: MDX Studio with Intellisense

Post by robertb »

Hi,

unfortunately it doesn't work with TM1 - Mosha wrote:
MDX Studio doesn't use OLEDB for OLAP in order to connect to SSAS - it uses ADOMD.NET, and therefore it won't be able to connect to other servers which have OLEDB for OLAP providers.
Additionally, MDX Studio contains quite a lot of SSAS specific code, so even if the connection to other servers was possible - MDX Studio simply won't work against them. I don't have any plans in supporting MDX capable servers other than SSAS.

Thanks,
Mosha.

(http://www.ssas-info.com/forum/3-mdx-st ... -providers)
Nevertheless, You can use the online version:
http://mdx.mosha.com/default.aspx

Best regards
Robert
Post Reply