Search found 54 matches
- Fri Mar 08, 2019 4:41 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ExecuteProcess not setting ProcessExitWithMessge return code correctly
- Replies: 10
- Views: 6258
Re: ExecuteProcess not setting ProcessExitWithMessge return code correctly
I think you might be getting mixed up with ItemReject. AFAIK LogOutput should not cause any minor error status (in fact would be pretty bad if it did). I will pursue using a global variable instead of the return code... Yes because the software... will not do this, changing the return code, as was ...
- Fri Mar 08, 2019 3:57 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ExecuteProcess not setting ProcessExitWithMessge return code correctly
- Replies: 10
- Views: 6258
Re: ExecuteProcess not setting ProcessExitWithMessge return code correctly
I think you might be getting mixed up with ItemReject. AFAIK LogOutput should not cause any minor error status (in fact would be pretty bad if it did). I agree that LogOutPut should not cause an error status. The way I interpret the TM1 Reference manual is when LogOutPut command writes a message to...
- Fri Mar 08, 2019 3:53 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ExecuteProcess not setting ProcessExitWithMessge return code correctly
- Replies: 10
- Views: 6258
Re: ExecuteProcess not setting ProcessExitWithMessge return code correctly
According to the TI manual , using the logoutput command should cause the return code to be 5, but the return code is zero. I think it's a bug. Was just trying to see if anyone else has experience with this situation. Can you send a link please ? In the IBM PA 2.0 TM1 Reference Manual dated 05/23/2...
- Fri Mar 08, 2019 2:30 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ExecuteProcess not setting ProcessExitWithMessge return code correctly
- Replies: 10
- Views: 6258
Re: ExecuteProcess not setting ProcessExitWithMessge return code correctly
Hi, Bypassing the issue at hand for a while, why don't you use a global variable ? As in (in the calling process): NumericGlobalVariable( 'vFound' ); vFound = 0; ExecuteProcess( '...' ); If( vFound <> 0 ); # ... EndIf; and in the called process: NumericGlobalVariable( 'vFound' ); vFound = ...; Rega...
- Fri Mar 08, 2019 2:28 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ExecuteProcess not setting ProcessExitWithMessge return code correctly
- Replies: 10
- Views: 6258
Re: ExecuteProcess not setting ProcessExitWithMessge return code correctly
Hi, Bypassing the issue at hand for a while, why don't you use a global variable ? As in (in the calling process): NumericGlobalVariable( 'vFound' ); vFound = 0; ExecuteProcess( '...' ); If( vFound <> 0 ); # ... EndIf; and in the called process: NumericGlobalVariable( 'vFound' ); vFound = ...; Rega...
- Thu Mar 07, 2019 8:50 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ExecuteProcess not setting ProcessExitWithMessge return code correctly
- Replies: 10
- Views: 6258
ExecuteProcess not setting ProcessExitWithMessge return code correctly
Using IBM Planning Analytics Local, Version 2.0.6 In the Metadata tab of the first TI Process, it calls a second TI Process with a string parameter. The parameter is a }Client ID which we call SSO. I am attempting to use the ProcessExitWithMessage return code to know whether the SSO exists in a flat...
- Thu Nov 01, 2018 5:01 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PA Case Sensitive vs. TM1 10.2 not case sensitive
- Replies: 6
- Views: 4089
- Thu Nov 01, 2018 2:30 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PA Case Sensitive vs. TM1 10.2 not case sensitive
- Replies: 6
- Views: 4089
PA Case Sensitive vs. TM1 10.2 not case sensitive
Current TM1 version: 10.2.2 FP7 We are very close to starting the switch to IBM Planning Analytics Local 2.0.6. I read somewhere that PA will treat upper and lower case as different values (i.e. it will be case sensitive), versus TM1 historically has been not case sensitive. I inherited many (61, to...
- Mon Jun 25, 2018 3:49 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Issue with feeders
- Replies: 7
- Views: 5246
Re: Issue with feeders
Two suggestions: Stop server, delete .feeders files (if you use persistent feeders), restart server. Even if you're not using persistent feeders I've seen this resolve weird rule anomalies. Post or attach complete rule file, not an excerpt, which can help us rule out a problem elsewhere that's kill...
- Mon Apr 23, 2018 2:31 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Planning Analytics Workspace – Installation issue / IP issue
- Replies: 5
- Views: 6013
Re: Planning Analytics Workspace – Installation issue / IP issue
I have not tried to install PAW local, but I am watching a video on installing PAW local on Windows 2016 server. At around 30 minutes, the video shows that the docker network interface priority has to be changed to a higher number so that the TM1 default public network interface is used. Video link ...
- Mon Aug 28, 2017 3:55 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: VBA Macro errors in Excel 2016
- Replies: 17
- Views: 13084
Re: VBA Macro errors in Excel 2016
And another thing we had to do was to make sure with all the buttons that we set the property "TakeFocusOnClick" to false. We've definitely found Excel 2016 somewhat more "sensitive" shall we say about where it thinks it is and we find we need to be uber-specific about where thi...
- Mon Aug 28, 2017 3:53 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: VBA Macro errors in Excel 2016
- Replies: 17
- Views: 13084
Re: VBA Macro errors in Excel 2016
Just out of curiosity, do you have the same behaviour when you run the macro after opening the workbook from applications vs opening from your local drive/network? My own experience (but could be my machine) is that when I open a workbook from Applications and work with it, I have some inexplicable...
- Mon Aug 28, 2017 1:33 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: VBA Macro errors in Excel 2016
- Replies: 17
- Views: 13084
Re: VBA Macro errors in Excel 2016
Do you disable events and screen updating as one of the first commands when the button is clicked? Thank you. We have already tried the disable events commands, to no avail. We sometimes turn off screen updating in the VBA macros (and on at the end), but I will go through and make sure it is consis...
- Mon Aug 28, 2017 1:32 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: VBA Macro errors in Excel 2016
- Replies: 17
- Views: 13084
Re: VBA Macro errors in Excel 2016
And another thing we had to do was to make sure with all the buttons that we set the property "TakeFocusOnClick" to false. We've definitely found Excel 2016 somewhat more "sensitive" shall we say about where it thinks it is and we find we need to be uber-specific about where thi...
- Thu Aug 24, 2017 2:57 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: VBA Macro errors in Excel 2016
- Replies: 17
- Views: 13084
Re: VBA Macro errors in Excel 2016
So, what happens if you delete and recreate the button in 2016? I just tried that - In Excel 2016, I deleted the form button on the Worksheet and created a new button and assigned it to the same macro. I saved the workbook, exited TM1, logged back into TM1, opened the updated workbook, clicked the ...
- Thu Aug 24, 2017 2:54 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: VBA Macro errors in Excel 2016
- Replies: 17
- Views: 13084
Re: VBA Macro errors in Excel 2016
Hi I few suggestions a) If all the macro is doing is recalculating the sheet then you could possibly replace it with an Action Button. b) Did you install Excel 2016 after installing TM1? If so, try re-installing TM1. There have often been issues with the Microsoft Visual C++ run time library. You m...
- Thu Aug 24, 2017 2:09 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: VBA Macro errors in Excel 2016
- Replies: 17
- Views: 13084
Re: VBA Macro errors in Excel 2016
Why do you activate a range ? OK, fair enough. For a single cell range, I think activate and select end up doing the same thing. I have changed all Range activate command lines to Range Select. The problem persists. However we have found something that points more to a Microsoft issue... We use a b...
- Wed Aug 23, 2017 8:49 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: VBA Macro errors in Excel 2016
- Replies: 17
- Views: 13084
Re: VBA Macro errors in Excel 2016
I have seen this issue before. In my case the culprit was named ranges that had "Workbook" as their scope instead of the particular tab they were in. The fix was to re-do all the named ranges called from the VBA to have a scope equal to the tab they were located in. TIFWIW. I understand. ...
- Wed Aug 23, 2017 8:37 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: VBA Macro errors in Excel 2016
- Replies: 17
- Views: 13084
Re: VBA Macro errors in Excel 2016
Hi I few suggestions a) If all the macro is doing is recalculating the sheet then you could possibly replace it with an Action Button. b) Did you install Excel 2016 after installing TM1? If so, try re-installing TM1. There have often been issues with the Microsoft Visual C++ run time library. You m...
- Wed Aug 23, 2017 2:52 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: VBA Macro errors in Excel 2016
- Replies: 17
- Views: 13084
VBA Macro errors in Excel 2016
Current version in Production: TM1 10.2.2 FP7 Windows Excel Client runs TM1 Perspectives 10.2.2 FP7 and Excel 2007 SP3 MSO 32-bit We have many production TM1 Perspectives Excel workbooks for input and reports that contain bespoke Excel VBA Macros. All the macros work fine in Production. In our Devel...