Database reference - Adventure Works DW

CubeDimension - Employee

Dimension properties

name	value
name	Employee
parent cube	Adventure Works
id	Dim Employee
description
database dimension	Employee

Attributes

name	description
Base Rate
Birth Date
Department Name
Email Address
Emergency Contact Name
Emergency Contact Phone
Status
End Date
Employee
Gender
Hire Date
Hire Year
Login ID
Manager SSN
Marital Status
Employees
Pay Frequency
Phone
Salaried Flag
Sales Person Flag
Sales Territory Key
Sick Leave Hours
SSN
Start Date
Title
Vacation Hours

Hierarchies

name	description
Employee Department

Perspectives where visible

name
Channel Sales
Sales Targets

Dependency graph

Adventure WorksEmployeeAdventure Works Employee

Objects that Adventure Works Employee depends on

name	object type	level

Documentation generated by SqlSpec