v_DIM_WEEK
The week dimension lists weeks for a 2 year period. 1 - 104 and 105+.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| WEEKDIMID | int | BBDW.[DIM_WEEK].[WEEKDIMID] | |
| WEEK | nvarchar(10) | yes | BBDW.[DIM_WEEK].[WEEK] |
Definition
Copy
create view [BBDW].[v_DIM_WEEK] as
select
[WEEKDIMID],
[WEEK]
from BBDW.[DIM_WEEK]