Search found 9 matches

by CaptKirk
Thu Feb 27, 2020 2:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Consolidation sum error - negative weighting
Replies: 8
Views: 3727

Re: Consolidation sum error - negative weighting

Someone will make a motsa if they find a solution for that …..
by CaptKirk
Tue Feb 25, 2020 9:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Consolidation sum error - negative weighting
Replies: 8
Views: 3727

Re: Consolidation sum error - negative weighting

Thankyou for your comments so far, but I do not believe they have hit the nail on the head. Took formatting off, some screen shots attached. I have since noted that in the Month dimension, I was using Whole of Life, which is made up of opening balance (N) but $0, Year (with Months as children), and ...
by CaptKirk
Tue Feb 25, 2020 2:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Consolidation sum error - negative weighting
Replies: 8
Views: 3727

Re: Consolidation sum error - negative weighting

Sorry Alan, I misled you. When exported to excel it has 2 decimal places. When you change the format to increase decimal places, it is all 0's (just to prove it has nothing after the .31). Hence the value is $122,663.31. the value for net commitment in the cube is the value I showed 0.00000000000014...
by CaptKirk
Tue Feb 25, 2020 12:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Consolidation sum error - negative weighting
Replies: 8
Views: 3727

Consolidation sum error - negative weighting

Hello I have searched forum but could not find any postings regarding this Using PA2.0.6, we note the following behaviour MEASURE: Net Commitment (C) = PC Amount (N) - PO Amount (N) PC Amount is 122,663.31 (and when exported to Excel has 20 "0's) after PO Amount is same Net Commitment shows as ...
by CaptKirk
Sun Mar 17, 2019 2:50 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel crashing after export from TM1 Web
Replies: 2
Views: 2932

Re: Excel crashing after export from TM1 Web

I did discover action buttons as images seemed to be causing our issue:
https://www.tm1forum.com/viewtopic.php? ... 044#p72044
by CaptKirk
Sun Mar 17, 2019 2:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Action Buttons and Excel Crashing
Replies: 7
Views: 6322

Re: TM1 Action Buttons and Excel Crashing

Hi
Couple of things I have noticed.
We had an action button as a Background Image - see attachment

1. Excel didn't crash if user had Perspectives
2. Changing this to a normal action button stopped Excel crashing for all users

BrianK
by CaptKirk
Sun Feb 10, 2019 3:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel crashing after export from TM1 Web
Replies: 2
Views: 2932

Re: Excel crashing after export from TM1 Web

I saw lotsaram posted something similar in May 2015, but it was the last post

https://www.tm1forum.com/viewtopic.php? ... %2A#p55351
by CaptKirk
Sun Feb 10, 2019 3:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel crashing after export from TM1 Web
Replies: 2
Views: 2932

Excel crashing after export from TM1 Web

Hello We have had an issue for some time (years) where many TM1 Web users have Excel crash after they export reports to Excel (snapshot). Basically they export (snapshot), and if they save it with the TM1 Action buttons on it, Excel crashes. If they remove the Action Buttons, no crash. This happens ...