Date Dimension
| Name | ID | Usage | * | ** | Key Columns | Name Column |
|---|---|---|---|---|---|---|
| DIM Date | DIM Date | Key | false |
BBDW_DIM_DATE.DATEDIMID (Integer) |
BBDW_DIM_DATE.ACTUALDATESTRINGDMY (WChar) |
|
| Calendar Year | Calendar Year |
BBDW_DIM_DATE.CALENDARYEAR (SmallInt) |
||||
| Calendar Half | Calendar Half |
BBDW_DIM_DATE.CALENDARHALF (SmallInt) |
||||
| Calendar Half Name | Calendar Half Name |
BBDW_DIM_DATE.CALENDARHALF (SmallInt) |
BBDW_DIM_DATE.CALENDARHALFNAME (WChar) |
|||
| Calendar Quarter | Calendar Quarter |
BBDW_DIM_DATE.CALENDARQUARTER (SmallInt) |
||||
| Calendar Month | Calendar Month |
BBDW_DIM_DATE.CALENDARMONTH (SmallInt) |
||||
| Calendar Week | Calendar Week |
BBDW_DIM_DATE.CALENDARWEEK (SmallInt) |
||||
| Calendar Day of Year | Calendar Dayof Year |
BBDW_DIM_DATE.CALENDARDAYOFYEAR (SmallInt) |
||||
| Fiscal Year | Fiscal Year |
BBDW_DIM_DATE.FISCALYEAR (SmallInt) |
||||
| Fiscal Half | Fiscal Half |
BBDW_DIM_DATE.FISCALHALF (SmallInt) |
||||
| Fiscal Half Name | Fiscal Half Name |
BBDW_DIM_DATE.FISCALHALF (SmallInt) |
BBDW_DIM_DATE.FISCALHALFNAME (WChar) |
|||
| Fiscal Quarter | Fiscal Quarter |
BBDW_DIM_DATE.FISCALQUARTER (SmallInt) |
||||
| Fiscal Month | Fiscal Month |
BBDW_DIM_DATE.FISCALMONTH (SmallInt) |
||||
| Fiscal Month Name | Fiscal Month Name |
BBDW_DIM_DATE.FISCALMONTH (SmallInt) |
BBDW_DIM_DATE.FISCALMONTHNAME (WChar) |
|||
| Fiscal Week No | Fiscal Week |
BBDW_DIM_DATE.FISCALWEEK (SmallInt) |
||||
| Fiscal Day of Year | Fiscal Dayof Year |
BBDW_DIM_DATE.FISCALDAYOFYEAR (SmallInt) |
||||
| Day of Month | Dayof Month |
BBDW_DIM_DATE.DAYOFMONTH (SmallInt) |
||||
| Day of Week | Dayof Week |
BBDW_DIM_DATE.DAYOFWEEK (SmallInt) |
||||
| Day Name | Day Name |
BBDW_DIM_DATE.DAYOFWEEK (SmallInt) |
BBDW_DIM_DATE.DAYNAME (WChar) |
|||
| Is Weekend | Is Weekend |
BBDW_DIM_DATE.ISWEEKEND (Boolean) |
||||
| Is Leap Year | Is Leap Year |
BBDW_DIM_DATE.ISLEAPYEAR (Boolean) |
||||
| Actual Date | Actual Date |
BBDW_DIM_DATE.ACTUALDATE (Date) |
||||
| Sequence | Sequence |
BBDW_DIM_DATE.SEQUENCE (Integer) |
||||
| Calendar Quarter Start Date | Calendar Quarter Start Date |
BBDW_DIM_DATE.CALENDARQUARTERSTARTDATE (Date) |
||||
| Calendar Quarter End Date | Calendar Quarter End Date |
BBDW_DIM_DATE.CALENDARQUARTERENDDATE (Date) |
||||
| Fiscal Quarter Start Date | Fiscal Quarter Start Date |
BBDW_DIM_DATE.FISCALQUARTERSTARTDATE (Date) |
||||
| Fiscal Quarter End Date | Fiscal Quarter End Date |
BBDW_DIM_DATE.FISCALQUARTERENDDATE (Date) |
||||
| Fiscal Year Start Date | Fiscal Year Start Date |
BBDW_DIM_DATE.FISCALYEARSTARTDATE (Date) |
||||
| Fiscal Year End Date | Fiscal Year End Date |
BBDW_DIM_DATE.FISCALYEARENDDATE (Date) |
||||
| Period Start Date | Period Start Date |
BBDW_DIM_DATE.PERIODSTARTDATE (Date) |
||||
| Period End Date | Period End Date |
BBDW_DIM_DATE.PERIODENDDATE (Date) |
||||
| Fiscal Quarter Name | Fiscal Quarter Name |
BBDW_DIM_DATE.FISCALQUARTER (SmallInt) |
BBDW_DIM_DATE.FISCALQUARTERNAME (WChar) |
|||
| Calendar Quarter Name | Calendar Quarter Name |
BBDW_DIM_DATE.CALENDARQUARTER (SmallInt) |
BBDW_DIM_DATE.CALENDARQUARTERNAME (WChar) |
|||
| Actual Date String | Actual Date String |
BBDW_DIM_DATE.DATEDIMID (Integer) |
BBDW_DIM_DATE.ACTUALDATESTRING (WChar) |
|||
| Actual Date String DMY | Actual Date String DMY |
BBDW_DIM_DATE.DATEDIMID (Integer) |
BBDW_DIM_DATE.ACTUALDATESTRINGDMY (WChar) |
|||
| Actual Date String MDY | Actual Date String MDY |
BBDW_DIM_DATE.DATEDIMID (Integer) |
BBDW_DIM_DATE.ACTUALDATESTRINGMDY (WChar) |
|||
| Calendar Half Year Name | Calendar Half Year Name |
BBDW_DIM_DATE.CALENDARYEARHALF (Integer) |
BBDW_DIM_DATE.CALENDARHALFYEARNAME (WChar) |
|||
| Calendar Full Half Year Name | Calendar Full Half Year Name |
BBDW_DIM_DATE.CALENDARYEARHALF (Integer) |
BBDW_DIM_DATE.CALENDARFULLHALFYEARNAME (WChar) |
|||
| Calendar Quarter Year Name | Calendar Quarter Year Name |
BBDW_DIM_DATE.CALENDARYEARQUARTER (Integer) |
BBDW_DIM_DATE.CALENDARQUARTERYEARNAME (WChar) |
|||
| Calendar Full Quarter Year Name | Calendar Full Quarter Year Name |
BBDW_DIM_DATE.CALENDARYEARQUARTER (Integer) |
BBDW_DIM_DATE.CALENDARFULLQUARTERYEARNAME (WChar) |
|||
| Calendar Week Year Name | Calendar Week Year Name |
BBDW_DIM_DATE.CALENDARYEARWEEK (Integer) |
BBDW_DIM_DATE.CALENDARWEEKYEARNAME (WChar) |
|||
| Calendar Full Week Year Name | Calendar Full Week Year Name |
BBDW_DIM_DATE.CALENDARYEARWEEK (Integer) |
BBDW_DIM_DATE.CALENDARFULLWEEKYEARNAME (WChar) |
|||
| Calendar Month Year Name | Calendar Month Year Name |
BBDW_DIM_DATE.CALENDARYEARMONTH (Integer) |
BBDW_DIM_DATE.CALENDARMONTHYEARNAME (WChar) |
|||
| Calendar Full Month Year Name | Calendar Full Month Year Name |
BBDW_DIM_DATE.CALENDARYEARMONTH (Integer) |
BBDW_DIM_DATE.CALENDARFULLMONTHYEARNAME (WChar) |
|||
| Fiscal Half Year Name | Fiscal Half Year Name |
BBDW_DIM_DATE.FISCALYEARHALF (Integer) |
BBDW_DIM_DATE.FISCALHALFYEARNAME (WChar) |
|||
| Fiscal Full Half Year Name | Fiscal Full Half Year Name |
BBDW_DIM_DATE.FISCALYEARHALF (Integer) |
BBDW_DIM_DATE.FISCALFULLHALFYEARNAME (WChar) |
|||
| Fiscal Quarter Year Name | Fiscal Quarter Year Name |
BBDW_DIM_DATE.FISCALYEARQUARTER (Integer) |
BBDW_DIM_DATE.FISCALQUARTERYEARNAME (WChar) |
|||
| Fiscal Full Quarter Year Name | Fiscal Full Quarter Year Name |
BBDW_DIM_DATE.FISCALYEARQUARTER (Integer) |
BBDW_DIM_DATE.FISCALFULLQUARTERYEARNAME (WChar) |
|||
| Fiscal Month Year Name | Fiscal Month Year Name |
BBDW_DIM_DATE.FISCALYEARMONTH (Integer) |
BBDW_DIM_DATE.FISCALMONTHYEARNAME (WChar) |
|||
| Fiscal Full Month Year Name | Fiscal Full Month Year Name |
BBDW_DIM_DATE.FISCALYEARMONTH (Integer) |
BBDW_DIM_DATE.FISCALFULLMONTHYEARNAME (WChar) |
|||
| Fiscal Week Year Name | Fiscal Week Year Name |
BBDW_DIM_DATE.FISCALYEARWEEK (Integer) |
BBDW_DIM_DATE.FISCALWEEKYEARNAME (WChar) |
|||
| Fiscal Full Week Year Name | Fiscal Full Week Year Name |
BBDW_DIM_DATE.FISCALYEARWEEK (Integer) |
BBDW_DIM_DATE.FISCALFULLWEEKYEARNAME (WChar) |
|||
| Fiscal Period Year Name | Fiscal Period Year Name |
BBDW_DIM_DATE.FISCALYEARPERIOD (Integer) |
BBDW_DIM_DATE.FISCALPERIODYEARNAME (WChar) |
|||
| Fiscal Period | Fiscal Period |
BBDW_DIM_DATE.FISCALPERIOD (SmallInt) |
BBDW_DIM_DATE.FISCALPERIOD (WChar) |
|||
| Is Week Day | Is Week Day |
BBDW_DIM_DATE.ISWEEKDAY (Boolean) |
||||
| Calendar Month Name | Calendar Month Name |
BBDW_DIM_DATE.CALENDARMONTH (SmallInt) |
BBDW_DIM_DATE.CALENDARMONTHNAME (WChar) |
|||
| Calendar Date Calculations | Calendar Date Date Calculations | false |
BBDW_DIM_DATE.Calendar_x0020_Date_x0020_Calculations (WChar) |
|||
| Fiscal Date Calculations | Fiscal Date Date Calculations | false |
BBDW_DIM_DATE.Fiscal_x0020_Date_x0020_Calculations (WChar) |
|||
| Is Current Date | ISCURRENTDATE | false | false |
BBDW_DIM_DATE.ISCURRENTDATE (Boolean) |
||
| Is Current Fiscal Week | ISCURRENTFISCALWEEK | false | false |
BBDW_DIM_DATE.ISCURRENTFISCALWEEK (Boolean) |
||
| Is Current Month | ISCURRENTMONTH | false | false |
BBDW_DIM_DATE.ISCURRENTMONTH (Boolean) |
||
| Is Current Calendar Year | ISCURRENTCALENDARYEAR | false | false |
BBDW_DIM_DATE.ISCURRENTCALENDARYEAR (Boolean) |
||
| Is Current Fiscal Quarter | ISCURRENTFISCALQUARTER | false | false |
BBDW_DIM_DATE.ISCURRENTFISCALQUARTER (Boolean) |
||
| Is Current Calendar Quarter | ISCURRENTCALENDARQUARTER | false | false |
BBDW_DIM_DATE.ISCURRENTCALENDARQUARTER (Boolean) |
||
| Is Current Fiscal Year | ISCURRENTFISCALYEAR | false | false |
BBDW_DIM_DATE.ISCURRENTFISCALYEAR (Boolean) |
*AttributeHierarchyVisible
**AttributeHierarchyEnabled
| Name | ID | Levels |
|---|---|---|
| Fiscal Date | Hierarchy 1 |
Fiscal Year, Fiscal Year, Fiscal Year Fiscal Quarter Year Name, Fiscal Quarter, Fiscal Quarter Year Name Calendar Month Year Name, Fiscal Month, Calendar Month Year Name DIM Date, Fiscal Day, DIM Date |
| Fiscal Week | Hierarchy 2 |
Fiscal Year, Fiscal Year, Fiscal Year Fiscal Week Year Name, Fiscal Week, Fiscal Week Year Name |
| Calendar Date | Hierarchy |
Calendar Year, Calendar Year, Calendar Year Calendar Quarter Year Name, Calendar Quarter, Calendar Quarter Year Name Calendar Month Year Name, Calendar Month, Calendar Month Year Name DIM Date, Calendar Day, DIM Date |