Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ROLAPDBS


                             ROLAPDBS FILE

REFERENCED BY

IA02.1    IA05.2    IA100     IA120     IA125     IA150
IA300     IAAP.1    IANM.1    POA1.1    POA10     POA3.1


UPDATED BY

IA00.1    IA00.6    IA10.1    IASV.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

DBS-DATABASE-SPACE     Alpha 25  (Lower Case)                    IA00.1  IA00.6
Element: Database Space                                          IA02.1  IASV.1

DBS-DATABASE-TYPE      Alpha 1                                   IA00.1  IA00.6
Element: Database Type E = Essbase                               IASV.1
                       S = SQL Server
                       A = ASCII

DBS-FILE-DIRECTORY     Alpha 100  (Lower Case)                   IA00.1  IA00.6
Element: File Directory

DBS-FILE-EXTENSION     Alpha 3  (Lower Case)                     IA00.1  IA00.6
Element: File Extension

DBS-SERVER-NAME        Alpha 40  (Lower Case)                    IA00.1  IA00.6
Element: Server Name   The Server Name field contains the IP     IASV.1
                       address of the server to which you are
                       connecting. You can also specify a name
                       that has been associated with the server
                       (DNS name).

DBS-PRODUCT-LINE       Alpha 14
Element: Product Line

DBS-DATABASE           Alpha 30  (Lower Case)                    IA00.1  IA00.6
Element: Database

DBS-LOGIN              Alpha 30  (Lower Case)                    IA00.1  IA00.6
Element: Login

DBS-ENCRYPT-PASSWD     Alpha 30  (Lower Case)                    IA00.1  IA00.6
Element: Encrypt Passwd

DBS-LAW-WEB-SERVER     Alpha 50  (Lower Case)                    IA00.6
Element: Law Web Server

DBS-LAW-WEB-USER       Alpha 40  (Lower Case)                    IA00.6
Element: Law Web User

DBS-LAW-WEB-ECR-PW     Alpha 15  (Lower Case)                    IA00.6
Element: Law Web Ecr Pw

DBS-APP-SERVER         Alpha 50  (Lower Case)                    IA00.1  IA00.6
Element: App Server

DBS-APP-DIR-ALIAS      Alpha 30  (Lower Case)                    IA00.1  IA00.6
Element: App Dir Alias

DBS-FTP-LOCATION       Alpha 100  (Lower Case)                   IA00.1  IA00.6
Element: Ftp Location  This is the directory that is a valid
                       for ftp purposes, pertaining to the
                       server in which SQL Server resides.

DBS-FTP-TXT-LOC        Alpha 100  (Lower Case)                   IA00.1  IA00.6
Element: Ftp Txt Loc   The actual directory in which the text
                       files are sent to the SQL Server server.

DBS-ENABLE-XML         Alpha 1                                   IA00.1  IASV.1
Element: Enable Xml    " " = No XML Output
                       A = XML Output Active
                       X = XML Output Only

DBS-ASP-DEST           Alpha 1
Element: Asp Dest      Y = Yes
                       N = No

DBS-ASP-CUSTOMER       Numeric 9                                 IA00.1  IASV.1
Element: Asp Customer

DBS-NUMERIC-ID         Numeric 3                                 IA10.1  IASV.1
Element: Numeric Id

DBS-OLAP-SERVER        Alpha 40  (Lower Case)                    IA00.1
Element: Server Name   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).

DBS-OLAP-DATABASE      Alpha 30  (Lower Case)                    IA00.1
Element: Database

DBS-INSTANCE-NAME      Alpha 40  (Lower Case)                    IA00.1
Element: Server Name   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).

                         ROLAPDBS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

DBSSET1   DATABASE-SPACEKeyChange                                IA00.1  IA00.6
                                                                 IA02.1  IA05.2
                                                                 IA10.1  IA100
                                                                 IA120   IA125
                                                                 IA150   IA300
                                                                 IAAP.1  IANM.1
                                                                 IASV.1  POA1.1
                                                                 POA10   POA3.1

DBSSET2   DATABASE-TYPE KeyChange                                IA100
          DATABASE-SPACE

                         ROLAPDBS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Iadesttype     IADESTTYPE   Required

                            DBS-DATABASE-TYPE     -> DES-DATABASE-TYPE

                         ROLAPDBS FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Olapdbm        OLAPDBM

                            DBS-DATABASE-SPACE    -> ODB-DATABASE-SPACE
                                                     ODB-DATA-MART-NAME

Rolapdim       ROLAPDIM

                            DBS-DATABASE-SPACE    -> ROL-DATABASE-SPACE
                                                     ROL-USER-DIM-NAME