Calculation is set to manual. Workbook is calculated inorder to populate with data from the cubes.
Thanks for your response.
Search found 3 matches
- Fri Mar 29, 2013 1:06 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Using VBA to connect to TM1 application
- Replies: 22
- Views: 31703
- Thu Mar 28, 2013 8:47 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Using VBA to connect to TM1 application
- Replies: 22
- Views: 31703
Re: Using VBA to connect to TM1 application
@ lotsaram - Thanks for your response. Our seculity is CAM 5.
I will consider the sheet.copy approach. However, I do have to include a lot of macros with the workbook.
I will consider the sheet.copy approach. However, I do have to include a lot of macros with the workbook.
- Thu Mar 28, 2013 6:18 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Using VBA to connect to TM1 application
- Replies: 22
- Views: 31703
Re: Using VBA to connect to TM1 application
I have to generate 200+ workbooks from a master template. The VBA code to do this opens the template, then populates it with a specific id number from a list of 200+ numbers. The id number matches an id number in a dimension in a TM1 cube. The VBA code executes a TM1 Calculate which populates the wo...