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.

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
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
SHARED_OCCURS		Numeric 3—ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 +43 more
RID-GENERATION
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
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
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
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
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
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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
RIDSET1DIM-OBJ-ID, META-IDPrimary, KeyChangeACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, ACDL.1 +22 more (list truncated in source)
RIDSET2DIM-OBJ-ID, MEMBER-NAME, SHARED-OCCURSKeyChangeACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, ACDL.1 +22 more (list truncated in source)
RIDSET3DIM-OBJ-ID, ID-STRINGKeyChangeACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 +22 more (list truncated in source)
RIDSET4DIM-OBJ-ID, ROLAP-NAME, GENERATION, META-IDKeyChangeACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 +22 more (list truncated in source)
RIDSET5DIM-OBJ-ID, UNARY-OPERATOR, META-IDKeyChange—
RIDSET6DIM-OBJ-ID, LAST-UPD-DATE, LAST-UPD-TIME, META-IDKeyChange, 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)