TM1 mdx to MS Access

[Faizal]

Is it possible to right an mdx in MS Access that can read into TM1?

If so, how?

[Steve Rowe]

I'm pretty sure that you need to use SQL to read from Access since it is a reltaional DB not a OLAP DB.

To do this you need an ODBC conection to the Access DB and then put your access query as the data source on the first page of a TI.

HTH a bit!

[Faizal]

Thanks Steve. But I am going the other way. From TM1 to access and not vice versa.

[Steve Rowe]

Hi Faizal,

I'm not exactly what you wan to do but if you want to launch something from TM1 that either

writes data from Access into TM1
or
writes data from TM1 into Access

then you need to use ODBC / SQL and TI.

If you want to do either of the above but launched from Access then you probably would need MDX to address TM1 but I'm not sure if this possibe, I'd say not but that's just instinct rather than firm knowledge on my part.

Cheers,

[Alan Kirk]

If you want to do either of the above but launched from Access then you probably would need MDX to address TM1 but I'm not sure if this possibe, I'd say not but that's just instinct rather than firm knowledge on my part.

I haven't tried doing anything with MDX, but I DO have to pull values from TM1 into Access (from a process that runs within Access) regularly.

Unfortunately the solution is {everyone please adopt the required expression of horror at the nightmare about to be expressed...} VBA using the TM1 API.

I hadn't said anything in this thread prior to this because obviously an ODBO style solution would be neater, but it's not possible with 8.2.12 and I have yet to explore it in more current (9.x) versions.