Search found 9 matches
- 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 …..
- Tue Feb 25, 2020 10:05 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
also see attached
- 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 ...
- 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...
- 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 ...
- 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
https://www.tm1forum.com/viewtopic.php? ... 044#p72044
- 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
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
- 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
https://www.tm1forum.com/viewtopic.php? ... %2A#p55351
- 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 ...