企业绩效管理网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 1011|回复: 5

Excel Chart Rendering Issue on TM1 Web

[复制链接]

86

主题

397

帖子

596

积分

高级会员

Rank: 4

积分
596
QQ
发表于 2014-6-11 11:35:26 | 显示全部楼层 |阅读模式
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

本帖子中包含更多资源

您需要 登录 才可以下载或查看,没有帐号?立即注册

x
回复

使用道具 举报

85

主题

408

帖子

596

积分

高级会员

Rank: 4

积分
596
QQ
发表于 2014-6-11 13:34:18 | 显示全部楼层
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.
回复 支持 反对

使用道具 举报

71

主题

393

帖子

560

积分

高级会员

Rank: 4

积分
560
QQ
发表于 2014-6-11 14:02:12 | 显示全部楼层
Your chart may not render if it includes any VBA / excel macros. These do not work in TM1 Web.
回复 支持 反对

使用道具 举报

67

主题

416

帖子

566

积分

高级会员

Rank: 4

积分
566
发表于 2014-6-11 14:06:01 | 显示全部楼层
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
回复 支持 反对

使用道具 举报

79

主题

383

帖子

562

积分

高级会员

Rank: 4

积分
562
QQ
发表于 2014-6-11 14:16:36 | 显示全部楼层
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.

本帖子中包含更多资源

您需要 登录 才可以下载或查看,没有帐号?立即注册

x
回复 支持 反对

使用道具 举报

86

主题

402

帖子

589

积分

高级会员

Rank: 4

积分
589
QQ
发表于 2014-6-11 15:05:19 | 显示全部楼层
hmmm...Looks like upgrade to 9.5.2 FP2 (or better 10) is the only option. Thanks for the help guys.
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|小黑屋|企业绩效管理网 ( 京ICP备14007298号   

GMT+8, 2023-5-31 03:59 , Processed in 0.083048 second(s), 38 queries .

Powered by Discuz! X3.1 Licensed

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表