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

[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

[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.