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" |