MDX Query tool

Post Reply
Herman Moller
Posts: 70
Joined: Thu May 22, 2008 3:38 pm

MDX Query tool

Post by Herman Moller »

Does anyone know of a good tool to assist in creating MDX queries in TM1?

TIA

Herman
Herman Moller
Posts: 70
Joined: Thu May 22, 2008 3:38 pm

Re: MDX Query tool

Post by Herman Moller »

To give a bit more background into the MDX Query tool. I want to create MDX queries using TM1 cube data.

I can use the ODBO tool in TI to assist me in creating a MDX Query but this has limited functionality.The debugger is very limited.

We can generate MDX code using the very useful tool by James Wakefield : TM1 Open Source Workbook which builds MDX queries from TM1 Views. This is good for reference, but I want to know if there are any other tools out there that can help build MDX queries with TM1 data and has better debugging capabilities then the ODBO tool in TI.

TIA
User avatar
Steve Vincent
Site Admin
Posts: 1054
Joined: Mon May 12, 2008 8:33 am
OLAP Product: TM1
Version: 10.2.2 FP1
Excel Version: 2010
Location: UK

Re: MDX Query tool

Post by Steve Vincent »

If you find one, please let us know!

MDX is an issue because TM1 impliments it differently to the original Microsoft designed language, with its own unique codes. Chances of anything out there to help generate MDX for TM1 are very, very small indeed :(
If this were a dictatorship, it would be a heck of a lot easier, just so long as I'm the dictator.
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet
sivan307
Posts: 28
Joined: Wed Sep 01, 2010 2:15 pm
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2007

Re: MDX Query tool

Post by sivan307 »

Hello Herman/Steve:

Did you guys find a better MDX Query tool other than TM1 Open Source Workbook.

Thanks,
Kal
Post Reply