Kamila
3 years agoContributor
Timekey
Hello,
Does anybody know what's the logic for TimeKey creation?
As I see it's 10-digits code, but I can't see any logic behind it.
Example:
"TimeKey": 2018003000,
"TimeName": "2018M1".
Thank you.
H1 = 001
Q1 = 002
M1 = 003
M2 = 004
M3 = 005
Q2 = 006
M4 = 007
M5 = 008
M6 = 009
H2 = 010
Q3 = 011
M7 = 012
M8 = 013
M9 = 014
Q4 = 015
M10 = 016
M11 = 017
M12 = 018
The Time MemberId is then constructed like so: 2022003000, which is 2022M1. The numbering convention for the Member ID follows the out of the box Time hierarchy which is static.