TM1 Forum

me neither
someone elses code

Hi Wim & John Thanks very much for your help. @Wim - I referred back to you article, and my code is working. Please refer to code below. Thanks both for your help! Regards Chris Sub TM1_ChangeServerName() Dim obj As OLEObject Dim tib As TM1XlCubeView_1_4.TIButton Dim FSO As Object Dim sourceFold...

Hi JohnO I have used the relevant portions of your code, but I keep getting an error message against the "Set tib = sht.OLEObjects(Shape.Name).Object" line of code. Error message = "Run-time error '424' " ; "Object Required". I do have perspectives open. Please refer to...

Hi there I am trying to use VBA to change the Server name for multiple actions buttons (in multiple workbooks) in Perspectives There is an article from Wim Gielis which details exactly how to do this: https://www.wimgielis.com/tm1_actionbuttons_EN.htm Unfortunately, I cannot figure out how to add th...

Hi Guys

How do I manage Pax / Tm1 Application folder security without being forced to use architect?

Regards
Chris

Another question - so if we are using CAM, they user will automatically get added when they first log in. So good news here.
But what if you need to add/remove Tm1 groups? Sounds like you will still need to use architect, and cannot therefore completely ditch it for PAW?

Thx Guys

Hi there I have tried to go through the process of adding a new user in PAW. So, at first glance it seems to work fine - did the csv thing with login ID etc etc, with Directive of ADD. Under Administration, I can see the user there. Happy days. However, if I go to "Manage users and groups"...

Hi Guys Thanks everyone for you feedback. Just a question for you. Say for example, the server has 8 cores, and your process has 3 RunProcess commands. So this will utilise 3 cores. Given your server has 8, this seems like it should not be an issue. However, what if you have a whole lot of chores ac...

Seem to be close to getting this working. (Just need to code/conquer one final part as per below). Used a SQL table to determine when all processes have completed, and thereby control next sequential step Master Process (using 2 cores to run in parallel as an example) Prolog: RUNPROCESS(sProcess, sP...

Seem to be close to getting this working. (Just need to code/conquer one final part as per below). Used a SQL table to determine when all processes have completed, and thereby control next sequential step Master Process (using 2 cores to run in parallel as an example) Prolog: RUNPROCESS(sProcess, sP...

Hi there I have a Dynamic Report with multiple nested rows, and 2 Measure columns. For illustrative purposes, example as follows: Row Dim1 Row Dim2 Row Dim3 Col Measure 1 (e.g. Sales Value) Col Measure 2 (e.g. Description) What I am looking for is a way for the report to run and suppress zeros based...

Hi there I am having the same issue you mentioned that someone put in a previous posts as per below. I am also finding this a bit of a show-stopper. Does anyone have any ideas of how to get around this? Many thx! Regards Chris The biggest problem with this new command is there is no way to know when...

Hi there We are busy migrating from Perspectives to PA. In perspectives, you just browse for the file and locate it in the file system. When setting up a folder in Paw I just get a TimeOut when I browse for folders. Also - will Paw expose folders on the Paw server itself or on the Tm1 Server. Many t...

Hi there We are migrating to PAW from Perspectives/Architect. We are using native security in Architect, and will stick with this for now. To get all the users (set up in Architect), I assume I just need to do a one off import into PAW after which I can then use PAW for all user security administrat...

Thanks @burnstripe!

beginning to think this is not possible on my last point. I would need to user arrays which are not supported

@declanr

Hi there. Thx for your help. The only problem here is that my Version dimension is not always in the same place, so not sure how it is possible to determine the "position" of pDestVer in my CellPutN. Any thoughts?

Hi Guys

A big thank you to all of you. A huge help, and answered my question perfectly!

Regards
Chris

ps Different number of variables - so view applied to Cube 1 will return 5 variables when used as a data source, and 6 variables against cube 2