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.
IBM PA Local 2.0.7: TM1 Web started showing -0
-
- Posts: 5
- 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
- Attachments
-
- Capture000.JPG (46.33 KiB) Viewed 2171 times
-
- MVP
- Posts: 2836
- 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
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
https://www.ibm.com/support/knowledgece ... tting.html
-
- MVP
- Posts: 3223
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.1.5
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: IBM PA Local 2.0.7: TM1 Web started showing -0
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.
Have a look at:
Tm1_64\webapps\tm1web\WEB-INF\configuration\features.json
to the "NewDataFormatter" property.
Best regards,
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly