TM1 Forum

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

TIA

Herman

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

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

Hello Herman/Steve:

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

Thanks,
Kal