Many thanks all - got it working now!
Example was just hypothetical - did some additional work to ensure views/subsets unique
Search found 154 matches
- Fri Jun 28, 2024 12:13 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Simple RunProcess - Runs in Serial Mode
- Replies: 3
- Views: 332
- Thu Jun 27, 2024 3:56 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Simple RunProcess - Runs in Serial Mode
- Replies: 3
- Views: 332
Simple RunProcess - Runs in Serial Mode
Hi There Scenario is as follows for using RunProcess with master wrapper: RunProcess => pass parameters such that months 1 to 6 are deleted in destination cube, and months 1 to 6 are copied from source cube RunProcess => pass parameters such that months 6 to 12 are deleted in same destination cube, ...
- Thu Jun 27, 2024 2:58 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Large number of Decimals - unexpected
- Replies: 2
- Views: 341
Re: Large number of Decimals - unexpected
Thanks George!
I have a rule which divides by the value. This then becomes a real issue as you get massive calculated numbers.
Worked my way around this in a rule.
I have a rule which divides by the value. This then becomes a real issue as you get massive calculated numbers.
Worked my way around this in a rule.
- Wed Jun 26, 2024 1:14 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Large number of Decimals - unexpected
- Replies: 2
- Views: 341
Large number of Decimals - unexpected
Hi there I am importing data from a SQL table into a cube, and using CellIncrementN. For some reason I am getting a really small number with a huge number of decimals e.g. 0.000000000000023 I have tested by running the source query in SQL and pasting to Excel. The 16 rows that are returned all displ...
- Tue May 07, 2024 5:05 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Email Alerts with PAW
- Replies: 3
- Views: 2631
Email Alerts with PAW
Hi there
Can anyone recommend a good way to set up email alerts if a process fails? Is there any native functionality built into built into the latest versions of Paw? OR are we still stuck the gold old batch file approach?
Many thanks
Chris
Can anyone recommend a good way to set up email alerts if a process fails? Is there any native functionality built into built into the latest versions of Paw? OR are we still stuck the gold old batch file approach?
Many thanks
Chris
- Fri May 03, 2024 11:41 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Action Button - Process Failed - with No Log
- Replies: 6
- Views: 2464
Re: Action Button - Process Failed - with No Log
Thx all - got it sorted! Issue with named range in Excel
- Thu May 02, 2024 2:25 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Workflows - Getting started
- Replies: 1
- Views: 403
Workflows - Getting started
Hi there Still a relative newbie to PAW. Can anyone point me in the direction of some good collateral on Workflows. Have googled around and checked out youtube, but not somehow not finding anything. In the AMA sessions, sounds like a lot of of new features are also coming along - responsibility hier...
- Thu Apr 11, 2024 5:04 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Action Button - Process Failed - with No Log
- Replies: 6
- Views: 2464
Action Button - Process Failed - with No Log
Hi there
I get a "Process Failed" message from an action button. No error log or entry in Tm1Server log.
Any ideas?
Many thx!
I get a "Process Failed" message from an action button. No error log or entry in Tm1Server log.
Any ideas?
Many thx!
- 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: 10850
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: 7257
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: 7257
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: 3080
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: 2688
- 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: 2688
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: 1052
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: 1052
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: 1052
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: 1052
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: 1030
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: 1961
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?