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
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 ?

 

 

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

  • FrankDK's avatar
    FrankDK
    Contributor
    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")

    • Sergey's avatar
      Sergey
      Contributor III
      3 years ago

      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 !

  • 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'

  • JonKunert's avatar
    JonKunert
    Contributor II
    3 years ago

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