Search found 54 matches

by jcr55
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: 6084

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 ...
by jcr55
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: 6084

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...
by jcr55
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: 6084

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...
by jcr55
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: 6084

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...
by jcr55
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: 6084

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...
by jcr55
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: 6084

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...
by jcr55
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: 3959

Re: PA Case Sensitive vs. TM1 10.2 not case sensitive

tomok wrote: Thu Nov 01, 2018 4:23 pm I think they mean PA is case sensitive for TM1 objects like cubes, dimensions, elements, attributes, etc. Not variable names inside a TI process.
OK, great. Thank you to all who responded.
by jcr55
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: 3959

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...
by jcr55
Mon Jun 25, 2018 3:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Issue with feeders
Replies: 7
Views: 5006

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...
by jcr55
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: 5848

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 ...
by jcr55
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: 12842

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...
by jcr55
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: 12842

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...
by jcr55
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: 12842

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...
by jcr55
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: 12842

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...
by jcr55
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: 12842

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 ...
by jcr55
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: 12842

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...
by jcr55
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: 12842

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...
by jcr55
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: 12842

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. ...
by jcr55
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: 12842

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...
by jcr55
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: 12842

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