ROLAPDBS – No description in the Lawson data dictionary

System
Analytic Architect (IA)
Prefix
DBS
Primary key
DATABASE-SPACE
Fields
23
Updated by
4 programs
Referenced by
12 programs

ROLAPDBS is a Lawson Analytic Architect table (prefix DBS); no description in the lawson data dictionary. It is indexed by DATABASE-SPACE (DBSSET1); alternate indexes: DBSSET2. It is related 1:1 to IADESTTYPE and 1:M to OLAPDBM and ROLAPDIM. It is updated by IA00.1, IA00.6, IA10.1 and IASV.1 and referenced by IA02.1, IA05.2, IA100, IA120, IA125, IA150, IA300, IAAP.1 and 4 more. The table has 23 fields, 2 indexes and 3 documented relations.

About ROLAPDBS

No description in the Lawson data dictionary.

Fields (23)

Column = COBOL field name without the DBS- 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
#DBS-DATABASE-SPACE PK
DATABASE_SPACE		Alpha 25 (Lower Case)—IA00.1, IA00.6, IA02.1, IASV.1
#DBS-DATABASE-TYPE SET2
DATABASE_TYPE		Alpha 1—
  • E Essbase
  • S SQL Server
  • A ASCII
IA00.1, IA00.6, IASV.1
#DBS-FILE-DIRECTORY
FILE_DIRECTORY		Alpha 100 (Lower Case)—IA00.1, IA00.6
#DBS-FILE-EXTENSION
FILE_EXTENSION		Alpha 3 (Lower Case)—IA00.1, IA00.6
#DBS-SERVER-NAME
SERVER_NAME		Alpha 40 (Lower Case)The Server Name field contains the IP address of the server to which you are connecting. You can also specify a name that has been associated with the server (DNS name).IA00.1, IA00.6, IASV.1
#DBS-PRODUCT-LINE
PRODUCT_LINE		Alpha 14——
#DBS-DATABASE
DATABASE		Alpha 30 (Lower Case)—IA00.1, IA00.6
#DBS-LOGIN
LOGIN		Alpha 30 (Lower Case)—IA00.1, IA00.6
#DBS-ENCRYPT-PASSWD
ENCRYPT_PASSWD		Alpha 30 (Lower Case)—IA00.1, IA00.6
#DBS-LAW-WEB-SERVER
LAW_WEB_SERVER		Alpha 50 (Lower Case)—IA00.1, IA00.6
#DBS-LAW-WEB-USER
LAW_WEB_USER		Alpha 40 (Lower Case)—IA00.1, IA00.6
#DBS-LAW-WEB-ECR-PW
LAW_WEB_ECR_PW		Alpha 15 (Lower Case)—IA00.6
#DBS-APP-SERVER
APP_SERVER		Alpha 50 (Lower Case)—IA00.1, IA00.6
#DBS-APP-DIR-ALIAS
APP_DIR_ALIAS		Alpha 30 (Lower Case)—IA00.1, IA00.6
#DBS-FTP-LOCATION
FTP_LOCATION		Alpha 100 (Lower Case)This is the directory that is a valid for ftp purposes, pertaining to the server in which SQL Server resides.IA00.1, IA00.6
#DBS-FTP-TXT-LOC
FTP_TXT_LOC		Alpha 100 (Lower Case)The actual directory in which the text files are sent to the SQL Server server.IA00.1, IA00.6
#DBS-ENABLE-XML
ENABLE_XML		Alpha 1" " = No XML Output
  • A XML Output Active
  • X XML Output Only
IA00.1, IASV.1
#DBS-ASP-DEST
ASP_DEST		Alpha 1—
  • Y Yes
  • N No
—
#DBS-ASP-CUSTOMER
ASP_CUSTOMER		Numeric 9—IA00.1, IASV.1
#DBS-NUMERIC-ID
NUMERIC_ID		Numeric 3—IA10.1, IASV.1
#DBS-OLAP-SERVER
OLAP_SERVER		Alpha 40 (Lower Case)The Server Name field contains the IP address of the server to which you are connecting. You can also specify a name that has been associated with the server (DNS name).IA00.1
#DBS-OLAP-DATABASE
OLAP_DATABASE		Alpha 30 (Lower Case)—IA00.1
#DBS-INSTANCE-NAME
INSTANCE_NAME		Alpha 40 (Lower Case)The Server Name field contains the IP address of the server to which you are connecting. You can also specify a name that has been associated with the server (DNS name).IA00.1

Indexes (2)

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
DBSSET1
  1. DATABASE-SPACE
Primary, KeyChangeIA00.1, IA00.6, IA02.1, IA05.2, IA10.1, IA100, IA120, IA125 +8 more
DBSSET2
  1. DATABASE-TYPE
  2. DATABASE-SPACE
KeyChangeIA100

Relations

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

One to one (1) — lookups and parents

RelationTableRulesConditionField map
IadesttypeIADESTTYPERequired
DBS-DATABASE-TYPE→DES-DATABASE-TYPE

One to many (2) — child tables

RelationTableRulesConditionField map
OlapdbmOLAPDBM
DBS-DATABASE-SPACE→ODB-DATABASE-SPACE
—→ODB-DATA-MART-NAME
RolapdimROLAPDIM
DBS-DATABASE-SPACE→ROL-DATABASE-SPACE
—→ROL-USER-DIM-NAME

Programs

Updated by (4)

Referenced by (12)