企业绩效管理网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 566|回复: 8

How to get username with timestamp for last cube upd ...

[复制链接]

78

主题

403

帖子

578

积分

高级会员

Rank: 4

积分
578
QQ
发表于 2014-3-15 18:40:23 | 显示全部楼层 |阅读模式
I am trying to get last updated cube timestamp for which I am trying below script :
sFile= ' >cmd /dir *SalesPlan..cub /n/o:n/t:w > Cube_with_last_save_timestamp.txt' ;
ExecuteCommand(sFile,1);
I have also tried without cmd but I am getting error "The system could not find the file specified"
Actually I need to get the user name along with the timestamp who made last update on the cube ,I understand TM1s.log consists the username and the timestamp. How could I leverage it to get username with timestamp. Appreciate your help. Thanks
回复

使用道具 举报

86

主题

396

帖子

584

积分

高级会员

Rank: 4

积分
584
QQ
发表于 2014-3-15 19:43:26 | 显示全部楼层
You realize, of course, that the date and time stamp on the cube and the last time someone updated data in the cube are not related, right? The date and time stamp on the .cub file only get's updated whenever you issue a SaveDataAll command, not necessarily when someone writes to the cube.
回复 支持 反对

使用道具 举报

74

主题

428

帖子

599

积分

高级会员

Rank: 4

积分
599
QQ
发表于 2014-3-15 20:35:15 | 显示全部楼层
Couldn't you just get this information from your log files?
回复 支持 反对

使用道具 举报

76

主题

403

帖子

586

积分

高级会员

Rank: 4

积分
586
QQ
发表于 2014-3-15 20:35:16 | 显示全部楼层
If cube logging is enabled, why not use transaction log to get the required information ?
Not through the tm1s.log but through the Transaction Log Query interface.
回复 支持 反对

使用道具 举报

79

主题

383

帖子

562

积分

高级会员

Rank: 4

积分
562
QQ
发表于 2014-3-15 20:39:59 | 显示全部楼层
Thanks Tomok,Jim,Winson.My apologies for not making my self clear.I need to get the information of username and time stamp who made last update on the cube and store this information in two dimensional cube so that i could input it in to another cube by using CellGetS /CellGetN function.How could I retrieve the latest username and timestamp from Transaction log.Thanks a lot again.
回复 支持 反对

使用道具 举报

85

主题

433

帖子

616

积分

高级会员

Rank: 4

积分
616
QQ
发表于 2014-3-15 21:56:48 | 显示全部楼层


Have a read at the above topic to find out if it is the answer you looking for.
If you do not want to use relational database, you can still loop through the transaction log with TI to read the data back to the cube.

本帖子中包含更多资源

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

x
回复 支持 反对

使用道具 举报

82

主题

368

帖子

553

积分

高级会员

Rank: 4

积分
553
QQ
发表于 2014-3-15 22:01:32 | 显示全部楼层
Thanks Winson,I know there is a WildcardFileSearch function to loop through the Transaction Log but I am not able to get to proceed further beyond this,Could you Please help.Thanks
回复 支持 反对

使用道具 举报

80

主题

399

帖子

573

积分

高级会员

Rank: 4

积分
573
QQ
发表于 2014-3-15 22:29:41 | 显示全部楼层
BariAbdul wrote:Thanks Winson,I know there is a WildcardFileSearch function to loop through the Transaction Log but I am not able to get to proceed further beyond this,Could you Please help.Thanks
BariAbdul, the structure of the tm1s transaction logs is not difficult and can be easily deciphered on simple inspection.  Variability of number of columns per record is not relevant since the user name, timestamp and cube name are always in the same location, only the cell address is variable due to differing numbers of dimensions per cube. Similarly looping through files in a directory with WildcardFileSearch is not rocket science and something you could quite easily find dozens of examples of with a quick search of this forum.

You are straight out asking someone to do your job for you and as you have been told before there are good reasons why "give me the code" questions are viewed rather dimly.
回复 支持 反对

使用道具 举报

72

主题

369

帖子

527

积分

高级会员

Rank: 4

积分
527
QQ
发表于 2014-3-15 23:03:32 | 显示全部楼层
Thanks lotsaram,I will give it a go.
回复 支持 反对

使用道具 举报

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

本版积分规则

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

GMT+8, 2020-10-31 01:00 , Processed in 0.138471 second(s), 13 queries , Memcache On.

Powered by Discuz! X3.1 Licensed

© 2001-2013 Comsenz Inc.

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