企业绩效管理网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 191|回复: 1

Element type

[复制链接]

78

主题

403

帖子

578

积分

高级会员

Rank: 4

积分
578
QQ
发表于 2014-3-15 17:01:49 | 显示全部楼层 |阅读模式
Hi All,

If an element type is "Simple" which means numberic data type, but we need the data to be string when some conditions met (with rule function "IF"), is there a rule function to enable the cell to demonstrate string value.
回复

使用道具 举报

86

主题

397

帖子

596

积分

高级会员

Rank: 4

积分
596
QQ
发表于 2014-3-15 18:18:31 | 显示全部楼层
No. Add another dimension to your cube with 2 elements; "Amount" (classfied as simple) and "Text" (classified as string data). Of course, you don't have to call your elements that but you get the idea. This gives you the ability to store numeric and/or string data for each intersection of all your other dimensions.

Technically, you could also leave the original element typed as string and store either text or numbers in it (because numbers are also characters) but your hierarchy points won't work as expected. String data can't be the summed like numeric data so in essence, your cube will become a flat hierarchy with all levels in each dimension becoming a leaf as far as data storage is concerned. Not to mention whatever issues you'll run into with reports, having to convert numeric data that was stored as a string back to a number. I do this on occasion, storing numeric data in a string element, but mostly for element attributes, not entire cubes.
回复 支持 反对

使用道具 举报

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

本版积分规则

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

GMT+8, 2020-11-24 14:39 , Processed in 0.164349 second(s), 17 queries , Memcache On.

Powered by Discuz! X3.1 Licensed

© 2001-2013 Comsenz Inc.

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