EnterpriseDW_SSAS
 Employee (Dimension)
  Properties
Property Value
Name Employee
ID Employee
Dimension Type Regular
Description
Collation Latin1_General_CI_AS
Created Timestamp Thursday, March 09, 2017 11:01 AM
Attribute All Member Name
Current Storage Mode Molap
Storage Mode Molap
Depends On Dimension Id
Is Linked False
Is Loaded True
Is Parent Child False
Language English (United States)
Last Processed Thursday, March 09, 2017 2:33 PM
Last Schema Update Thursday, March 09, 2017 11:01 AM
MDX Missing Member Mode Default
Mining Model Id
Processing Group ByAttribute
Processing Mode Regular
Processing Priority 0
Unknown Member None
Unknown Member Name Unknown
Write Enabled False
  Attributes
Attribute Name
ID
Attribute Type
Is Aggregatable
Description
Citizenship
Regular
True
Citizenship Code
Regular
True
Country
Regular
True
Country Code
Regular
True
Country Of Citizenship
Regular
True
Country Of Citizenship Code
Regular
True
County
Regular
True
County FIPS Code
Regular
True
Date Of Birth
Regular
True
Employee Age
Regular
True
Employee AK
Regular
True
Employee Fulltime Parttime
Regular
True
Employee Student Id
Regular
True
Employee Type
Regular
True
Employee Type Code
Regular
True
Ethnicity
Regular
True
Ethnicity Code
Regular
True
First Name
Regular
True
Full Name
Regular
True
Function Code
Regular
True
Function Desc
Regular
True
Gender
Regular
True
Gender Code
Regular
True
Has Active Assignment
Regular
True
Has Direct Deposit
Regular
True
Hire Date
Regular
True
Is A Student
Regular
True
Last Active Assignment Date Range
Regular
True
Last Name
Regular
True
Last Pay Check Date Range
Regular
True
Location
Regular
True
Location Code
Regular
True
Middle Initial
Regular
True
Number Of Active Assignments
Regular
True
Employee SK
Regular
True
Position Type
Regular
True
Position Type Code
Regular
True
Primary Salary Account Number
Regular
True
State
Regular
True
State Code
Regular
True
Termination Date
Regular
True
Termination Date Range
Regular
True
Years Of Service To Institution
Regular
True
Zip Code
Regular
True
  Hierarchies
Hierarchy Name
ID
Description
Powered by BI Documenter