Does anyone know of a good tool to assist in creating MDX queries in TM1?
TIA
Herman
MDX Query tool
-
- Posts: 70
- Joined: Thu May 22, 2008 3:38 pm
Re: MDX Query tool
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
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
- 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
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
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
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet
-
- Posts: 28
- Joined: Wed Sep 01, 2010 2:15 pm
- OLAP Product: TM1
- Version: 9.5.1
- Excel Version: 2007
Re: MDX Query tool
Hello Herman/Steve:
Did you guys find a better MDX Query tool other than TM1 Open Source Workbook.
Thanks,
Kal
Did you guys find a better MDX Query tool other than TM1 Open Source Workbook.
Thanks,
Kal