OLAPDIM FILE
Data Mart Dimensions
The Data Mart Dimensions (OLAPDIM) file stores the dimension settings for
each data mart. The information in this file comes from IA15.1 (Dimension
Settings).
REFERENCED BY
ACDL.1 AMDL.1 HCOP.1 HCOP.2 IA04.1 IA04.2
IA11.3 IA115 IA14.1 IA150 IA200 IA300
IAMD.1 IANM.1 IAPF.1 GLOP.1 POA3.1 IAMB.1
IA02.1 IA80.1 IA85.1 IADE.1
UPDATED BY
IA05.1 IA10.1 IA10.2 IA120 IA15.1 IA15.4
IAAP.1 IASV.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OLD-DATA-MART-NAME Alpha 20 (Lower Case) IA15.1 IA15.4
Data Mart Name IAAP.1
OLD-USER-DIM-NAME Alpha 50 (Lower Case) IA15.1 IA15.4
User Dimension Name The User Dimension Name is the name IAAP.1
associated with the dimension in the
data mart outline. This user-defined
name can contain up to 50 alphanumeric
characters. For example, you might name
a dimension Fiscal Year or Organization.
OLD-LAW-DIM-NAME Alpha 50 (Lower Case) IA15.1 IA15.4
Lawson Dimension The Lawson Dimension Name is the name IAAP.1
Name of the Lawson defined dimension name.
Instead of the User Dimension Name, this
name is assigned by the Analytic
Architect system and is used by the
system that provides data to the
Analytic Architect system. If a user
changes the User Dimension Name, data
sent to the data mart is unaffected.
OLD-SEQUENCE-NBR Numeric 4 IA15.1 IAAP.1
Sequence Number The user-assigned sequence number to
keep the records unique and to determine
order.
OLD-ALIAS-NAME Alpha 80 (Lower Case)
Alias Name The Alias Name field contains an alias
name for the dimension.
OLD-DIMENSION-TYPE Alpha 1 IA15.1 IA15.4
Dimension Type The Dimension Type field specifies the IAAP.1
dimension owner.
Value values are:
L = Lawson
U = User
OLD-DIMENSION-CAT Alpha 1 IA15.1 IAAP.1
Dimension Category The Dimension Category field specifies
the category to be assigned to the
dimension in the outline. Choose this
category by the type of data that will
populate the data mart.
Dimension categories are predefined by
the data mart. Categories specify the
attributes for the dimension. These
attributes affect how the data mart
performs and stores data.
Value values are:
~ = No category
A = Accounts
C = Currency
T = Time
Y = Country
" "
X = Attribute
OLD-DENSITY-VALUE Alpha 1 IA15.1 IAAP.1
Density Value The Density Value field specifies
whether the data in the dimension is
dense or sparse. In a dense data mart, a
relatively high percentage of the
possible combinations (intersections) of
all dimension members contain data
values. In a sparse dimension, a higher
percentage of the intersections have
missing data.
Valid values are:
D = Dense; Default value.
S = Sparse
OLD-PROTECT-REBLD Alpha 1 IAAP.1
Static Dimension The Static Dimension field lets you
prevent this dimension from being
rebuilt when the rest of the outline is
rebuilt. You can use this feature on
static dimensions where members are not
added, moved, or deleted on a regular
basis.
Valid values are:
Y = Yes
No = No; Default value.
OLD-DIM-BUILD-DTE Numeric 8 (yyyymmdd) IA10.2 IA120
Dimension Build Date The Dimension Build Date field contains IASV.2
the most recent date that this dimension
was updated in the outline. The date
format used is YYYYMMDD.
OLD-DIM-BUILD-TME Numeric 6 (hhmmss) IA10.2 IA120
Dimension Build Time The Dimension Build Time field contains IASV.2
the most recent time that this dimension
was updated in the outline. The time
format used is HHMMSS.
OLD-OLD-DIM-NAME Alpha 50 (Lower Case)
Previous Dimension The Previous Dimension Name field
Name contains the previous user dimension
name if the name was changed.
OLD-MODIFY-ALLOW Alpha 1 IA15.1 IAAP.1
Allow Modifications The Allow Modifications field
determines whether modifications are
allowed to the Dimension Category or
Density Value fields. Changes to the
Density Value field may cause data mart
size and performance issues. Changes to
the Dimension Category will require the
outline to be rebuilt.
Valid values are:
Y = Yes; Default value.
No = No
OLD-NUMBER-OF-MBRS Numeric 7
Number of Members The Number of Member field contains the
actual number of members for the
dimension in the outline.
OLD-DIM-OBJ-ID Numeric 12 IA15.1 IA15.4
Dimension Object The Dimension Object Identifier field IA300 IAAP.1
Identifier contains a unique numeric identifier
assigned to the dimension, which
associates this record to the member
records.
OLD-META-PROGRAM Alpha 6 IA15.1 IA15.4
Dimension Build The Outline Build Program field IAAP.1
Program contains the name of the program that
the Analytic Architect system calls to
supply the outline (description of the
data) to the data mart. This may be the
same program as the data values load
program.
OLD-META-FORMAT Alpha 1 IA15.1 IAAP.1
Dimension Build The Dimension Build Source file
Source contains the value that represents the
source for the dimension outline.
Valid values are:
1 = Program; Default value.
2 = Rules File
3 = Manual
OLD-META-FILE-PATH Alpha 100 (Lower Case) IA15.1 IA15.4
Path and File Name The Path and File Name field contains IAAP.1
name of the text file that contains the
data mart outline (description of the
data) for the dimension. If a dimension
build program is not specified, a text
file and a rules file are required. The
text file contains the outline and the
rules file contains the outline build
rules.
OLD-RULES-FILE Alpha 100 (Lower Case) IA15.1
Rules File The Rules File field contains file name
of the rules file to be used by the data
mart. If a rules file is used, the data
source is the file specified in the Data
Source File field. The rules file is
responsible for loading the data source
file into the data mart. Both the rules
file and the data source file must be
placed in the $ARBORPATH/app/application
name/database path before using IA120
(Data Mart Load).
OLD-IA-OUTLINE-IND Alpha 1 IAAP.1
Retain Member List The Retain Member list field specifies
the value that determines whether a list
of members is retained in the Analytic
Architect system when the data mart is
created. This list of member names is
used during the operand mapping process
for the Performance Indicator suite.
M = Member
A = Member & Alias
N = No
OLD-UPDATE-STYLE Alpha 1 IA15.1 IAAP.1
Update Style 1 = Refresh
2 = Changes & Deletes
3 = Changes Only
4 = No Update
OLD-MBR-LIST-OPT Alpha 1 IA05.1 IA15.1
Mbr List Opt Y = Yes IAAP.1
N = No
OLD-ALIAS-NAME-OPT Alpha 1 IA05.1 IA15.1
Alias Name Opt Y = Yes IAAP.1
N = No
OLAPDIM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OLDSET1 DATA-MART-NAMEKeyChange ACDL.1 AMDL.1
USER-DIM-NAME HCOP.1 HCOP.2
IA04.1 IA04.2
IA05.1 IA10.1
IA10.2 IA11.3
IA115 IA120
IA14.1 IA15.1
IA15.4 IA150
IA200 IA300
IAAP.1 IAMD.1
IANM.1 IAPF.1
IASV.2 GLOP.1
POA3.1
OLDSET2 DATA-MART-NAMEKeyChange IAAP.1
LAW-DIM-NAME
USER-DIM-NAME
OLDSET3 DATA-MART-NAMEKeyChange, Subset IA120 IA15.1
SEQUENCE-NBR Where DIMENSION-CAT != "X" IA150
USER-DIM-NAME
OLDSET4 DATA-MART-NAMEKeyChange, Duplicates IA04.1 IA150
DIM-OBJ-ID IAMB.1
OLDSET5 DIM-OBJ-ID IA02.1 IA80.1
DATA-MART-NAME IA85.1 IAAP.1
IADE.1 IANM.1
OLAPDIM FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Olapdbm OLAPDBM Required
OLD-DATA-MART-NAME -> ODB-DATA-MART-NAME
OLAPDIM FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Dimdatarel DIMDATAREL
OLD-DATA-MART-NAME -> DDR-DATA-MART-NAME
OLD-USER-DIM-NAME -> DDR-USER-DIM-NAME
DDR-DATA-LOAD-NAME
Member MEMBER
OLD-DATA-MART-NAME -> MBR-DATA-MART-NAME
OLD-DIM-OBJ-ID -> MBR-DIM-OBJ-ID
MBR-MEMBER-NAME
MBR-OBJ-ID
|
