AMIACALDIX FILE
REFERENCED BY
AMPD.1 AMYR.1 AMDL.1
UPDATED BY
AM88.4 AM88.5 AM88.6
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ITX-CAL-DIMENSION Alpha 50 (Lower Case) AM88.4 AM88.5
Element: Cal Dimension AM88.6
ITX-MBR-TYPE Alpha 2 AM88.4 AM88.5
Element: Member Type The Asset Member Type field specifies AM88.6
the member type.
Valid values are:
YR = Year
PD = Period
QR = Quarter
ITX-SEQUENCE Numeric 6
Element: Sequence The Sequence field show the sequence of
a member as it is entered in either the
Budget Member Names or Fiscal Year
Variances subforms in AC87.1 (Financial
OLAP Dimensions).
ITX-YEAR Numeric 4 AM88.4 AM88.5
Element: Last Closed YeContains the fiscal year for the data AM88.6
stored on this record.
ITX-QUARTER Numeric 1 AM88.4 AM88.5
Element: Quarter Contains the fiscal quarter for the AM88.6
data stored in this record.
ITX-PERIOD Numeric 2 AM88.4 AM88.5
Element: Last Closed PeThis is the period for the record. AM88.6
ITX-MEMBER-NAME Alpha 50 (Lower Case) AM88.4 AM88.5
Element: Member Name This is an override member name for AM88.6
Data Mart dimensions with no association
to a Budget dimension.
AMIACALDIX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ITXSET1 CAL-DIMENSION AM88.4 AM88.5
MBR-TYPE AM88.6 AMPD.1
YEAR AMYR.1
QUARTER
PERIOD
ITXSET2 CAL-DIMENSION AMDL.1
MBR-TYPE
YEAR*
QUARTER*
PERIOD*
AMIACALDIX FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Amiacaldim AMIACALDIM Required
ITX-CAL-DIMENSION -> ITD-CAL-DIMENSION
|
