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.
Interpreting / calculating the date in the }tp_application_state cube
- 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
Check out my blog for some good information on TM1, SPSS
-
- 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
You didn't find this one then?
- 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
Thank you Duncan.
Check out my blog for some good information on TM1, SPSS