IBM PA Local 2.0.7: TM1 Web started showing -0

Post Reply
ram3sh
Posts: 4
Joined: Fri Mar 11, 2011 7:26 am
OLAP Product: IBM PA Local
Version: 2.0.7
Excel Version: 2016

IBM PA Local 2.0.7: TM1 Web started showing -0

Post by ram3sh » Mon Jul 08, 2019 1:55 am

We have migrated to IBM PA Local 2.0.7 from IBM Cognos Express 10.1 a fortnight ago. The data rendering/format on the TM1 web as quite ok.
Using the following format at Excel cells
_-* #,##0_-;-* #,##0_-;_-* "-"??_-;_-@_-
able to show/see "-" instead of 0 in the excel client and web client as well.

All of sudden today instead of showing "-" for 0 values, showing " -0" in TM1 web client only. Excel client show the values as anticipated.
Right from Cognos Express 10.1 these excel cells are having the format as _-* #,##0_-;-* #,##0_-;_-* "-"??_-;_-@_-

Could any one help me in resolving this.
Attachments
Capture000.JPG
Capture000.JPG (46.33 KiB) Viewed 345 times

tomok
MVP
Posts: 2561
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: IBM PA Local 2.0.7: TM1 Web started showing -0

Post by tomok » Mon Jul 08, 2019 12:33 pm

There were changes to TM1Web formatting in this release. More than likely this is the culprit. You may have to play with your formatting on these sheets.

https://www.ibm.com/support/knowledgece ... tting.html
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/

Wim Gielis
MVP
Posts: 2087
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0.7
Excel Version: Office 365 - latest
Location: Brussels, Belgium
Contact:

Re: IBM PA Local 2.0.7: TM1 Web started showing -0

Post by Wim Gielis » Mon Jul 08, 2019 1:17 pm

We have seen this as well. It's also to do with some automatic formatting.
Have a look at:
Tm1_64\webapps\tm1web\WEB-INF\configuration\features.json
to the "NewDataFormatter" property.
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 109 TM1 articles and a lot of custom code
Newest blog article: Set up a TM1 service with AutoHotKey

Post Reply