Excel Chart Rendering Issue on TM1 Web

恭喜发财1

Hi All

Excel report published to TM1 Web is not displayed properly. The issues observed are
1. Y axis values (%) are multiplied by 100. e.g. Value 2% in excel is displayed as 200% on web sheet.
2. Data lines and grid lines appear very thin. I changed line thickness in excel, but same is not reflected in web sheet.

                 Chart Display Issue.xlsx        Chart Display Issue on Web sheet        (84.65 KiB) Downloaded 63 times               


Any pointers to resolve the issue appreciated.

TM1 Version - 9.5.2
Excel Version - 2010

Thanks
Suhamore

itoto

Not sure about your second point as I rarely use charts in TM1 Web but as for your first point that just the way TM1 handles percentages.

TM1 handles percentages in "the correct way" if you will i.e. fractions can be converted directly to percentages e.g. 0.5 is 50% (when a TM1 element is formatted as a percentage)

This is in opposition to Excel which just stick a "%" on the end of whatever number you have.

落日清风

Your chart may not render if it includes any VBA / excel macros. These do not work in TM1 Web.

jinanday

jim wood wrote:Your chart may not render if it includes any VBA / excel macros. These do not work in TM1 Web.

Jim,
The chart/report does not have any VBA/excel macros.

Thanks
Suhamore

messiahxu

There are limitations on what you can do with graphs in TM1 Web. Don't forget that what you are seeing in the browser is not the Excel file itself but an XML rendition of the Excel file.

Having said that, the 9.5.2 FP2 fix list suggests that this issue has been fixed.

, 13th issue on the list.

hnhening

hmmm...Looks like upgrade to 9.5.2 FP2 (or better 10) is the only option. Thanks for the help guys.