How to get username with timestamp for last cube update

Post Reply
BariAbdul
Regular Participant
Posts: 424
Joined: Sat Mar 10, 2012 1:03 pm
OLAP Product: IBM TM1, Planning Analytics, P
Version: PAW 2.0.8
Excel Version: 2019

How to get username with timestamp for last cube update

Post by BariAbdul »

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
"You Never Fail Until You Stop Trying......"
tomok
MVP
Posts: 2831
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: How to get username with timestamp for last cube update

Post by tomok »

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.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
User avatar
jim wood
Site Admin
Posts: 3951
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: How to get username with timestamp for last cube update

Post by jim wood »

Couldn't you just get this information from your log files?
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
winsonlee
Regular Participant
Posts: 180
Joined: Thu Jul 01, 2010 3:06 am
OLAP Product: Cognos Express
Version: 9.5
Excel Version: 2007
Location: Melbourne, Australia

Re: How to get username with timestamp for last cube update

Post by winsonlee »

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.
BariAbdul
Regular Participant
Posts: 424
Joined: Sat Mar 10, 2012 1:03 pm
OLAP Product: IBM TM1, Planning Analytics, P
Version: PAW 2.0.8
Excel Version: 2019

Re: How to get username with timestamp for last cube update

Post by BariAbdul »

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.
"You Never Fail Until You Stop Trying......"
winsonlee
Regular Participant
Posts: 180
Joined: Thu Jul 01, 2010 3:06 am
OLAP Product: Cognos Express
Version: 9.5
Excel Version: 2007
Location: Melbourne, Australia

Re: How to get username with timestamp for last cube update

Post by winsonlee »

http://www.tm1forum.com/viewtopic.php?p=16098

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.
BariAbdul
Regular Participant
Posts: 424
Joined: Sat Mar 10, 2012 1:03 pm
OLAP Product: IBM TM1, Planning Analytics, P
Version: PAW 2.0.8
Excel Version: 2019

Re: How to get username with timestamp for last cube update

Post by BariAbdul »

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
"You Never Fail Until You Stop Trying......"
lotsaram
MVP
Posts: 3651
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: How to get username with timestamp for last cube update

Post by lotsaram »

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.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
BariAbdul
Regular Participant
Posts: 424
Joined: Sat Mar 10, 2012 1:03 pm
OLAP Product: IBM TM1, Planning Analytics, P
Version: PAW 2.0.8
Excel Version: 2019

Re: How to get username with timestamp for last cube update

Post by BariAbdul »

Thanks lotsaram,I will give it a go.
"You Never Fail Until You Stop Trying......"
Post Reply