Hello,
does any of you succeeded in using Mosha Pasumansky's 'MDX Studio' to query a TM1 database ?
It's OK with the ODBO sample application, but I can't find any working connection string for MDX Studio.
click >Here< if you want to have a look.
Regards,
Renaud.
MDX Studio
- 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
Re: MDX Studio
Great minds think alike 

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
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
- Mike Cowie
- Site Admin
- Posts: 483
- Joined: Sun May 11, 2008 7:07 pm
- OLAP Product: IBM TM1/PA, SSAS, and more
- Version: Anything thru 11.x
- Excel Version: 2003 - Office 365
- Location: Alabama, USA
- Contact:
Re: MDX Studio
[quote="Renaud MARTIAL"]does any of you succeeded in using Mosha Pasumansky's 'MDX Studio' to query a TM1 database ?
It's OK with the ODBO sample application, but I can't find any working connection string for MDX Studio.
quote]
Hi Renaud,
I just tried it and no luck for me, either - I'm not sure if MDX Studio has been limited to only support SQL Server 2005 or higher (some posts on its forum seemed to indicate that).
Anyway, I posted a question on their forum and will let you know what I hear back from them.
Regards,
Mike
It's OK with the ODBO sample application, but I can't find any working connection string for MDX Studio.
quote]
Hi Renaud,
I just tried it and no luck for me, either - I'm not sure if MDX Studio has been limited to only support SQL Server 2005 or higher (some posts on its forum seemed to indicate that).
Anyway, I posted a question on their forum and will let you know what I hear back from them.
Regards,
Mike
Mike Cowie
QueBIT Consulting, LLC
Are you lost without Print Reports in Planning Analytics for Excel (PAfE)? Get it back today, for free, with Print Reports for IBM Planning Analytics for Excel!
QueBIT Consulting, LLC
Are you lost without Print Reports in Planning Analytics for Excel (PAfE)? Get it back today, for free, with Print Reports for IBM Planning Analytics for Excel!
Re: MDX Studio
MDX Studio only supports SSAS, and it has quite a lot of SSAS specific code in it, so it won't work with other MDX servers such as TM1.
(Besides it connects through ADOMD.NET, not through OLEDB for OLAP)
(Besides it connects through ADOMD.NET, not through OLEDB for OLAP)
- Mike Cowie
- Site Admin
- Posts: 483
- Joined: Sun May 11, 2008 7:07 pm
- OLAP Product: IBM TM1/PA, SSAS, and more
- Version: Anything thru 11.x
- Excel Version: 2003 - Office 365
- Location: Alabama, USA
- Contact:
Re: MDX Studio
Mosha,
Thanks very much for the reply here. I had a feeling this was the case, but it's good to have confirmation from the source. I look forward to using MDX Studio with Analysis Services in any event... (and will post a note about it in that forum, while I think of it).
Regards,
Mike
Thanks very much for the reply here. I had a feeling this was the case, but it's good to have confirmation from the source. I look forward to using MDX Studio with Analysis Services in any event... (and will post a note about it in that forum, while I think of it).
Regards,
Mike
Mike Cowie
QueBIT Consulting, LLC
Are you lost without Print Reports in Planning Analytics for Excel (PAfE)? Get it back today, for free, with Print Reports for IBM Planning Analytics for Excel!
QueBIT Consulting, LLC
Are you lost without Print Reports in Planning Analytics for Excel (PAfE)? Get it back today, for free, with Print Reports for IBM Planning Analytics for Excel!
- 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
Re: MDX Studio
Mosha - Like Mike said thanks for the post. We were all hopeful!
Everyone Else :*(
Everyone Else :*(
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
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