企业绩效管理网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 805|回复: 3

TM1 Excel reports and TM1 Web

[复制链接]

74

主题

421

帖子

580

积分

高级会员

Rank: 4

积分
580
QQ
发表于 2014-6-29 22:12:47 | 显示全部楼层 |阅读模式
Hi All,

Can any body clerify my query

We have some Excel reports which are accessed from TM1 perspectives and TM1 Web

BUt when accessed the report from the perspectives will filter the elements from subsets ,As per the formula (SUBNM)when filter the elements can able to pic the elements only which are available in the dimensions ,elements which are not in the dimensions will not pic and display the elements in the report throw the error

When accessing same excel report From TM1 web can able to pic the all elements displaying all the valus with out any error.

Can any body tell what is the difference in funtionality both the excel perspectives and TM1 Web(when using the same report)

Thank you
Praveen
回复

使用道具 举报

85

主题

419

帖子

604

积分

高级会员

Rank: 4

积分
604
QQ
发表于 2014-6-29 23:30:58 | 显示全部楼层
manchala wrote:As per the formula (SUBNM)when filter the elements can able to pic the elements only  which are available in the dimensions ,elements which are not in the dimensions will not pic and display the elements in the report throw the error


First of all can you explain that how can you select a element in Subset Editor (SUBNM) which is not part of the dimension? The Subset Editor only allows you select the elements which are part of the dimension.

Secondly are you passing any values from other cells as a reference to your SUBNM formula? It will be handy if you can share the spreadsheet or atleast the SUBNM formula
回复 支持 反对

使用道具 举报

83

主题

416

帖子

588

积分

高级会员

Rank: 4

积分
588
QQ
发表于 2014-6-30 01:09:53 | 显示全部楼层
HI Rizwan

Thank you for the reply

In the subset having  accoutn manager names and those values not there in the dimensions ,

As per my analaysis in excel repor when we connect from perspectives as per formula(SUBNM) we can select the elements which are available in the diemesions.

Where as same excel report connect from tm1web there we can select the elements which are not available in the dimensions.

May i know what is the diffrence in perspective funtionality and TM1 Web funtionality.

The same SUBNM funtion why funtioning diffrently in TM1web and perspectives.

-Kumar.
回复 支持 反对

使用道具 举报

76

主题

356

帖子

534

积分

高级会员

Rank: 4

积分
534
QQ
发表于 2014-6-30 01:31:26 | 显示全部楼层
manchala wrote:As per my analaysis in excel repor when we connect from perspectives as per formula(SUBNM) we can select the elements which are available in the diemesions.
Where as same excel report connect from tm1web there we can select the elements which are not available in the dimensions.
May i know what is the diffrence in perspective funtionality and TM1 Web funtionality.
The same SUBNM funtion why funtioning diffrently in TM1web and perspectives.
-Kumar.

Inerestingly, the attachment Kumar added has no relation to his question! The attachment describes a problem when data shows up for consolidation elements on TM1 web but not in perspective.

Kumar, may I suggest that you put in the correct attachment?

___________
Java_to_tm1
回复 支持 反对

使用道具 举报

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

本版积分规则

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

GMT+8, 2019-6-19 21:31 , Processed in 0.127172 second(s), 13 queries , Memcache On.

Powered by Discuz! X3.1 Licensed

© 2001-2013 Comsenz Inc.

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