Database reference - Adventure Works DW

CubeDimension - Ship Date

Dimension properties

name	value
name	Ship Date
parent cube	Mined Customers
id	Ship Date
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

Mined CustomersDateMined Customers Ship Date Mined Customers Internet CustomersMined Customers Internet OrdersMined Customers Internet Sales

Objects that Mined Customers Ship Date depends on

name	object type	level

Objects that depend on Mined Customers Ship Date

name	object type	level
Mined Customers Internet Customers	MeasureGroup	1
Mined Customers Internet Orders	MeasureGroup	1
Mined Customers Internet Sales	MeasureGroup	1

Documentation generated by SqlSpec