Page 1 of 1
TM1 mdx to MS Access
Posted: Mon Apr 20, 2009 4:59 am
by Faizal
Is it possible to right an mdx in MS Access that can read into TM1?
If so, how?
Re: TM1 mdx to MS Access
Posted: Mon Apr 20, 2009 8:12 am
by 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!
Re: TM1 mdx to MS Access
Posted: Mon Apr 20, 2009 11:46 pm
by Faizal
Thanks Steve. But I am going the other way. From TM1 to access and not vice versa.
Re: TM1 mdx to MS Access
Posted: Tue Apr 21, 2009 6:11 am
by 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,
Re: TM1 mdx to MS Access
Posted: Tue Apr 21, 2009 6:16 am
by Alan Kirk
Steve Rowe wrote:
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.