[PA Express 2.0.6] [TM1Web] websheets: number format corrupted

Post Reply
Patrick Gr
Posts: 9
Joined: Tue Feb 20, 2018 8:56 am
OLAP Product: TM1
Version: 10.2
Excel Version: 2010

[PA Express 2.0.6] [TM1Web] websheets: number format corrupted

Post by Patrick Gr » Tue Sep 03, 2019 11:35 am

Hello Community
I have moved my model from TM1 10.2.2 to PA Express 2.0.6. I noticed that data on websheets doesn’t display properly in web browser (Chrome and IE) as shown in the pictures. The number format has changed in terms of decimals.
Illustration.png
Illustration.png (56.62 KiB) Viewed 232 times
What would be the cause? How to fix it?
About hundreds of web sheets are concerned. Is there a specific configuration that I’m missing?
Thank you again for your time and help.

tomok
MVP
Posts: 2599
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: [PA Express 2.0.6] [TM1Web] websheets: number format corrupted

Post by tomok » Tue Sep 03, 2019 11:44 am

What number format are you using in Excel, General? Make sure you select the proper number format in Excel then republish.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/

User avatar
orlando
Posts: 108
Joined: Fri Aug 04, 2017 8:27 am
OLAP Product: TM1
Version: PAL 2.0
Excel Version: Office 365

Re: [PA Express 2.0.6] [TM1Web] websheets: number format corrupted

Post by orlando » Tue Sep 03, 2019 11:57 am

Hi Patrick,

that's a problem of PA 2.06, if you don't use english as first language in your browser - we had the same issue until we moved to 2.07

https://www-01.ibm.com/support/docview. ... wg27049229
PH05317 SINCE 2.0.6 LOCALIZED NUMBER FORMATTING IN WEBSHEETS IS BROKEN

I've heard that there is a hot fix available (if you can't move to 2.07) - you should ask IBM for it.

Best regards
orlando

Patrick Gr
Posts: 9
Joined: Tue Feb 20, 2018 8:56 am
OLAP Product: TM1
Version: 10.2
Excel Version: 2010

Re: [PA Express 2.0.6] [TM1Web] websheets: number format corrupted

Post by Patrick Gr » Tue Sep 03, 2019 12:04 pm

@tomok: When verifying in Excel, the cells are set to number format with 0 decimals. The display in Excel is good. I replublished to web and still same issue.
@Orland: there is no 2.0.7 version on Express. I will check with IBM if there is a specific Fix Pack for that.

Thank you all!

User avatar
orlando
Posts: 108
Joined: Fri Aug 04, 2017 8:27 am
OLAP Product: TM1
Version: PAL 2.0
Excel Version: Office 365

Re: [PA Express 2.0.6] [TM1Web] websheets: number format corrupted

Post by orlando » Wed Sep 04, 2019 11:56 am

Patrick Gr wrote:
Tue Sep 03, 2019 12:04 pm
@Orland: there is no 2.0.7 version on Express. I will check with IBM if there is a specific Fix Pack for that.
Let us know what IBM said

Patrick Gr
Posts: 9
Joined: Tue Feb 20, 2018 8:56 am
OLAP Product: TM1
Version: 10.2
Excel Version: 2010

Re: [PA Express 2.0.6] [TM1Web] websheets: number format corrupted

Post by Patrick Gr » Mon Sep 09, 2019 2:05 pm

From IBM:
"PH05317 SINCE 2.0.6 LOCALIZED NUMBER FORMATTING IN WEBSHEETS IS BROKEN
This is fixed in 2.0.7
Please upgrade"

User avatar
orlando
Posts: 108
Joined: Fri Aug 04, 2017 8:27 am
OLAP Product: TM1
Version: PAL 2.0
Excel Version: Office 365

Re: [PA Express 2.0.6] [TM1Web] websheets: number format corrupted

Post by orlando » Mon Sep 09, 2019 2:08 pm

Patrick Gr wrote:
Mon Sep 09, 2019 2:05 pm
From IBM:
"PH05317 SINCE 2.0.6 LOCALIZED NUMBER FORMATTING IN WEBSHEETS IS BROKEN
This is fixed in 2.0.7
Please upgrade"
so, there is a PA Express Version 2.07 - or can u use the normal install files?

Patrick Gr
Posts: 9
Joined: Tue Feb 20, 2018 8:56 am
OLAP Product: TM1
Version: 10.2
Excel Version: 2010

Re: [PA Express 2.0.6] [TM1Web] websheets: number format corrupted

Post by Patrick Gr » Fri Sep 13, 2019 1:15 pm

Sorry for the late reply... I've upgraded to 2.0.8 (There is no 2.0.7 in Express)

Post Reply