Search found 150 matches

by chewza
Tue May 07, 2024 5:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Email Alerts with PAW
Replies: 3
Views: 1792

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
by chewza
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: 1472

Re: Action Button - Process Failed - with No Log

Thx all - got it sorted! Issue with named range in Excel
by chewza
Thu May 02, 2024 2:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Workflows - Getting started
Replies: 1
Views: 262

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...
by chewza
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: 1472

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!
by chewza
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: 10387

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 ...
by chewza
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: 7179

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...
by chewza
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: 2955

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
by chewza
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: 2602

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
by chewza
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: 777

Re: Action Buttons - VBA to Change Server Name

me neither ;)
someone elses code
by chewza
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: 777

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...
by chewza
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: 777

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...
by chewza
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: 777

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...
by chewza
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: 928

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
by chewza
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: 1672

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?
by chewza
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: 1672

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"...
by chewza
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: 4361

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...
by chewza
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: 4361

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...