This cube represents the human resouces dimension snapshot and is based on
the IFS Applications dimension DIM_SNAPSHOT_DETAILS.
Attribute |
Hierarchy |
Description |
Snapshot |
NO |
Refered as CATEGORY_CALENDAR_YEAR_DESCR in dimension
(CATEGORY_DESCRIPTION + ' - ' + CALENDAR_DESCRIPTION + ' - ' + cast(YEAR
as varchar) + ' - ' + PERIOD as CATEGORY_CALENDAR_YEAR_DESCR). |
Snapshot Calender |
NO |
Refered as ID in dimension |
Snapshot Calender Id |
NO |
|
Snapshot Category |
NO |
Refered as Category_description in
dimension |
Snapshot Category Code |
NO |
Refered as Code in dimension |
Snapshot Period |
NO |
Period for Snapshot |
Snapshot Year |
NO |
Year for Snapshot |
Snapshot Year Period |
NO |
Year and Period for Snapshot |
Hierarchy |
YES |
"Snapshot Category" -> "Snapshot Calendar"
-> "Snapshot Year" -> "Snapshot Period" |