Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ROLAPDBS


                             ROLAPDBS FILE

REFERENCED BY

IAAP.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

DBS-DATABASE-SPACE     Alpha 25  (Lower Case)
Element: Database Space

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

DBS-FILE-DIRECTORY     Alpha 100  (Lower Case)
Element: File Directory

DBS-FILE-EXTENSION     Alpha 3  (Lower Case)
Element: File Extension

DBS-SERVER-NAME        Alpha 40  (Lower Case)
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-PRODUCT-LINE       Alpha 14
Element: Product Line

DBS-DATABASE           Alpha 30  (Lower Case)
Element: Database

DBS-LOGIN              Alpha 30  (Lower Case)
Element: Login

DBS-ENCRYPT-PASSWD     Alpha 30  (Lower Case)
Element: Encrypt Passwd

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

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

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

DBS-APP-SERVER         Alpha 50  (Lower Case)
Element: App Server

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

DBS-FTP-LOCATION       Alpha 100  (Lower Case)
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)
Element: Ftp Txt Loc   The actual directory in which the text
                       files are sent to the SQL Server server.

DBS-ENABLE-XML         Alpha 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
Element: Asp Customer

DBS-NUMERIC-ID         Numeric 3
Element: Numeric Id

                         ROLAPDBS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

DBSSET1   DATABASE-SPACEKeyChange                                IAAP.1

DBSSET2   DATABASE-TYPE KeyChange
          DATABASE-SPACE

                         ROLAPDBS FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Olapdbm        OLAPDBM

                            DBS-DATABASE-SPACE    -> ODB-DATABASE-SPACE  (ODBSET4)
                                                     ODB-DATA-MART-NAME

Rolapdim       ROLAPDIM

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