Database reference - Adventure Works DW

CubeDimension - Date

Dimension properties

name	value
name	Date
parent cube	Mined Customers
id	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 Date Mined Customers Exchange RatesMined Customers Internet CustomersMined Customers Internet OrdersMined Customers Internet Sales

Objects that Mined Customers Date depends on

name	object type	level

Objects that depend on Mined Customers Date

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

Documentation generated by SqlSpec