|
|
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 GLOP.1 POA3.1
WODL.1 IADE.1
UPDATED BY
IAAP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OLD-DATA-MART-NAME Alpha 20 (Lower Case) IAAP.1
Element: Data Mart Name
OLD-USER-DIM-NAME Alpha 50 (Lower Case) IAAP.1
Element: User DimensionThe User Dimension Name is the name
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) IAAP.1
Lawson Dimension The Lawson Dimension Name is the name
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 IAAP.1
Element: Sequence Number
OLD-ALIAS-NAME Alpha 80 (Lower Case) IAAP.1
Element: Alias Name The Alias Name field contains an alias
name for the dimension.
OLD-DIMENSION-TYPE Alpha 1 IAAP.1
Element: Dimension TypeThe Dimension Type field specifies the
dimension owner.
Value values are:
L = Lawson
U = User
OLD-DIMENSION-CAT Alpha 1 IAAP.1
Element: Dimension CateThe 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 IAAP.1
Element: 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
Element: Static DimensiThe 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)
Element: Dimension BuilThe Dimension Build Date field contains
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)
Element: Dimension BuilThe Dimension Build Time field contains
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 IAAP.1
Element: Allow ModificaThe 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
Element: Number of MembThe Number of Member field contains the
actual number of members for the
dimension in the outline.
OLD-DIM-OBJ-ID Numeric 12 IAAP.1
Dimension Object The Dimension Object Identifier field
Identifier contains a unique numeric identifier
assigned to the dimension, which
associates this record to the member
records.
OLD-META-PROGRAM Alpha 6 IAAP.1
Dimension Build The Outline Build Program field
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 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
4 = Rules File with SQL Connection
OLD-META-FILE-PATH Alpha 100 (Lower Case) IAAP.1
Element: Path and File The Path and File Name field contains
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) IAAP.1
Element: 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
Element: Retain Member 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 IAAP.1
Element: Update Style 1 = Refresh
2 = Changes & Deletes
3 = Changes Only
4 = No Update
OLD-MBR-LIST-OPT Alpha 1 IAAP.1
Element: Mbr List Opt Y = Yes
N = No
OLD-ALIAS-NAME-OPT Alpha 1 IAAP.1
Element: Alias Name OptY = Yes
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
IAAP.1 GLOP.1
POA3.1 WODL.1
OLDSET2 DATA-MART-NAMEKeyChange IAAP.1
LAW-DIM-NAME
USER-DIM-NAME
OLDSET3 DATA-MART-NAMEKeyChange, Subset ACDL.1 AMDL.1
SEQUENCE-NBR Where DIMENSION-CAT != "X" HCOP.1 HCOP.2
USER-DIM-NAME GLOP.1 POA3.1
WODL.1
OLDSET4 DATA-MART-NAMEKeyChangeDuplicates
DIM-OBJ-ID
OLDSET5 DIM-OBJ-ID IAAP.1 IADE.1
DATA-MART-NAME
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
|
