EnterpriseDW_SSAS
 Payroll Processed Date SK (Cube Dimension)
  Properties
Property Value
Name Payroll Processed Date SK
ID Payroll Processed Date SK
Database Dimension View Date
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
Calendar Month Of Year
Default
True
FullyOptimized
True
Calendar Period
Default
True
FullyOptimized
True
Calendar Period Filter
Default
True
FullyOptimized
True
Calendar Period Sort
Default
True
FullyOptimized
True
Date Name
Default
True
FullyOptimized
True
Date SK
Default
True
FullyOptimized
True
Day
Default
True
FullyOptimized
True
Day Of Month
Default
True
FullyOptimized
True
Day Of Week
Default
True
FullyOptimized
True
Day Of Year
Default
True
FullyOptimized
True
Fiscal Month Of Year
Default
True
FullyOptimized
True
Fiscal Period
Default
True
FullyOptimized
True
Fiscal Period Of Year
Default
True
FullyOptimized
True
Fiscal Year
Default
True
FullyOptimized
True
Is Available For Finance
Default
True
FullyOptimized
True
Is Current Day
Default
True
FullyOptimized
True
Is Current Fiscal Year
Default
True
FullyOptimized
True
Month
Default
True
FullyOptimized
True
Month Of Year
Default
True
FullyOptimized
True
Quarter
Default
True
FullyOptimized
True
Quarter Of Year
Default
True
FullyOptimized
True
Weekday Weekend
Default
True
FullyOptimized
True
Year
Default
True
FullyOptimized
True
  Hierarchies
Hierarchy Name
Optimized State
Dimension Hierarachy
FiscalCalendar
FullyOptimized
YMD
FullyOptimized
Powered by BI Documenter