企业绩效管理网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 597|回复: 1

String reference to dimension

[复制链接]

96

主题

400

帖子

617

积分

高级会员

Rank: 4

积分
617
QQ
发表于 2014-6-14 19:11:05 | 显示全部楼层 |阅读模式
I was wondering if anybody can lend me a hand. Since its a lil different linking planning with TM1.

I have a data entry cube where there is drop down dates. I need the value from this cell intersection base on the chosen drop down by the user to transfer to its respective date. I decided to create a TM1 cube exactly the same as the data entry cube except it has the date dimension. I was thinking if there's any way to define the dimension intersection to a string element. Cause I'm planning to do if the dimension date and the chosen date of the user is the same. Data should be transferred else it should skip it.

Other approach for a resolution to my problem would be very much appreciated. Thanks guys.
回复

使用道具 举报

66

主题

382

帖子

540

积分

高级会员

Rank: 4

积分
540
发表于 2014-6-14 21:30:14 | 显示全部楼层
Hi, hard to follow your paragraph but would you have an IF argument in either a rule or TI  process

TI method could be like:
#source date format yyyy/mm/dd
myStartMonthN= stringtonumber(subst (s_DateS,6,2)
myStartYear = stringtonumber(subst (s_DateS,1,4));
IF(ATTRn('Month', myMonth, 'Month_Number') = myStartMonth & ATTRn('Year', myloadYear, 'Year_Number') =  myStartYear);
回复 支持 反对

使用道具 举报

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

本版积分规则

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

GMT+8, 2021-10-20 01:18 , Processed in 0.082923 second(s), 11 queries , Memcache On.

Powered by Discuz! X3.1 Licensed

© 2001-2013 Comsenz Inc.

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