Excel Chart Rendering Issue on TM1 Web

[suhamore]

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 497 times

Any pointers to resolve the issue appreciated.

TM1 Version - 9.5.2
Excel Version - 2010

Thanks
Suhamore

[declanr]

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.

[jim wood]

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

[suhamore]

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

[Andy Key]

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.

http://www-01.ibm.com/support/docview.w ... wg27024458, 13th issue on the list.

[suhamore]

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