Interpreting / calculating the date in the }tp_application_state cube
Posted: Thu Feb 07, 2013 4:11 pm
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.
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.
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 (42.47 KiB) Viewed 43825 times