|
|
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
ACBO.1 GLOB.1 GLOP.1
UPDATED BY
AC87.1 GL87.1 GL87.4 GL87.5 GL87.6 GL87.7
GL88.1 GL88.4 GL88.5 GL88.6 GL88.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GIM-APPLIC-NAME Alpha 8 (Lower Case) AC87.1 GL87.1
Application Name The Application Name is the name of the GL87.4 GL87.5
application that describes the database GL87.6 GL87.7
names it contains. This user-defined GL88.1 GL88.4
name can contain up to eight characters. GL88.5 GL88.6
The first letter of the name must be GL88.7
capitalized.
GIM-DATABASE-NAME Alpha 8 (Lower Case) AC87.1 GL87.1
Database Name The Database Name is the name of the GL87.4 GL87.5
database that is stored within the OLAP GL87.6 GL87.7
application. Each application may GL88.1 GL88.4
contain more than one database. This GL88.5 GL88.6
user-defined name can contain up to GL88.7
eight characters. The first letter of
the name must be capitalized.
GIM-DIMENSION Alpha 3 AC87.1 GL87.1
Dimension The Dimension field specifies the GL87.4 GL87.5
dimension for the record. GL87.6 GL87.7
GL88.1 GL88.4
Valid values are: GL88.5 GL88.6
GL88.7
ACT = Account
FYR = Fiscal Year
ORG = Organization
PRD = Period
SAC = Subaccount
SCN = Scenario TYP = Type
GIM-MBR-TYPE Alpha 2 AC87.1 GL87.1
Member Type The Member Type field specifies the GL87.4 GL87.5
member type. GL87.6 GL87.7
GL88.1 GL88.4
Valid values are: GL88.5 GL88.6
BD = Budget GL88.7
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 AC87.1 GL87.1
Sequence The Sequence field show the sequence of GL87.4 GL87.5
a member as it is entered in either the GL87.6 GL87.7
Budget Member Names or Fiscal Year GL88.1 GL88.4
Variances subforms in AC87.1 (Financial GL88.5 GL88.6
OLAP Dimensions). GL88.7
GIM-BUDGET-NBR Numeric 3 AC87.1 GL87.4
Budget Number The Budget Number field contains the GL87.5 GL87.6
budget number. GL87.7 GL88.4
GL88.5 GL88.6
GL88.7
GIM-MBR-NAME Alpha 30 (Lower Case) AC87.1 GL87.5
Member Name The Member Name field contains the GL87.6 GL87.7
user-defined member name for the income GL88.5 GL88.6
statement member. This name can contain GL88.7
up to 30 characters of any kind.
GIM-ALIAS-MBR-NAME Alpha 30 (Lower Case) GL87.1 GL87.4
Alias Member Name The Alias Member Name field contains GL87.5 GL87.6
the alias name for the member. This name GL87.7 GL88.1
can contain up to 30 characters of any GL88.4 GL88.5
kind. GL88.6 GL88.7
GIM-MATRIX-VIEW Alpha 12 AC87.1 GL87.1
Matrix View The Attribute View field contains the GL88.1
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 GL87.1 GL88.1
Fiscal Year The Fiscal Year field contains numeric
fiscal year. This field can contain up
to four numeric characters.
GIM-FYR-FR-DATE Numeric 8 (yyyymmdd) GL88.1
From Fiscal Year 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) GL88.1
Through Fiscal Year 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 GL87.5 GL87.6
Variance Type The Variance Type field contains the GL88.5 GL88.6
value that represents the variance type
for fiscal year variances.
Valid values are:
A = Variance Amount
P = Variance Percent
GIM-VAR-SUBTYPE Alpha 1 GL87.5 GL88.5
Variance 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 GL87.5 GL87.6
Variance Element One The Variance Element One field contains GL88.5 GL88.6
the first item (fiscal year or budget
member) that is used in the variance
calculation.
GIM-VAR-ELEMENT2 Numeric 4 GL87.5 GL87.6
Variance Element Two The Variance Element Two field contains GL88.5 GL88.6
the second item (fiscal year or budget
member) that is used in the variance
calculation.
GIM-VAR-ELEMENT3 Alpha 30 (Lower Case)
Variance Element The Variance Element Three field
Three contains the third item (fiscal year or
budget member) that is used in the
variance calculation.
GIM-VAR-ELEMENT4 Alpha 30 (Lower Case)
Variance Element The Variance Element Four field contains
Four
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 APPLIC-NAME AC87.1 ACBO.1
DATABASE-NAME GL87.1 GL87.4
DIMENSION GL87.5 GL87.6
MBR-TYPE GL87.7 GL88.1
SEQUENCE GL88.4 GL88.5
BUDGET-NBR GL88.6 GL88.7
MBR-NAME GLOB.1 GLOP.1
GIMSET2 APPLIC-NAME KeyChange, Subset GL87.4 GL87.5
DATABASE-NAME Where ALIAS-MBR-NAME != Spaces GL87.6 GL87.7
DIMENSION GL88.4 GL88.5
ALIAS-MBR-NAME GL88.6 GL88.7
GLIAMBR FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Mbr Dimension GLIADIM Required
GIM-APPLIC-NAME -> GID-APPLIC-NAME
GIM-DATABASE-NAME -> GID-DATABASE-NAME
|