Search found 4 matches

by ffp
Fri Nov 15, 2013 6:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PickList not accessible
Replies: 24
Views: 21393

Re: PickList not accessible

I encountered the exact same issue with a static picklist and finally found that it was a security issue : one of the dimensions of the cube where the picklist was set, had element security set to "READ" for a non admin user. This not only prevents the non admin user to write into the cube...
by ffp
Wed Jul 13, 2011 12:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: In VBA code, open an Excel workbook of the applications tree
Replies: 6
Views: 6731

Re: In VBA code, open an Excel workbook of the applications

It would be great if you could let us know how you got on ? I am working on something like this as well. Some of our users are complaining that perspectives is slow ( templates open in approx 10 seconds ). Well, base on the hints of ellissj3, it is technically possible to open an Excel workbook fro...
by ffp
Mon Jul 11, 2011 8:15 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: In VBA code, open an Excel workbook of the applications tree
Replies: 6
Views: 6731

Re: In VBA code, open an Excel workbook of the applications

Hello, I have not used the below code to open the applications, but you might be able to modify to suit your needs. I have used the Log in and open the Server explorer part (application. run "N_Connect" and Application.run "TM1StartOrionWithAutomation". It's your call to keep/de...
by ffp
Fri Jul 08, 2011 3:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: In VBA code, open an Excel workbook of the applications tree
Replies: 6
Views: 6731

In VBA code, open an Excel workbook of the applications tree

Hi all Is there any possibility, from VBA code or from any third party, to call and open a workbook that has been uploaded into the "Applications" tree of TM1 Perspective ? I would like that my VBA macro do this : 1. Log in to TM1 (that's possible through API) 2. Go to the Applications fol...