企业绩效管理网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 1497|回复: 4

Cannot convert field number 14, value "@None" to a r ...

[复制链接]

74

主题

421

帖子

580

积分

高级会员

Rank: 4

积分
580
QQ
发表于 2014-6-25 18:18:57 | 显示全部楼层 |阅读模式
Hello all,

i try to Import Values from one Cube to another over TI Prozess. The Datasource for the TI Import Process ist a view from the Target Cube

I have no Idea whats wrong and hope someone can help me soon

"@TOT","@TOT","1010","@TOT","@TOT","CAD","@None","@None","REPOBT","BASEET","P10030","AC","1202","@None","1202","0_","200712","Monthly","122604.",Data Source line (1) Error: MetaData procedure line (0): Cannot convert field number 14, value "@None" to a real number.
回复

使用道具 举报

75

主题

385

帖子

554

积分

高级会员

Rank: 4

积分
554
QQ
发表于 2014-6-25 19:37:49 | 显示全部楼层
Hi Christian,

It sounds like Field 14 is a String, not a Numeric value. To use this as a number you need to encapsulate it inside StringToNumber() in the TI process. However, I don't know what you would expect to be able to convert @None into as a real number, so the Metadata process may need some thought.
回复 支持 反对

使用道具 举报

73

主题

409

帖子

584

积分

高级会员

Rank: 4

积分
584
QQ
发表于 2014-6-25 21:34:57 | 显示全部楼层
Christian, check the Variables tab and change the type of any variables that are not guaranteed to always return a numeric value to string. Then in your code you can always apply more convoluted logic, for example check if the variable does not hold "@none" or some other string and if it doesn't just convert it to a number like Chris K has suggested and load to the cube.
回复 支持 反对

使用道具 举报

64

主题

373

帖子

515

积分

高级会员

Rank: 4

积分
515
QQ
发表于 2014-6-25 21:39:06 | 显示全部楼层
qml wrote:...apply more convoluted logic
This was good for a Monday morning laugh.
回复 支持 反对

使用道具 举报

85

主题

433

帖子

616

积分

高级会员

Rank: 4

积分
616
QQ
发表于 2014-6-25 22:46:45 | 显示全部楼层
Found the Solution. It was wrong spelling in the formula. Thanks all for helping me

Chris
回复 支持 反对

使用道具 举报

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

本版积分规则

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

GMT+8, 2022-11-27 01:04 , Processed in 0.072969 second(s), 12 queries , Memcache On.

Powered by Discuz! X3.1 Licensed

© 2001-2013 Comsenz Inc.

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