Interpreting / calculating the date in the }tp_application_state cube

Post Reply
User avatar
sachin
Posts: 92
Joined: Fri Jan 15, 2010 9:54 pm
OLAP Product: Transformer,SSAS, EP, TM1
Version: 7.3 2005 10.1 10.1.1
Excel Version: 2013
Contact:

Interpreting / calculating the date in the }tp_application_state cube

Post by sachin »

I am trying to decipher the value stored in a control cube }tp_Application_State}{GUID} ... this is the cube that gets created behind the scenes when we publish a cube to TM1 Application (aka Contributor)

I took ownership of a node and the StartEditingDate - a dimension element in }tp_node_info, is shown as 1360251535102. When I do the math to arrive at the date (pls see screenshot), I am off by 10 yrs. We are getting reporting questions on the node state in the application and I need to know how to convert this number to actual date and time. If I use my calculation I am off by 10 yrs.

Does anyone have experience on converting this number in }tp_application_state cube to valid date/time? Thank you.
TM1_Post.png
TM1_Post.png (42.47 KiB) Viewed 43328 times
ps: I apologize if this horse has been beat down to death; but I couldn't find any threads and this is the one closest to what I got when I searched.
Check out my blog for some good information on TM1, SPSS
Duncan P
MVP
Posts: 600
Joined: Wed Aug 17, 2011 1:19 pm
OLAP Product: TM1
Version: 9.5.2 10.1 10.2
Excel Version: 2003 2007
Location: York, UK

Re: Using Dates And Times In TM1

Post by Duncan P »

You didn't find this one then?
User avatar
sachin
Posts: 92
Joined: Fri Jan 15, 2010 9:54 pm
OLAP Product: Transformer,SSAS, EP, TM1
Version: 7.3 2005 10.1 10.1.1
Excel Version: 2013
Contact:

Re: Using Dates And Times In TM1

Post by sachin »

Thank you Duncan.
Check out my blog for some good information on TM1, SPSS
Post Reply