Page 1 of 1

Help Me for coding to Connect to TM1 server and get Chores

Posted: Wed Sep 30, 2009 10:05 am
by smujahid
Hi Techies,

Can you please give the code for connecting to TM1 9.0v server through 9.0 API using Visual Basics 6.0 and get all Chores which are running on server

Thanks
Shaik Mujahid Ullah

Re: Help Me for coding to Connect to TM1 server and get Chores

Posted: Thu Oct 01, 2009 9:58 am
by David Usherwood
I have managed to avoid the API totally in the 14 years I've worked with TM1 - hence I didn't respond to your post (and see nobody else did either). Thinking about it some more, though, there is a 'squiggle' dimension (a control structure) called }Chores. Suggest you write VBA code to read the contents using the 'high-level API' ie the functions available in Excel, specifically SUBSIZ and SUBNM.