Determine the Timeline Granularity

Determine the Timeline Granularity

Timeline granularity is the time measurement unit that you want to use to define effective periods for versions of records. For example, you can choose the effective periods to be in years, months, or seconds. Decide on the timeline granularity and provide the information to the MDM Hub implementers.
You can configure the timeline granularity of year, month, day, hour, minute, or seconds to specify effective periods of data in the
MDM Hub
implementation. You can configure the timeline granularity that you need when you create or update an
Operational Reference Store
.
The timeline granularity that you configure cannot be changed.
When you specify an effective period in any timeline granularity, the system uses the database time locale for the effective periods. To create a version that is effective for one timeline measurement unit, the start date and the end date must be the same.
The following table describes the timeline granularity options that you can configure:
Timeline Granularity
Description
Year
When the timeline granularity is year, you can specify the effective period in the year format, yyyy, such as 2010. An effective start date of a record starts at the beginning of the year and the effective end date ends at the end of the year. For example, if the effective start date is 2013 and the effective end date is 2014, then the record would be effective from 01/01/2013 to 31/12/2014.
Month
When the timeline granularity is month, you can specify the effective period in the month format, mm/yyyy, such as 01/2013. An effective start date of a record starts on the first day of a month. The effective end date of a record ends on the last day of a month. For example, if the effective start date is 02/2013 and the effective end date is 04/2013, the record is effective from 01/02/2013 to 30/04/2013.
Day
When the timeline granularity is day, you can specify the effective period in the date format, dd/mm/yyyy, such as 13/01/2013. An effective start date of a record starts at the beginning of a day, that is 12:00. The effective end date of the record ends at the end of a day, which is 23:59. For example, if the effective start date is 13/01/2013 and the effective end date is 15/04/2013, the record is effective from 12:00 on 13/01/2013 to 23:59 on 15/04/2013.
Hour
When the timeline granularity is hour, the effective period includes the year, month, day and hour. The timeline format is dd/mm/yyyy hh, such as
13/01/2013 15
. An effective start date of a record starts at the beginning of an hour of a day. The effective end date of the record ends at the end of the hour that you specify. For example, if the effective start date is
13/01/2013 15
and the effective end date is
15/04/2013 10
, the record is effective from 15:00 on 13/01/2013 to 10:59 on 15/04/2013.
Minute
When the timeline granularity is minute, the effective period includes the year, month, day, hour, and minute. The format timeline format is dd/mm/yyyy hh:mm, such as
13/01/2013 15:30
. An effective start date of a record starts at the beginning of a minute. The effective end date of the record ends at the end of the minute that you specify. For example, if the effective start date is
13/01/2013 15:30
and the effective end date is
15/04/2013 10:45
, the record is effective from 15:30:00 on 13/01/2013 to 10:45:59 on 15/04/2013.
Second
When the timeline granularity is second, the effective period includes the year, month, day, hour, minute, and second. The timeline format is dd/mm/yyyy hh:mm:ss, such as
13/01/2013 15:30:45
. An effective start date of a record starts at the beginning of a second. The effective end date ends at the end of the second that you specify. For example, if the effective start date is
13/01/2013 15:30:55
and the effective end date is
15/04/2013 10:45:15
, the record is effective from 15:30:55:00 on 13/01/2013 to 10:45:15:00 on 15/04/2013.

0 COMMENTS

We’d like to hear from you!