ROLAPDIM – No description in the Lawson data dictionary

System
Analytic Architect (IA)
Prefix
ROL
Primary key
USER-DIM-NAME
Fields
26
Updated by
58 programs
Referenced by
18 programs

ROLAPDIM is a Lawson Analytic Architect table (prefix ROL); no description in the lawson data dictionary. It is indexed by USER-DIM-NAME (ROLSET1); alternate indexes: ROLSET2, ROLSET3, ROLSET4 and ROLSET5. It is related 1:1 to IADIMTYPES and 1:M to IAATTRIB, OLAPDIM and ROLAPIDS. It is updated by ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 and 50 more and referenced by ACDL.1, AM88.1, AMDL.1, CBOP.1, GLOP.1, HC02.2, HCDL.1, HCHP.1 and 10 more. The table has 26 fields, 5 indexes and 4 documented relations.

About ROLAPDIM

No description in the Lawson data dictionary.

Fields (26)

Column = COBOL field name without the ROL- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#ROL-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, IA02.1, IAAP.1
#ROL-DIM-OBJ-ID SET2 SET4
DIM_OBJ_ID		Numeric 12The Dimension Object Identifier field contains a unique numeric identifier assigned to the dimension, which associates this record to the member records.HC10.1, IA02.1, IAAP.1
#ROL-LAST-META-ID
LAST_META_ID		Numeric 9—ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 +43 more
#ROL-LAST-PARENT-ID
LAST_PARENT_ID		Numeric 9—ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 +43 more
#ROL-GENERATIONS
GENERATIONS		Numeric 2—ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 +44 more
#ROL-ASYMETRIC-OPT
ASYMETRIC_OPT		Alpha 1——
#ROL-LAW-DIM-NAME SET3 SET4
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, IA02.1, IAAP.1
#ROL-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.IA150
#ROL-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.IA150
#ROL-DATABASE-SPACE SET5
DATABASE_SPACE		Alpha 25 (Lower Case)—IA00.6, IA02.1, IAAP.1
#ROL-META-FILE-NAME
META_FILE_NAME		Alpha 50 (Lower Case)—IA02.1, IA15.4, IAAP.1
#ROL-DIMENSION-TYPE
DIMENSION_TYPE		Alpha 1The Dimension Type field specifies the dimension owner. Value values are:
  • L Lawson
  • U User
HC10.1, IAAP.1
#ROL-SECURITY-ON
SECURITY_ON		Alpha 1This field indicates whether the budget is securing individuals from access.
  • Y Security is On
  • N Security is Off
HC10.1, IAAP.1
#ROL-PARAMS-EXIST
PARAMS_EXIST		Alpha 1—
  • Y Yes
  • N No
—
#ROL-TABLE-CHANGE
TABLE_CHANGE		Alpha 1—
  • Y Yes
  • N No
ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 +46 more
#ROL-DEFN-PROGRAM
DEFN_PROGRAM		Alpha 5The Data Mart Setup Program field contains the name of the program that provides the dimensions, members, and data selection parameters required by the data mart.HC10.1, IA02.1, IA100, IAAP.1
#ROL-META-PROGRAM
META_PROGRAM		Alpha 6The 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, IA02.1, IA100, IA15.4, IAAP.1
#ROL-FACT-TABLE-OPT
FACT_TABLE_OPT		Alpha 1——
#ROL-NBR-COLUMNS
NBR_COLUMNS		Numeric 3—ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 +43 more
#ROL-CREATED-GEN
CREATED_GEN		Alpha 1" " = No
  • Y Yes
  • N No
HC10.1, IA02.1, IA150, IAAP.1, IANM.1
#ROL-TABLE-FORMAT
TABLE_FORMAT		Alpha 1—
  • L Level Heirarchy
  • P Parent/Child
HC10.1, IA02.1, IAAP.1
#ROL-SORT-OPTION
SORT_OPTION		Alpha 1This field will determine whether the members of the dimension will appear in an alphabetical or input order in the star schema tables. The input order is the order that would typically be seen on a report or screen within Lawson. Or, in other words, the logical order of members.
  • A Alphabetical
  • I Input Order
HC10.1, IA02.1, IAAP.1
#ROL-COLUMNS-KNOWN
COLUMNS_KNOWN		Alpha 1This field is used to indicate wheter the Star Schema Columns for this dimension table are known yet.
  • Y Yes
  • N No
HC10.1, IA02.1, IAAP.1
#ROL-DIMENSION-CAT
DIMENSION_CAT		Alpha 1The 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
HC10.1, IAAP.1
#ROL-ALIAS-NAME
ALIAS_NAME		Alpha 80 (Lower Case)The Alias Name field contains an alias name for the dimension.—
#ROL-CHG-TO-MEASURE
CHG_TO_MEASURE		Alpha 1—HC10.1, IAAP.1

Indexes (5)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ROLSET1
  1. USER-DIM-NAME
Primary, KeyChangeACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, ACDL.1 +22 more (list truncated in source)
ROLSET2
  1. DIM-OBJ-ID
KeyChangeACDL.1, AMDL.1, CBOP.1, HC10.1, HCDL.1, HCHP.1, IA150, GLOP.1 +1 more
ROLSET3
  1. LAW-DIM-NAME
  2. USER-DIM-NAME
KeyChangeIA00.1
ROLSET4
  1. LAW-DIM-NAME
  2. DIM-OBJ-ID
KeyChangeIADM.1
ROLSET5
  1. DATABASE-SPACE
  2. USER-DIM-NAME
KeyChangeIA00.1, IA00.6

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
IADIMTYPESIAATTRIBOLAPDIMROLAPIDSROLAPDIM

One to one (1) — lookups and parents

RelationTableRulesConditionField map
IadimtypesIADIMTYPESRequired
ROL-LAW-DIM-NAME→IDT-LAW-DIM-NAME

One to many (3) — child tables

RelationTableRulesConditionField map
IaattribIAATTRIBDelete Cascades
ROL-DIM-OBJ-ID→IAT-DIM-OBJ-ID
—→IAT-ATTRIBUTE-NAME
OlapdimOLAPDIM
ROL-DIM-OBJ-ID→OLD-DIM-OBJ-ID
—→OLD-DATA-MART-NAME
RolapidsROLAPIDS
ROL-DIM-OBJ-ID→RID-DIM-OBJ-ID
—→RID-META-ID

Programs

Updated by (58)

Referenced by (18)