|
|
GLIAMBR FILE
Financial Analyzer Members
The Financial OLAP Members data file stores information about each member
that has been defined by GL87.1 (Financial OLAP Dimensions).
REFERENCED BY
GLBA.1 GLBD.1 GLBP.1 GLBY.1 GLOP.1 IFBA.1
UPDATED BY
GLDM.3 GLDM.4 GLDM.7 GLDM.8 GLDM.9 GLDX.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GIM-MBR-DIMENSION Alpha 50 (Lower Case) GLDM.3 GLDM.4
Element: Mbr Dimension GLDM.7 GLDM.8
GLDM.9 GLDX.2
GIM-MBR-TYPE Alpha 2 GLDM.3 GLDM.4
Element: Member Type The Member Type field specifies the GLDM.7 GLDM.8
member type. GLDM.9 GLDX.2
Valid values are:
BD = Budget
BV = Budget Variance
CH = Alternate Chart
FY = Fiscal Year
PD = Period
PY = Period Year-to-Date
QR = Quarter
QY = Quarter Year-to-Date
SA = Subaccount
VW = View
YV = Year Variance
GIM-SEQUENCE Numeric 6 GLDM.3 GLDM.4
Element: Sequence The Sequence field show the sequence of GLDM.7 GLDM.8
a member as it is entered in either the GLDM.9 GLDX.2
Budget Member Names or Fiscal Year
Variances subforms in AC87.1 (Financial
OLAP Dimensions).
GIM-BUDGET-NBR Numeric 3 GLDM.8 GLDM.9
Element: Budget Number The Budget Number field contains the
budget number.
GIM-MBR-NAME Alpha 30 (Lower Case) GLDM.8 GLDM.9
Element: Member Name The Member Name field contains the
user-defined member name for the income
statement member. This name can contain
up to 30 characters of any kind.
GIM-ALIAS-MBR-NAME Alpha 30 (Lower Case) GLDM.4 GLDM.7
Element: Member Name The Alias Member Name field contains GLDM.8 GLDM.9
the alias name for the member. This name GLDX.2
can contain up to 30 characters of any
kind.
GIM-MATRIX-VIEW Alpha 12
Element: Attribute ViewThe Attribute View field contains the
accounting unit view being used for
alternate roll-ups. Any posting
accounting units listed in a view that
is used for alternate roll-ups must also
be included in one of the company,
accounting, or company groups.
GIM-FISCAL-YEAR Numeric 4 GLDM.7 GLDX.2
Element: Last Closed YeThe Fiscal Year field contains numeric
fiscal year. This field can contain up
to four numeric characters.
GIM-FYR-FR-DATE Numeric 8 (yyyymmdd) GLDX.2
Element: Fyr Fr Date The From Fiscal Year field contains the
beginning fiscal year for a range of
fiscal years. This field can contain up
to four numeric characters.
GIM-FYR-TH-DATE Numeric 8 (yyyymmdd) GLDX.2
Element: Fyr Th Date The Through Fiscal Year field contains
the ending fiscal year for a range of
fiscal years. This field can contain up
to four numeric characters.
GIM-VAR-TYPE Alpha 1 GLDM.8
Element: Var Type The Variance Type field contains the
value that represents the variance type
for fiscal year variances.
Valid values are:
A = Variance Amount
P = Variance Percent
GIM-VAR-SUBTYPE Alpha 1
Element: Var Subtype The Variance Subtype field contains the
value that represents the variance
subtype for budget variances.
Value values are:
A = Budget to Actuals
B = Budget to Budget
GIM-VAR-ELEMENT1 Numeric 4 GLDM.8
Element: Var Element1 The Variance Element One field contains
the first item (fiscal year or budget
member) that is used in the variance
calculation.
GIM-VAR-ELEMENT2 Numeric 4 GLDM.8
Element: Var Element1 The Variance Element Two field contains
the second item (fiscal year or budget
member) that is used in the variance
calculation.
GIM-VAR-ELEMENT3 Alpha 30 (Lower Case)
Element: Var Element3 The Variance Element Three field
contains the third item (fiscal year or
budget member) that is used in the
variance calculation.
GIM-VAR-ELEMENT4 Alpha 30 (Lower Case)
Element: Var Element3 The Variance Element Four field
contains
the fourth item (fiscal year or budget
member) that is used in the variance
calculation.
GLIAMBR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GIMSET1 MBR-DIMENSION GLBA.1 GLBD.1
MBR-TYPE GLBP.1 GLBY.1
SEQUENCE GLDM.3 GLDM.4
BUDGET-NBR GLDM.7 GLDM.8
MBR-NAME GLDM.9 GLDX.2
GLOP.1 IFBA.1
GIMSET2 MBR-DIMENSION KeyChange, Subset GLDM.8 GLDM.9
ALIAS-MBR-NAMEWhere ALIAS-MBR-NAME != Spaces
|
