Database reference - Adventure Works DW

CubeDimension - Date

Dimension properties

name	value
name	Date
parent cube	Adventure Works
id	Order Date Key - Dim Time
description
database dimension	Date

Attributes

name	description
Calendar Quarter
Calendar Quarter of Year
Calendar Semester
Calendar Semester of Year
Calendar Year
Day Name
Day of Month
Day of Week
Day of Year
Month of Year
Fiscal Year
Fiscal Quarter
Fiscal Quarter of Year
Fiscal Semester
Fiscal Semester of Year
Month Name
Date
Week of Year

Hierarchies

name	description
Fiscal
Calendar

Dependency graph

Adventure WorksDateAdventure Works Date

Objects that Adventure Works Date depends on

name	object type	level

Documentation generated by SqlSpec