Page 1 of 1
Million second in TI
Posted: Wed Dec 14, 2016 6:44 am
by macsir
Just curious, can we display that?
Re: Million second in TI
Posted: Wed Dec 14, 2016 8:43 am
by Alan Kirk
macsir wrote:Just curious, can we display that?
This question is not entirely clear. A million seconds is about 278 hours, or about 11 1/2 days. Obviously you can display that if you choose.
If you mean million
ths of a second, then as a floating point number, probably (depending on how many significant digits the expression has). But for date and time calculations in TM1, not so much. As Duncan P pointed out
here the real granularity in TM1 is about 1 second.
Re: Million second in TI
Posted: Fri Dec 16, 2016 12:30 pm
by macsir
Thanks, Alan. Yes, I mean the latter.
Re: Million second in TI
Posted: Fri Dec 23, 2016 7:33 am
by macsir
Interestedly, I found there is a new function in PA 2.0, which does give millisecond option. It shows IBM can offer this capability but they didn't provide any date time format function to make it work.
DimensionTimeLastUpdated
This function indicates when a specified dimension was last updated.
The function returns a real number that represents the current day (including the
hour, minute, second, and millisecond) since the beginning of the year 1900.
This is a TM1 TurboIntegrator function, valid only in TurboIntegrator processes.
Syntax
DimensionTimeLastUpdated(dimension);
Argument Description
dimension The name of the dimension.
Example
DimensionTimeLastUpdated(’Region’);
This example returns information on when the Region dimension was last
updated. If a value of 42548.<hours>.<minutes>.<milliseconds> is returned, you
can divide 42548 by 365 to obtain (approximately) 116. When added to the started
of 1900, the result is a current year of 2016.
Re: Million second in TI
Posted: Wed Dec 28, 2016 1:36 am
by macsir
Just finished the code with this function to get millisecond. It should be useful.
Code: Select all
DimName = '}' | GetProcessName() ;
IF(DIMENSIONEXISTS(DimName) = 1);
DIMENSIONDESTROY(DimName);
ENDIF;
DIMENSIONCREATE(DimName);
vDateTimeWithMillisec = NUMBERTOSTRING(DimensionTimeLastUpdated(DimName));
#TIMST use 1960 as starting point however DIMENSIONLASTUPDATED use 1900
#Need to remove the 60 years (21916 days) difference before using it
vDateTime = TIMST(DimensionTimeLastUpdated(DimName) - 21916, '\Y-\m-\d \h:\i:\s',1);
IF(DIMENSIONEXISTS(DimName) = 1);
DIMENSIONDESTROY(DimName);
ENDIF;
vTime = SUBST(vDateTimeWithMillisec, SCAN('.',vDateTimeWithMillisec) , LONG(vDateTimeWithMillisec) - SCAN('.',vDateTimeWithMillisec) + 1);
vHrTime = NUMBERTOSTRING(STRINGTONUMBER(vTime) * 24);
vHr = SUBST(vHrTime, 1, SCAN('.', vHrTime) - 1);
vMiTime = NUMBERTOSTRING( ( STRINGTONUMBER(vHrTime) - STRINGTONUMBER(vHr) ) * 60);
vMi = SUBST(vMiTime, 1, SCAN('.', vMiTime) - 1);
vSecTime = NUMBERTOSTRING( ( STRINGTONUMBER(vMiTime) - STRINGTONUMBER(vMi) ) * 60);
vSec = SUBST(vSecTime, 1, SCAN('.', vSecTime) - 1);
vMisecTime = NUMBERTOSTRING( ( STRINGTONUMBER(vSecTime) - STRINGTONUMBER(vSec) ) * 1000);
vMisec = SUBST(vMisecTime, 1, SCAN('.', vMisecTime) - 1);
LogOutput('INFO', vDateTime | '=' | vDateTimeWithMillisec | '=' | vTime | '=' | vHr | '=' | vMi | '=' | vSec | '=' | vMisec );
LogOutput('INFO', vDateTime | '.' | vMisec );