Jump to: navigation, search

Time Attributes

The following Attributes are available in this folder and are described on this page.


Folder: Time

Attribute name: Date
Folder: Time
Description: Enables data within the reporting interval to be organized by a particular date. This attribute is used for internal computations.
Database table: DATE_TIME.CAL_DATE
>> Back to list
Attribute name: Date Range
Folder: Time
Description: Enables data to be organized by a date range within the reporting interval. This attribute is used for internal computations.
Database table: RELATIVE_RANGE.RANGE_NAME
>> Back to list
Attribute name: Day
Folder: Time
Description: Enables data within the reporting interval to be organized by a particular day within a month and year. Day values are presented in YYYY-MM-DD format.
Database table: FORECAST_DATE_TIME.LABEL_YYYY_MM_DD, DATE_TIME.LABEL_YYYY_MM_DD
>> Back to list
Attribute name: Hour
Folder: Time
Description: Enables data within the reporting interval to be organized by a particular hour within a day. Hour values are presented in YYYY-MM-DD-HH24 format.
Database table: FORECAST_DATE_TIME.LABEL_YYYY_MM_DD_HH24, DATE_TIME.LABEL_YYYY_MM_DD_HH24
>> Back to list
Attribute name: Month
Folder: Time
Description: Enables data within the reporting interval to be organized by a particular month within a year. Month values are presented in YYYY-MM format.
Database table: FORECAST_DATE_TIME.LABEL_YYYY_MM, DATE_TIME.LABEL_YYYY_MM
>> Back to list
Attribute name: Month Year Ago
Folder: Time
Description: This attribute is used in the Interaction Volume Summary Report to enable year-by-year comparisons of data that is aggregated by month. This attribute is specifically for the first year of the comparison. Month values are presented in YYYYMM format.
Database table: DATE_TIME_YEAR_AGO.LABEL_YYYY_MM
>> Back to list
Attribute name: Month Year Next
Folder: Time
Description: This attribute is used in the Interaction Volume Summary Report to enable year-by-year comparisons of data that is aggregated by month. This attribute is specifically for the second year of the comparison. Month values are presented in YYYY-MM format.
Database table: DATE_TIME_YEAR_NEXT.LABEL_YYYY_MM
>> Back to list
Attribute name: Quarter
Folder: Time
Description: Enables data within the reporting interval to be organized by a particular quarter within a year. Quarter values are presented in YYYY-QQ format.
Database table: FORECAST_DATE_TIME.LABEL_YYYY_QQ, DATE_TIME.LABEL_YYYY_QQ
>> Back to list
Attribute name: Start Date Time Key
Folder: Time
Description: Reserved for internal use to employ a key for a particular date and time from the relevant hierarchies.
Database table: AG2_*.DATE_TIME_KEY
>> Back to list
Attribute name: Start Date Time Key IF
Folder: Time
Description: Reserved for internal use to employ a key for a particular date and time from the relevant hierarchies. (INTERACTION_FACT)
Database table: INTERACTION_FACT_GI2.START_DATE_TIME_KEY
>> Back to list
Attribute name: Start Date Time Key IRF
Folder: Time
Description: Reserved for internal use to employ a key for a particular date and time from the relevant hierarchies. (INTERACTION_RESOURCE_FACT)
Database table: INTERACTION_RESOURCE_FACT_GI2.START_DATE_TIME_KEY
>> Back to list
Attribute name: Start Date Time Key SSF
Folder: Time
Description: Reserved for internal use to employ a key for a particular date and time from the relevant hierarchies. (SDR_SESSION_FACT)
Database table: SDR_SESSION_FACT.START_DATE_TIME_KEY
>> Back to list
Attribute name: Start Date Time Key SSuF
Folder: Time
Description: Reserved for internal use to employ a key for a particular date and time from the relevant hierarchies. (SDR_SURVEY_FACT)
Database table: SDR_SURVEY_FACT.START_DATE_TIME_KEY
>> Back to list
Attribute name: Subhour
Folder: Time
Description: Enables data within the reporting interval to be organized by 15- or 30-minute time periods. The periods start either at the beginning of an hour, 15, or 30 minutes into the hour.
Database table: FORECAST_DATE_TIME.LABEL_YYYY_MM_DD_HH24_30INT, DATE_TIME.LABEL_YYYY_MM_DD_HH24_30INT or FORECAST_DATE_TIME.LABEL_YYYY_MM_DD_HH24_15INT, DATE_TIME.LABEL_YYYY_MM_DD_HH24_15INT
>> Back to list
Attribute name: Week
Folder: Time
Description: Enables data within the reporting interval to be organized by a particular week within a year. Week values are presented in YYYY-WE format.
Database table: DATE_TIME.LABEL_YYYY_WE
>> Back to list
Attribute name: Year
Folder: Time
Description: Enables data within the reporting interval to be organized by year, in four-digit format (YYYY).
Database table: FORECAST_DATE_TIME.LABEL_YYYY, DATE_TIME.LABEL_YYYY
>> Back to list
This page was last edited on June 10, 2020, at 18:16.
blog comments powered by Disqus