Skip to main content
S
Sergey
October 13, 2022
Solved

Workflow time format is weird

  • October 13, 2022
  • 3 replies
  • 0 views

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

 

Best answer by FrankDK

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")

3 replies

M
MarkMeader
October 13, 2022

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'

C
CAIGuySeanF
June 12, 2025

Thanks for sharing this.. used this matrix to generate case statements in a table viewer sql.

J
JonKunert
October 13, 2022

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

F
FrankDKAnswer
October 14, 2022

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")

S
SergeyAuthor
October 14, 2022

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 !

Terms & ConditionsAccessibility statement