How to reverse engineer value of column TIM_LVL_MEMBER_ID to get in the date format

Summary:

Hi Team,

As per oracle documentation TIM_LVL_MEMBER_ID from MSC_MEASURE_DATA , is "Start date of the time dimension member.". However its stored as 7 digit numeric value.

Is there anyway to get the dates from this column's value ? Can you pls point out from which table we can get the TIM_LVL_MEMBER_VALUE for the TIM_LVL_MEMBER_ID. I tried using MSC_DIMENSION_TIM_DYD, however getting NULL records for most of the data.

SELECT FROM_DATE FROM MSC_DIMENSION_TIM_DYD D, MSC_MESURE_DATA MMD WHERE D.TIM_LVL_MEMBER_ID = MMD.TIM_LVL_MEMBER_ID.