EnterpriseDW_SSAS
 Employee (Cube Dimension)
  Properties
Property Value
Name Employee
ID Employee
Database Dimension View Employee
All Member Aggregation Usage Default
Hierarchy Unique Name Style IncludeDimensionName
Member Unique Name Style Native
Visible True
  Attributes
Attribute Name
Aggregation Usage
Attribute Hierarchy Enabled
Attribute Hierarchy OptimizedState
Attribute Hierarchy Visible
Dimension Attribute
Citizenship
Default
True
FullyOptimized
True
Citizenship Code
Default
True
FullyOptimized
True
Country
Default
True
FullyOptimized
True
Country Code
Default
True
FullyOptimized
True
Country Of Citizenship
Default
True
FullyOptimized
True
Country Of Citizenship Code
Default
True
FullyOptimized
True
County
Default
True
FullyOptimized
True
County FIPS Code
Default
True
FullyOptimized
True
Date Of Birth
Default
True
FullyOptimized
True
Employee Age
Default
True
FullyOptimized
True
Employee AK
Default
True
FullyOptimized
True
Employee Fulltime Parttime
Default
True
FullyOptimized
True
Employee Student Id
Default
True
FullyOptimized
True
Employee Type
Default
True
FullyOptimized
True
Employee Type Code
Default
True
FullyOptimized
True
Ethnicity
Default
True
FullyOptimized
True
Ethnicity Code
Default
True
FullyOptimized
True
First Name
Default
True
FullyOptimized
True
Full Name
Default
True
FullyOptimized
True
Function Code
Default
True
FullyOptimized
True
Function Desc
Default
True
FullyOptimized
True
Gender
Default
True
FullyOptimized
True
Gender Code
Default
True
FullyOptimized
True
Has Active Assignment
Default
True
FullyOptimized
True
Has Direct Deposit
Default
True
FullyOptimized
True
Hire Date
Default
True
FullyOptimized
True
Is A Student
Default
True
FullyOptimized
True
Last Active Assignment Date Range
Default
True
FullyOptimized
True
Last Name
Default
True
FullyOptimized
True
Last Pay Check Date Range
Default
True
FullyOptimized
True
Location
Default
True
FullyOptimized
True
Location Code
Default
True
FullyOptimized
True
Middle Initial
Default
True
FullyOptimized
True
Number Of Active Assignments
Default
True
FullyOptimized
True
Person ID
Default
True
FullyOptimized
True
Position Type
Default
True
FullyOptimized
True
Position Type Code
Default
True
FullyOptimized
True
Primary Salary Account Number
Default
True
FullyOptimized
True
State
Default
True
FullyOptimized
True
State Code
Default
True
FullyOptimized
True
Termination Date
Default
True
FullyOptimized
True
Termination Date Range
Default
True
FullyOptimized
True
Years Of Service To Institution
Default
True
FullyOptimized
True
Zip Code
Default
True
FullyOptimized
True
  Hierarchies
Hierarchy Name
Optimized State
Dimension Hierarachy
Powered by BI Documenter