Forum Discussion

Kamila's avatar
Kamila
Contributor
3 years ago

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.  

  •  

    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's avatar
      Kamila
      Contributor

      This was very helpful, thank you!