10-13-2022 04:08 AM - last edited on 05-03-2023 09:30 AM by JackLacava
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 ?
Solved! Go to Solution.
10-14-2022 04:49 AM
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")
10-13-2022 08:55 AM
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'
10-13-2022 09:01 AM
Dont think of 2022003000 as a format rather it a way of delineating a given column, but you have the right idea.
10-14-2022 04:49 AM
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")
10-14-2022 06:32 AM
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 !