企业绩效管理网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 970|回复: 6

TI Process : Loading Dates

[复制链接]

81

主题

410

帖子

598

积分

高级会员

Rank: 4

积分
598
QQ
发表于 2014-6-29 22:12:47 | 显示全部楼层 |阅读模式
Folks, frustrations galore.....


Want to load dates from a RDBMS into a TM1 staging cube. Then pass this to a planning cube for use in calculations.

When my target measure 'Estimated Launch Date' is defined as date format, the load fails.
When my target measure 'Estimated Launch Date' is defined as text format, the load works.

When i pass this text to the date field in the planning cube it fails on the 'cell type error'

When passing the date to planning cube it must be a true date as i need to reference it in conditional calcs - 'if started = no, then do ...'

What are the considerations here please ? Do i need to treat the date as numbers then convert ....?

Thanks

Mark
回复

使用道具 举报

70

主题

353

帖子

524

积分

高级会员

Rank: 4

积分
524
QQ
发表于 2014-6-30 00:26:37 | 显示全部楼层
TM1 only has two data types: numeric and string data. You will need to store your dates converted to one of these two types. I personally like to store data as string and with the correct order of Y/M/D you can even compare them, e.g. '2012-09-18' > '2012-09-17' (you can replace the dashes in your format with something else or remove them altogether). If you decide to store dates as numbers (e.g. 20120918 or the excel serial date format 40804) then comparison is just as easy.
回复 支持 反对

使用道具 举报

72

主题

369

帖子

527

积分

高级会员

Rank: 4

积分
527
QQ
发表于 2014-6-30 01:15:59 | 显示全部楼层
@qml

My conditional calc is roughly as follows.

Forecast period Start Date  - setup as DATE format
Forecast period End Date    - setup as DATE format

Product Active? = If 'Estimated Launch Date' falls between these two dates THEN "YES"

I cannot do this if usind differnet data types.  If my 'Estimated Launch Date' is TEXT i cannot include it in my formula.

Ditto for start/end of month Buit-in-functions

Mark
回复 支持 反对

使用道具 举报

87

主题

397

帖子

595

积分

高级会员

Rank: 4

积分
595
QQ
发表于 2014-6-30 02:07:09 | 显示全部楼层
Mark H wrote:Forecast period Start Date  - setup as DATE format
Forecast period End Date    - setup as DATE format
Format is just that...formatting for display purposes. It does not control the data type actually stored in TM1 or the type of comparisons you can do with the data. TM1 only stores two types of data, strings and floating point numeric. My personal preference is to store dates as numeric, just like you would see in Excel, and let the formatting option in TM1 (or Excel, depending on what client you are using) and control how it is displayed.

This post  will tell you all you need to know about dates.

本帖子中包含更多资源

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

x
回复 支持 反对

使用道具 举报

89

主题

395

帖子

598

积分

高级会员

Rank: 4

积分
598
QQ
发表于 2014-6-30 02:20:24 | 显示全部楼层
@tomok

Hadnt spotted that posting.  Thanks

Will try to digest.

Mark
回复 支持 反对

使用道具 举报

93

主题

423

帖子

630

积分

高级会员

Rank: 4

积分
630
QQ
发表于 2014-6-30 02:48:44 | 显示全部楼层
Folks

I followed the instructions provided by Tomok and all works perfectly.

I have attached short document with screen prints to illustrate the instructions.

Thanks

Mark H
回复 支持 反对

使用道具 举报

84

主题

399

帖子

588

积分

高级会员

Rank: 4

积分
588
QQ
发表于 2014-6-30 02:49:45 | 显示全部楼层
Thank You Mark. That document was of real help to my requirment. Thanks for putting it through.
回复 支持 反对

使用道具 举报

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

本版积分规则

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

GMT+8, 2019-3-23 10:36 , Processed in 0.191391 second(s), 17 queries , Memcache On.

Powered by Discuz! X3.1 Licensed

© 2001-2013 Comsenz Inc.

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