OLAPDIM – Data Mart Dimensions

System: Analytic Architect (IA)
Prefix: OLD
Primary key: DATA-MART-NAME, USER-DIM-NAME
Fields: 24
Updated by: 9 programs
Referenced by: 23 programs

OLAPDIM is the Data Mart Dimensions table in Lawson Analytic Architect (prefix OLD). It is indexed by DATA-MART-NAME, USER-DIM-NAME (OLDSET1); alternate indexes: OLDSET2, OLDSET3, OLDSET4 and OLDSET5. It is related 1:1 to OLAPDBM and 1:M to DIMDATAREL and MEMBER. It is updated by HC10.1, IA05.1, IA10.1, IA10.2, IA120, IA15.1, IA15.4, IAAP.1 and 1 more and referenced by ACDL.1, AMDL.1, CBOP.1, GLOP.1, HCDL.1, HCHP.1, IA02.1, IA04.1 and 15 more. The table has 24 fields, 5 indexes and 3 documented relations.

About OLAPDIM

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).

Fields (24)

Column = COBOL field name without the OLD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`OLD-DATA-MART-NAME` PK DATA_MART_NAME	Alpha 20 (Lower Case)	This field contains the name of the data mart.	HC10.1, IA15.1, IA15.4, IAAP.1
`OLD-USER-DIM-NAME` PK USER_DIM_NAME	Alpha 50 (Lower Case)	The 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.	HC10.1, IA15.1, IA15.4, IAAP.1
`OLD-LAW-DIM-NAME` LAW_DIM_NAME	Alpha 50 (Lower Case)	The Lawson Dimension Name is the 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.	HC10.1, IA15.1, IA15.4, IAAP.1
`OLD-SEQUENCE-NBR` SEQUENCE_NBR	Numeric 4	The user-assigned sequence number to keep the records unique and to determine order.	HC10.1, IA15.1, IAAP.1
`OLD-ALIAS-NAME` ALIAS_NAME	Alpha 80 (Lower Case)	The Alias Name field contains an alias name for the dimension.	HC10.1, IAAP.1
`OLD-DIMENSION-TYPE` DIMENSION_TYPE	Alpha 1	The Dimension Type field specifies the dimension owner. Value values are: `L` Lawson `U` User	HC10.1, IA15.1, IA15.4, IAAP.1
`OLD-DIMENSION-CAT` DIMENSION_CAT	Alpha 1	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	HC10.1, IA15.1, IAAP.1
`OLD-DENSITY-VALUE` DENSITY_VALUE	Alpha 1	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	HC10.1, IA15.1, IAAP.1
`OLD-PROTECT-REBLD` PROTECT_REBLD	Alpha 1	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.	IAAP.1
`OLD-DIM-BUILD-DTE` DIM_BUILD_DTE	Numeric 8 (yyyymmdd)	The Dimension Build Date field contains the most recent date that this dimension was updated in the outline. The date format used is YYYYMMDD.	IA10.2, IA120, IASV.2
`OLD-DIM-BUILD-TME` DIM_BUILD_TME	Numeric 6 (hhmmss)	The Dimension Build Time field contains the most recent time that this dimension was updated in the outline. The time format used is HHMMSS.	IA10.2, IA120, IASV.2
`OLD-OLD-DIM-NAME` OLD_DIM_NAME	Alpha 50 (Lower Case)	The Previous Dimension Name field contains the previous user dimension name if the name was changed.	HC10.1
`OLD-MODIFY-ALLOW` MODIFY_ALLOW	Alpha 1	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	IA15.1, IAAP.1
`OLD-NUMBER-OF-MBRS` NUMBER_OF_MBRS	Numeric 7	The Number of Member field contains the actual number of members for the dimension in the outline.	—
`OLD-DIM-OBJ-ID` DIM_OBJ_ID	Numeric 12	The Dimension Object Identifier field contains a unique numeric identifier assigned to the dimension, which associates this record to the member records.	HC10.1, IA15.1, IA15.4, IA300, IAAP.1
`OLD-META-PROGRAM` META_PROGRAM	Alpha 6	The Outline Build Program field 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.	HC10.1, IA15.1, IA15.4, IAAP.1
`OLD-META-FORMAT` META_FORMAT	Alpha 1	The Dimension Build Source file contains the value that represents the source for the dimension outline. Valid values are: `1` Program; Default value. `2` Rules File `3` Manual	HC10.1, IA15.1, IAAP.1
`OLD-META-FILE-PATH` META_FILE_PATH	Alpha 100 (Lower Case)	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.	IA15.1, IA15.4, IAAP.1
`OLD-RULES-FILE` RULES_FILE	Alpha 100 (Lower Case)	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).	IA15.1, IAAP.1
`OLD-IA-OUTLINE-IND` IA_OUTLINE_IND	Alpha 1	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	IAAP.1
`OLD-UPDATE-STYLE` UPDATE_STYLE	Alpha 1	— `1` Refresh `2` Changes & Deletes `3` Changes Only `4` No Update	HC10.1, IA15.1, IAAP.1
`OLD-MBR-LIST-OPT` MBR_LIST_OPT	Alpha 1	— `Y` Yes `N` No	HC10.1, IA05.1, IA15.1, IAAP.1
`OLD-ALIAS-NAME-OPT` ALIAS_NAME_OPT	Alpha 1	— `Y` Yes `N` No	HC10.1, IA05.1, IA15.1, IAAP.1
`OLD-CHG-TO-MEASURE` CHG_TO_MEASURE	Alpha 1	—	IAAP.1

Indexes (5)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`OLDSET1`	`DATA-MART-NAME`, `USER-DIM-NAME`	Primary, KeyChange		ACDL.1, AMDL.1, CBOP.1, HC10.1, HCDL.1, HCHP.1, IA04.1, IA04.2 +19 more
`OLDSET2`	`DATA-MART-NAME`, `LAW-DIM-NAME`, `USER-DIM-NAME`	KeyChange		IAAP.1
`OLDSET3`	`DATA-MART-NAME`, `SEQUENCE-NBR`, `USER-DIM-NAME`	KeyChange, Subset	Where DIMENSION-CAT != "X"	ACDL.1, AMDL.1, CBOP.1, HCDL.1, HCHP.1, IA120, IA15.1, IA150 +2 more
`OLDSET4`	`DATA-MART-NAME`, `DIM-OBJ-ID`	KeyChange		IA04.1, IA150
`OLDSET5`	`DIM-OBJ-ID`, `DATA-MART-NAME`			IA02.1, IA80.1, IA85.1, IAAP.1, IADE.1, IAMB.1, IANM.1

Relations

One to one (1) — lookups and parents

Relation	Table	Rules	Condition	Field map
Olapdbm	OLAPDBM	Required		`OLD-DATA-MART-NAME` → `ODB-DATA-MART-NAME`

One to many (2) — child tables

Relation	Table	Rules	Condition	Field map
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`

Programs

Updated by (9)

HC10.1 Compensation Data Mart Upgrade
IA05.1 Essbase Parameters
IA10.1 Data Mart Manager
IA10.2 Data Mart Delete
IA120 Data Mart Load
IA15.1 Dimension Settings
IA15.4 Olap Database Dimensions
IAAP.1 Dimension Definition Interface
IASV.2 Olap Database Delete

Referenced by (23)

ACDL.1 Olap Data Load
AMDL.1 OLAP Data Load
CBOP.1 Cash Ledger OLAP Data Build
GLOP.1 Olap Data Load
HCDL.1 Olap Data Load
HCHP.1 Olap Data Load
IA02.1 Dimension Definition
IA04.1 Member Definition
IA04.2 Member Maintenance
IA11.3 Olap Database Profiles
IA115 Alias Name Import or Export
IA14.1 Dimension Member Override
IA150 XML Data Mart Interface
IA200 Unix ESSCMD Interface
IA300 Delete Members
IA80.1 Time Dimension Definition
IA85.1 Year Definition
IADE.1 Shared Dimension
IAMB.1 Lawson Member List Update
IAMD.1 Delete Member Information
IANM.1 Level Name Alterations
IAPF.1 Information Transfer Profiles
POA3.1 Data Load for Vendor Analysis