ROLAPIDS – No description in the Lawson data dictionary

System
Analytic Architect (IA)
Prefix
RID
Primary key
DIM-OBJ-ID, META-ID
Fields
12
Updated by
52 programs
Referenced by
9 programs

ROLAPIDS is a Lawson Analytic Architect table (prefix RID); no description in the lawson data dictionary. It is indexed by DIM-OBJ-ID, META-ID (RIDSET1); alternate indexes: RIDSET2, RIDSET3, RIDSET4, RIDSET5 and RIDSET6. It is updated by ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 and 44 more and referenced by ACDL.1, AMDL.1, CBOP.1, GLOP.1, HCDL.1, HCHP.1, IASD.1, IFEO.1 and 1 more. The table has 12 fields, 6 indexes and 0 documented relations.

About ROLAPIDS

No description in the Lawson data dictionary.

Fields (12)

Column = COBOL field name without the RID- 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
#RID-DIM-OBJ-ID PK
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.ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 +43 more
#RID-META-ID PK
META_ID		Numeric 9—ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 +43 more
#RID-MEMBER-NAME SET2
MEMBER_NAME		Alpha 50 (Lower Case)This is an override member name for Data Mart dimensions with no association to a Budget dimension.ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 +43 more
#RID-SHARED-OCCURS SET2
SHARED_OCCURS		Numeric 3—ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 +43 more
#RID-GENERATION SET4
GENERATION		Numeric 3Optional. The Generation Reference field contains the Essbase generation reference number for the member. This number is 2 or higher.ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 +43 more
#RID-ROLAP-NAME SET4
ROLAP_NAME		Alpha 50 (Lower Case)—ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 +43 more
#RID-ID-STRING SET3
ID_STRING		Alpha 50—ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 +43 more
#RID-LAST-UPD-DATE SET6
LAST_UPD_DATE		Numeric 8 (yyyymmdd)The Last Update Date field contains the date the member was last updated.ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 +43 more
#RID-LAST-UPD-TIME SET6
LAST_UPD_TIME		Numeric 6 (hhmmss)The Last Update Time field contains the time the member was last updated.ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 +43 more
#RID-PARAM-STRING
PARAM_STRING		Alpha 300 (Lower Case)——
#RID-RECORD-OWNER
RECORD_OWNER		Alpha 1The Record Owner field contains the name of the record owner. Valid values are:
  • L Lawson
  • U User
ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 +43 more
#RID-UNARY-OPERATOR SET5
UNARY_OPERATOR		Alpha 1The Unary Operator field contains the unary operator for the member. This field is not used in release 7.0.7 of the Analytic Architect system.ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 +43 more

Indexes (6)

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
RIDSET1
  1. DIM-OBJ-ID
  2. META-ID
Primary, KeyChangeACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, ACDL.1 +22 more (list truncated in source)
RIDSET2
  1. DIM-OBJ-ID
  2. MEMBER-NAME
  3. SHARED-OCCURS
KeyChangeACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, ACDL.1 +22 more (list truncated in source)
RIDSET3
  1. DIM-OBJ-ID
  2. ID-STRING
KeyChangeACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 +22 more (list truncated in source)
RIDSET4
  1. DIM-OBJ-ID
  2. ROLAP-NAME
  3. GENERATION
  4. META-ID
KeyChangeACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 +22 more (list truncated in source)
RIDSET5
  1. DIM-OBJ-ID
  2. UNARY-OPERATOR
  3. META-ID
KeyChange—
RIDSET6
  1. DIM-OBJ-ID
  2. LAST-UPD-DATE
  3. LAST-UPD-TIME
  4. META-ID
KeyChange, SubsetWhere RECORD-OWNER = "L"ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 +22 more (list truncated in source)

Programs

Updated by (52)

Referenced by (9)