Search found 146 matches
- Wed Nov 08, 2023 2:35 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Tm1 Model - Limit Overall RAM Usage
- Replies: 8
- Views: 10189
Tm1 Model - Limit Overall RAM Usage
Hi there We have inherited a complex model (which is non business critical) which on rare occasions (every few months), start spiking the RAM to a point where the RAM for the entire server maxes out, and all models go down. Obviously we need to get to the root cause of what is causing this (initial ...
- Wed Nov 08, 2023 1:28 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Dynamic subset - Reference cube with different Dimensions
- Replies: 2
- Views: 7108
Re: Dynamic subset - Reference cube with different Dimensions
fantastic - many thx Declan!
- Wed Nov 08, 2023 8:42 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Dynamic subset - Reference cube with different Dimensions
- Replies: 2
- Views: 7108
Dynamic subset - Reference cube with different Dimensions
Hi there I am am trying to create a subset that needs to reference a cube to get a value - in my case, the Current Week. I have seen examples of referencing other cubes in dynamic subsets, but in this case it does not seem to work. The subset I am trying to create is in the "Weeks" dimensi...
- Wed Oct 18, 2023 11:21 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Pafe/PAW View - Auto Spread at Consolidated Level
- Replies: 2
- Views: 2892
Pafe/PAW View - Auto Spread at Consolidated Level
Hi there
In the cube viewer, capturing in data at a consolidated level automatically spreads the data down. Do you know if there is any way to prevent this?
Regards
Chris
In the cube viewer, capturing in data at a consolidated level automatically spreads the data down. Do you know if there is any way to prevent this?
Regards
Chris
- Mon Oct 09, 2023 2:28 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Excel formula with links - Tm1 Web
- Replies: 2
- Views: 2546
- Thu Oct 05, 2023 4:45 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Excel formula with links - Tm1 Web
- Replies: 2
- Views: 2546
Excel formula with links - Tm1 Web
Hi there
Am I correct in saying that if you have a Pafe/Perspectives workbook with Excel cells that are links to other Excel spreadsheets, the values wont resolve in Tm1 web. Pretty sure this could never possibly work, but just thought I'd ask to make sure.
Many thx
Chris
Am I correct in saying that if you have a Pafe/Perspectives workbook with Excel cells that are links to other Excel spreadsheets, the values wont resolve in Tm1 web. Pretty sure this could never possibly work, but just thought I'd ask to make sure.
Many thx
Chris
- Mon Sep 11, 2023 12:50 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Action Buttons - VBA to Change Server Name
- Replies: 6
- Views: 679
Re: Action Buttons - VBA to Change Server Name
me neither
someone elses code
someone elses code
- Mon Sep 11, 2023 10:09 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Action Buttons - VBA to Change Server Name
- Replies: 6
- Views: 679
Re: Action Buttons - VBA to Change Server Name
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...
- Mon Sep 11, 2023 8:37 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Action Buttons - VBA to Change Server Name
- Replies: 6
- Views: 679
Re: Action Buttons - VBA to Change Server Name
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...
- Sun Sep 10, 2023 5:49 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Action Buttons - VBA to Change Server Name
- Replies: 6
- Views: 679
Action Buttons - VBA to Change Server Name
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...
- Tue Jul 25, 2023 7:33 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Pax Application Folder Security - How to Manage
- Replies: 3
- Views: 904
Pax Application Folder Security - How to Manage
Hi Guys
How do I manage Pax / Tm1 Application folder security without being forced to use architect?
Regards
Chris
How do I manage Pax / Tm1 Application folder security without being forced to use architect?
Regards
Chris
- Wed Jul 19, 2023 12:29 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Adding a New User in Paw - not appearing
- Replies: 5
- Views: 1563
Re: Adding a New User in Paw - not appearing
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?
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?
- Wed Jul 19, 2023 12:23 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Adding a New User in Paw - not appearing
- Replies: 5
- Views: 1563
- Tue Jul 18, 2023 8:35 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Adding a New User in Paw - not appearing
- Replies: 5
- Views: 1563
Adding a New User in Paw - not appearing
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"...
- Mon Jun 19, 2023 11:07 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Run Process - How to Determine When All Completed.
- Replies: 24
- Views: 4050
Re: Run Process - How to Determine When All Completed.
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...
- Fri Jun 16, 2023 11:25 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Run Process - How to Determine When All Completed.
- Replies: 24
- Views: 4050
Re: Run Process - How to Determine When All Completed.
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...
- Fri Jun 16, 2023 11:23 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Run Process - How to Determine When All Completed.
- Replies: 24
- Views: 4050
Re: Run Process - How to Determine When All Completed.
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...
- Wed Jun 14, 2023 5:25 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Dynamic Rpt - Supress Rows Based on Measure in 1st Col only
- Replies: 1
- Views: 705
Dynamic Rpt - Supress Rows Based on Measure in 1st Col only
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...
- Mon Jun 12, 2023 11:17 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Run Process - How to Determine When All Completed.
- Replies: 24
- Views: 4050
Run Process - How to Determine When All Completed.
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...
- Mon Jun 05, 2023 11:59 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Paw - Ti Process to Import Files Issue
- Replies: 0
- Views: 10507
Paw - Ti Process to Import Files Issue
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...