|
|
GLIADIM FILE
Financial Analyzer Dimensions
The Financial OLAP Dimensions data file stores the definition of each
dimension that has been defined by GL87.1 (Financial OLAP Dimensions).
REFERENCED BY
ACBO.1 CXA2.1 CXA3.1 GLOB.1 GLOP.1 POA2.1
POA3.1 SAA2.1 SAA3.1 WOA2.1 WOA3.1
UPDATED BY
AC87.1 CXA1.1 GL87.1 GL88.1 POA1.1 SAA1.1
WOA1.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GID-APPLIC-NAME Alpha 8 (Lower Case) AC87.1 CXA1.1
Application Name The Application Name is the name of the GL87.1 GL88.1
application that describes the database POA1.1 SAA1.1
names it contains. This user-defined WOA1.1
name can contain up to eight characters.
The first letter of the name must be
capitalized.
GID-DATABASE-NAME Alpha 8 (Lower Case) AC87.1 CXA1.1
Database Name The Database Name is the name of the GL87.1 GL88.1
database that is stored within the OLAP POA1.1 SAA1.1
application. Each application may WOA1.1
contain more than one database. This
user-defined name can contain up to
eight characters. The first letter of
the name must be capitalized.
GID-APPLIC-TYPE Alpha 3 GL87.1 GL88.1
Application Type The Application Type file stores the
names of the Lawson applications that
can be requested to supply information
to the OLAP database. The Lawson
applications that are currently
OLAP-ready are:
FIN = Financial Analyzer
FND = Daily Financial Analyzer
SA = Sales Analyzer
CX = Case Cart Analyzer
PO = Purchasing Analyzer
WO = Work Order Analyzer
GID-MAINT-DATE Numeric 8 (yyyymmdd) CXA1.1 GL87.1
Maintainance Date The Maintenance Date field contains the GL88.1 POA1.1
date that this file was last updated. SAA1.1 WOA1.1
The date format used is YYYYMMDD.
GID-MAINT-TIME Numeric 6 (hhmmss) CXA1.1 GL87.1
Maintainance Time The Maintenance Time field contains the GL88.1 POA1.1
time that this file was last updated. SAA1.1 WOA1.1
The time format used is HHMMSS.
GID-ORG-DIMENSION Alpha 30 (Lower Case) AC87.1 CXA1.1
Organization The Organization Dimension Name field GL87.1 GL88.1
Dimension Name contains the user-defined name for the POA1.1 SAA1.1
Organization dimension. This name can WOA1.1
contain up to 30 characters of any kind.
GID-ORG-PREFIX Alpha 5 (Lower Case) AC87.1 GL87.1
Organization Prefix The Organization Prefix field contains GL88.1
a unique prefix name that differentiates
the members in the Organization
dimension with similar members in other
dimensions. This prefix can contain up
to five characters of any kind.
GID-ORG-ALIAS-OPT Alpha 1 AC87.1 GL87.1
Organization Alias The Organization Alias Option field GL88.1
Option contains the value that represents the
alias name for the members of this
dimension.
Valid values are:
1 = Company, accounting unit, and
description of accounting unit; Default
value.
2 = Company and accounting unit
3 = Description of accounting unit.
GID-COMPANY Numeric 4 AC87.1 CXA1.1
Company The Company field contains the company GL87.1 GL88.1
number that is used in the Organization POA1.1 SAA1.1
dimension. WOA1.1
GID-ACCT-UNIT Alpha 15 AC87.1 GL87.1
Accounting Unit The Accounting Unit field contains the GL88.1
name of the accounting unit that is used
in the Organization dimension. If this
field is blank, all accounting units are
included as members in the dimension
outline. This name can contain up to 15
alphabetic characters.
GID-COMPANY-GROUP Alpha 12 AC87.1 CXA1.1
Company Group The Company Group field contains an GL87.1 GL88.1
identifier that represents a group of POA1.1 SAA1.1
companies that are included in the WOA1.1
Organization dimension. This identifier
can contain up to 12 alphabetic
characters.
GID-ACT-DIMENSION Alpha 30 (Lower Case) GL87.1 GL88.1
Accounts Dimension The Accounts Dimension Name field
contains the user-defined name for the
Accounts dimension. This name can
contain up to 30 characters of any kind.
GID-ACT-PREFIX Alpha 5 (Lower Case) GL87.1 GL88.1
Accounts Prefix The Accounts Prefix field contains a
unique prefix name that differentiates
the members in the Accounts dimension
with similar members in other
dimensions. This name can contain up to
five characters of any kind.
GID-ACT-ALIAS-OPT Alpha 1 GL87.1 GL88.1
Accounts Alias The Accounts Alias Option field
Option contains the value that represents the
alias name for the members of this
dimension.
Value values are:
1 = Account, subaccount, and
description of subaccount; Default
value.
2 = Account and subaccount
3 = Description of subaccount
1 = Acct Subacct Desc
GID-BAL-MBR-NAME Alpha 30 (Lower Case) GL87.1 GL88.1
Balance Sheet The Balance Sheet Member Name field
Member Name contains the user-defined name of the
balance sheet member. This name can
contain up to 30 characters of any kind.
GID-INC-MBR-NAME Alpha 30 (Lower Case) GL87.1 GL88.1
Income Statement The Income Statement Member Name field
Member Name contains the user-defined name of the
income statement member. The name can
contain up to 30 characters of any kind.
GID-ACCT-ROLLUP Alpha 1 GL87.1 GL88.1
Account Rollup The Account Rollup field determines
whether or not the outline contains an
account member with subaccount children,
which are rolled up when the database is
calculated.
Valid values are:
Y = Yes
N = No
GID-CHART-NAME Alpha 12 GL87.1 GL88.1
Chart of Accounts The Chart of Accounts Name field
Name contains the name of the chart of
accounts that is used by the
Organization dimension. This name can
contain up to 12 alphabetic characters.
GID-CHART-SECTION Alpha 1 GL87.1 GL88.1
Chart Section The Chart Section field contains the
value that represents the section of the
chart of accounts that is used in the
Organization dimension.
Valid values are:
1 = Balance Sheet
2 = Income Statement
Blank = Both; Default value.
GID-ACT-SIGN-OPT Alpha 1 GL87.1
Sign Reversal The Sign Reversal field determines if
amounts and budget amounts in the income
statement accounts are loaded with the
sign reversed.
Valid values are:
Y = Yes
N = No
GID-PRD-DIMENSION Alpha 30 (Lower Case) GL87.1
Period Dimension The Period Dimension Name field
Name contains the user-defined name for the
Period dimension. This name can contain
up to 30 characters of any kind.
GID-PRD-PREFIX Alpha 5 (Lower Case) GL87.1
Period Prefix The Period Prefix field contains a
unique prefix name that differentiates
the members in the Period dimension with
similar members in other dimensions.
This prefix can contain up to five
characters of any kind.
GID-PRD-ALIAS-OPT Alpha 1 GL87.1
Period Alias Option The Period Alias Option field contains
the value that represents the alias name
for the members of this dimension.
Valid values are:
1 = Prefix and Member Name
2 = Member Name
GID-NBR-PERIODS Numeric 2 GL87.1
Number of Periods The Number of Periods field contains
the number of periods that are included
when the outline is built. This field
can contain up to two numeric values.
GID-ADJUST-PERIOD Alpha 1 GL87.1
Adjustment Period The Adjustment Period field determines
whether or not the last period is used
as an adjustment period. If Y is
selected, the adjustment period is not
rolled up into any Quarter member.
Instead, the adjustment period is rolled
up into the Period member.
Valid values are:
Y = Yes
N = No; Default value.
GID-BEG-BAL-MBR Alpha 30 (Lower Case) GL87.1
Beginning Balance The Beginning Balance Member field
Member contains the user-defined name of the
beginning balance member. This name can
contain up to 30 characters of any kind.
GID-FYR-DIMENSION Alpha 30 (Lower Case) GL87.1 GL88.1
Fiscal Year The Fiscal Year Dimension Name field
Dimension contains the user-defined name for the
Fiscal Year dimension. The name can
contain up to 30 characters of any kind.
GID-FYR-PREFIX Alpha 5 (Lower Case) GL87.1 GL88.1
Fiscal Year Prefix The Fiscal Years Prefix field contains
a unique prefix name that differentiates
the members in the Fiscal Years
dimension with similar members in other
dimensions. This prefix can contain up
to five characters of any kind.
GID-FYR-ALIAS-OPT Alpha 1 GL87.1 GL88.1
Fiscal Year Alias The Fiscal Years Alias Option field
Option contains the value that represents the
alias name for the members of this
dimension.
Valid values are:
1 = Prefix and Member Name
2 = Member Name
GID-SCN-DIMENSION Alpha 30 (Lower Case) GL87.1 GL88.1
Scenario Dimension The Scenario Dimension Name field
Name contains the user-defined name for the
Scenario dimension. This name can
contain up to 30 characters of any kind.
GID-SCN-PREFIX Alpha 5 (Lower Case) GL87.1 GL88.1
Scenario Prefix The Scenario Prefix field contains a
unique prefix name that differentiates
the members in the Scenario dimension
with similar members in other
dimensions. This prefix can contain up
to five characters of any kind.
GID-SCN-ALIAS-OPT Alpha 1 GL87.1 GL88.1
Scenario Alias The Scenario Alias Option field
Option contains the value that represents the
alias name for the members of this
dimension.
Valid values are:
1 = Prefix and Member Name
2 = Member Name
GID-ACTUALS-MBR Alpha 30 (Lower Case) GL87.1 GL88.1
Actuals Member The Actuals Member field contains the
user-defined name for the Actuals member
of the Scenarios dimension. This name
can contain up to 30 characters of any
kind.
GID-BUDGET-MBR Alpha 30 (Lower Case) GL87.1 GL88.1
Budget Member The Budget Member field contains the
user-defined name for the Budget member
of the Scenarios dimension. This name
can contain up to 30 characters of any
kind.
GID-TYP-DIMENSION Alpha 30 (Lower Case) GL87.1 GL88.1
Type Dimension Optional. The Type Dimension Name field
contains the user-defined name for the
Type dimension. This name can contain up
to 30 characters of any kind.
GID-TYP-PREFIX Alpha 5 (Lower Case) GL87.1 GL88.1
Type Prefix The Type Prefix field contains a unique
prefix name that differentiates the
members in the Type dimension with
similar members in other dimensions.
This prefix can contain up to five
characters of any kind.
GID-TYP-ALIAS-OPT Alpha 1 GL87.1 GL88.1
Type Alias Option The Type Alias Option field contains
the value that represents the alias name
for the members of this dimension.
Valid values are:
1 = Prefix and Member Name
2 = Member Name
GID-AMOUNTS-MBR Alpha 30 (Lower Case) GL87.1 GL88.1
Amounts Member The Amounts Member field contains the
user-defined name for the Amounts member
of the Type dimension. This name can
contain up to 30 characters of any kind.
GID-UNITS-MBR Alpha 30 (Lower Case) GL87.1 GL88.1
Units Member The Units Member field contains the
user-defined name of the Units member of
the Type dimension. This name can
contain up to 30 characters of any kind.
GID-SAC-DIMENSION Alpha 30 (Lower Case) GL87.1 GL88.1
Products Dimension Optional. The Products Dimension Name
field contains the user-defined name for
the Products dimension. The Products
dimension represents a set of
subaccounts. This set of subaccounts is
defined by the From Subaccount field,
the Through Subaccount Field, and the
Account Group field. This name can
contain up to 30 characters of any kind.
GID-SAC-PREFIX Alpha 5 (Lower Case) GL87.1 GL88.1
Products Prefix The Product Prefixes field contains a
unique prefix name that differentiates
the members in the Products dimension
with similar members in other
dimensions. This prefix can contain up
to five characters of any kind.
GID-SAC-ALIAS-OPT Alpha 1 GL87.1 GL88.1
Products Alias The Products Alias Option field
Option contains the value that represents the
alias name for the members of this
dimension.
Valid values are:
1 = Prefix and Alias Name
2 = Alias Name
GID-SAC-MBR-OPT Alpha 1 GL87.1
Member Name Option The Member Name Option field determines
whether an alias name is used as a
member name, thus replacing the
subaccount number.
Valid values are:
1 = Subaccount Number
2 = Alias Name
GID-NULL-VALUE-MBR Alpha 30 (Lower Case) GL87.1 GL88.1
Null Value Member The Null Value Member field contains
the user-defined member name for any
subaccounts that are not defined as a
product in this dimension. This name can
contain up to 30 characters of any kind.
GID-FR-SUB-ACCT Numeric 4 GL87.1 GL88.1
From Subaccount The From Subaccount field contains the
beginning subaccount for a range of
subaccounts. This field can contain up
to four numeric characters.
GID-TH-SUB-ACCT Numeric 4 GL87.1 GL88.1
Through Subaccount The Through Subaccount field contains
the ending subaccount for a range of
subaccounts. This field can contain up
to four numeric characters.
GID-ACCOUNT-GROUP Alpha 12 GL87.1 GL88.1
Account Group The Account Group field contains the
name of the account group that you want
to include in this dimension. An account
group contains several accounts defined
in RW40.3 (Account Group). This field
can contain up to 12 alphabetic
characters.
GID-CURRENCY-CODE Alpha 5 GL87.1 GL88.1
Currency Code This field contains the company base
currency code established in GL10.1
(Company).
GID-CURRENCY-TYPE Alpha 1 GL87.1
Currency Type This field identifies the type of
currency included. You can select Base
currency or Transaction currency.
" " = Base
T = Transaction
GLIADIM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GIDSET1 APPLIC-NAME AC87.1 ACBO.1
DATABASE-NAME CXA1.1 CXA2.1
CXA3.1 GL87.1
GL87.4 GL87.5
GL87.6 GL87.7
GL88.1 GL88.4
GL88.5 GL88.6
GL88.7 GLOB.1
GLOP.1 POA1.1
POA2.1 POA3.1
SAA1.1 SAA2.1
SAA3.1 WOA1.1
WOA2.1 WOA3.1
GLIADIM FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Dim Members GLIAMBR Delete Cascades
GID-APPLIC-NAME -> GIM-APPLIC-NAME
GID-DATABASE-NAME -> GIM-DATABASE-NAME
GIM-DIMENSION
GIM-MBR-TYPE
GIM-SEQUENCE
GIM-BUDGET-NBR
GIM-MBR-NAME
|