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
How to get username with timestamp for last cube update
-
- 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
"You Never Fail Until You Stop Trying......"
-
- 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
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.
- 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
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
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- 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
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.
Not through the tm1s.log but through the Transaction Log Query interface.
-
- 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
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......"
-
- 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
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.
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.
-
- 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
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......"
-
- MVP
- Posts: 3652
- 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
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.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
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.
-
- 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
Thanks lotsaram,I will give it a go.
"You Never Fail Until You Stop Trying......"