Forum Discussion

Sergey's avatar
Sergey
Contributor III
3 years ago

Workflow time format is weird

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 Work...
Methodology
  • FrankDK's avatar
    FrankDK
    3 years ago

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

MarkMeader's avatar
MarkMeader
New Contributor III
3 years ago

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'