Workflow time format is weird

Sergey
Contributor III

Hello !

I've noticed that the workflow time stored in the application is having a weird format, for instance : 

Workflow Time : 022008000 = 2022M5
Workflow Start Time : 2022003000 = 2022M1
Workflow End Time : 2022018000 = 2022M12

The only reason I see for this weird format is on the FX rate table (shown below), as it seems that 2022M1 is in the 4th column (hence 003 if we count column 0), 2022M5 in the 8th column and 2022M12 in the 18th column...

 

--> Is it just a coincidence, or am I assuming correctly the date format ?

 

Sergey_0-1665648371826.png

 

1 ACCEPTED SOLUTION

FrankDK
Contributor

I would recommend using the OneStream API to work with the all kind of data, instead of trying to manipulate data through a SQL query, if that's what your are doing. For the Time Dimension, you can use the TimeDimHelper class to transform between Integer and String types of the Time (eg, TimeDimHelper.GetIdFromName("2021M1")

View solution in original post

4 REPLIES 4

MarkMeader
New Contributor III

Hi.
The time dimensions translate as follows:

000000 = 'FY'
001000 = 'HY1'
002000 = 'Q1'
003000 = 'M1'
004000 = 'M2'
005000 = 'M3'
006000 = 'Q2'
007000 = 'M4'
008000 = 'M5'
009000 = 'M6'
010000 = 'HY2'
011000 = 'Q3'
012000 = 'M7'
013000 = 'M8'
014000 = 'M9'
015000 = 'Q4'
016000 = 'M10'
017000 = 'M11'
018000 = 'M12'

JonKunert
New Contributor III

Dont think of 2022003000 as a format rather it a way of delineating a given column, but you have the right idea.

FrankDK
Contributor

I would recommend using the OneStream API to work with the all kind of data, instead of trying to manipulate data through a SQL query, if that's what your are doing. For the Time Dimension, you can use the TimeDimHelper class to transform between Integer and String types of the Time (eg, TimeDimHelper.GetIdFromName("2021M1")

Sergey
Contributor III

Thanks for your reply !

Actually, I'm using a business rule to create a new scenario on the fly, but I didn't know this Timedimhelper class ! I'll try that !

Thanks !