Timekey

[Kamila]

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.

[TonyToniTone · Accepted solution]

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.  

[Kamila]

This was very helpful, thank you!