Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OLAPDBM


                              OLAPDBM FILE

                           Data Mart Manager

The Data Mart Manager (OLAPDBM) file stores information about each data mart
that has been defined by IA10.1 (Data Mart Manager) program.

REFERENCED BY

ACBA.1    ACBC.1    ACBP.1    ACBR.1    ACBS.1    ACBU.1
ACBY.1    AMAS.1    AMBK.1    AMCV.1    AMLF.1    AMMD.1
AMME.1    AMPD.1    AMYR.1    HCAG.1    HCCP.1    HCEM.1
HCHM.1    HCJC.1    HCMS.1    HCPO.1    HCRV.1    HCSC.1
HCSU.1    HCYR.1    IA03.1    IA04.1    IA04.2    IA08.1
IA115     IA12.1    IA12.2    IA12.3    IA125     IA13.1
IA14.1    IA16.1    IA200     IA300     IADE.1    IAMB.1
IAMD.1    IAMR.1    IAPF.1    IASD.1    IATM.1    IAVO.1
IAYR.1    GLBA.1    GLBD.1    GLBP.1    GLBT.1    GLBY.1
IFBA.1    IFBC.1    IFBO.1    IFBS.1    IFEO.1    POA1.1
POA10     POAB.1    POAM.1    POAO.1    POAP.1    SACU.1
SALO.1    SAMM.1    SAOR.1    SASC.1    SATE.1    WOME.1
WOOR.1    WOPR.1    WOSC.1    IA01.1    IA01.3    IA00.1
IA00.6

UPDATED BY

ACDL.1    AMDL.1    HCDL.1    HCHP.1    IA05.1    IA05.3
IA10.1    IA10.2    IA11.2    IA120     IA15.1    IA15.4
IA150     IA20.1    IAAP.1    IANM.1    IASV.1    IASV.2
GLOP.1    POA3.1    SALD.1    WODL.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ODB-DATA-MART-NAME     Alpha 20  (Lower Case)                    IA10.1  IASV.1
Element: Data Mart NameThis field contains the name of the data
                       mart.

ODB-DESCRIPTION        Alpha 30  (Lower Case)                    IA10.1  IASV.1
Element: Description   The Description field contains a
                       description of the data mart.

ODB-APPLIC-TYPE        Alpha 3                                   IA10.1  IASV.1
Data Mart Type         The Application Type file stores the
                       names of the Lawson applications that
                       can be requested to supply information
                       to the OLAP database. The Lawson
                       applications that are currently
                       OLAP-ready are:

                       FIN = Financial Analyzer
                       FND = Daily Financial Analyzer
                       SA = Sales Analyzer
                       CX = Case Cart Analyzer
                       PO = Purchasing Analyzer
                       WO = Work Order Analyzer

ODB-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).

ODB-DIM-BUILD-DTE      Numeric 8  (yyyymmdd)                     IA10.2  IA120
Element: Dimension BuilThe Dimension Build Date field contains   IASV.2
                       the most recent date that this dimension
                       was updated in the outline. The date
                       format used is YYYYMMDD.

ODB-DIM-BUILD-TME      Numeric 6  (hhmmss)                       IA10.2  IA120
Element: Dimension BuilThe Dimension Build Time field contains   IASV.2
                       the most recent time that this dimension
                       was updated in the outline. The time
                       format used is HHMMSS.

ODB-DATA-BUILD-DTE     Numeric 8  (yyyymmdd)                     IA10.2  IA120
Element: Data Load DateThe Data Load Date field contains the     IA150   IASV.2
                       most recent date that the OLAP data mart
                       was populated with data values. The date
                       format used is YYYYMMDD.

ODB-DATA-BUILD-TME     Numeric 6  (hhmmss)                       IA10.2  IA120
Element: Data Load TimeThe Data Load Time field contains the     IA150   IASV.2
                       most recent time that the OLAP data mart
                       was populated with data values. The time
                       format used is HHMMSS.

ODB-REQ-DIM-REBLD      Alpha 1                                   IA10.1  IA120
Required Dimension     The value in the Required Dimension       IA15.1  IAAP.1
Rebuild                Rebuild field is set by the system. The
                       value is based on whether changes that
                       require the dimensions to be rebuilt
                       have been made to the data mart.

                       Valid values are:
                       Y = Yes
                       N = No; Default value.

ODB-REQ-DATA-REBLD     Alpha 1                                   IA10.1  IA120
Element: Required Data The Required Data Reload field is set     IA150   IAAP.1
                       by the system. The setting is based on
                       whether changes that require the data
                       values to be reloaded have been made to
                       the data mart.

                       Valid values are:
                       Y = Yes
                       N = No; Default value.

ODB-LOCK-OPTION        Alpha 1
Element: Lock Option   The Lock Option field provides
                       additional security by preventing
                       changes to the data mart definition,
                       even if the user tries to initiate an
                       outline build or a data load. The
                       operation of this field depends on the
                       user's security privileges.

                       Value values are:
                       Y = Yes
                       N = No; Default value.

ODB-PROCESSING         Alpha 1                                   IA05.1  IA05.3
Element: Processing    The Processing field shows the current    IA120   IA150
                       status of the data mart. It provides a    IASV.1
                       locking mechanism to prevent updates
                       when data is being loaded to the data
                       mart.

                       Value values are:
                       ~ = No data is being processed
                       M = Outline build in process
                       D = Data load in process
                       C = Data mart calculation in process

                       " " = Not Processing
                       L = Process Lawson Data
                       A = Process MSOLAP
                       F = FTP Data

ODB-AUTO-REBUILD       Alpha 1
Element: Auto Rebuild  The Auto Rebuild field determines
                       whether the data mart should be rebuilt
                       if dimensions or data values have
                       changed. If an incremental data load is
                       requested, this field uses the values in
                       the Required Dimension Rebuild and
                       Required Data Reload fields to determine
                       if the data mart should be reloaded. Set
                       this field to Y if all data for a
                       complete load is still available.

                       Valid values are:
                       Y = Yes
                       N = N; Default value.

ODB-ERROR-LOG-NBR      Numeric 3
Element: Error Log NumbThe Error Log Number field displays the
                       error message number found during the
                       outline build or data mart load.

ODB-LAST-DIM-SEQ       Numeric 4                                 IA15.1  IAAP.1
Last Dimension         The Last Dimension Sequence Number
Sequence Number        field contains the sequence number of
                       the last dimension in the outline. The
                       number in this field determines the
                       number of the next dimension that is
                       added to the outline.

ODB-STAGE-APP-NAME     Alpha 8  (Lower Case)                     IA11.2
Staging Application    The Stage Application Name field
Name                   contains the name of the application
                       that is temporarily created when the
                       data mart staging option is set. Staging
                       a data mart lets users work with the
                       data mart while data is being loaded.
                       This name can contain up to 8 characters
                       of any kind.

ODB-ADDT-SOURCES       Alpha 1                                   IA05.1  IA10.1
External Data          The External Data Sources Exists field    IASV.1
Sources Exist          determines whether external data sources
                       are used to update the data mart. A
                       value of Y (Yes) in this field indicates
                       that external data sources exist,
                       thereby preventing the administrator
                       from clearing the data mart prior to
                       updating it.

                       Valid values are:
                       Y = Yes. External data sources exist.
                       N = No; Default value.

ODB-DATA-TARGET        Alpha 1                                   IA10.1  IASV.1
Element: Data Target   1 = Hyperion Essbase Server
                       2 = Star Schema Format

ODB-ARBOR-PATH         Alpha 100  (Lower Case)                   IA05.1  IA120
Element: Arbor Path    The Arbor Path field contains the name    IASV.1
                       of the directory where all CSV output
                       files are stored.

ODB-DTA-DRILL-PATH     Alpha 100  (Lower Case)
Element: Dta Drill Path

ODB-APPLIC-NAME        Alpha 8  (Lower Case)                     IA05.1  IA10.1
Element: Application NaThe Application Name is the name of the   IASV.1
                       application that describes the database
                       names it contains. This user-defined
                       name can contain up to eight characters.
                       The first letter of the name must be
                       capitalized.

ODB-DATABASE-NAME      Alpha 8  (Lower Case)                     IA05.1  IA10.1
Element: Database Name The Database Name is the name of the      IASV.1
                       database that is stored within the OLAP
                       application. Each application may
                       contain more than one database. This
                       user-defined name can contain up to
                       eight characters. The first letter of
                       the name must be capitalized.

ODB-ACTIVE-STATUS      Alpha 1                                   IA10.1
Element: Status        The status of the account. If Inactive,
                       no posting can be done to the account.

                       A = Active
                       I = Inactive

ODB-SECURITY-ON        Alpha 1                                   IA10.1  IA20.1
Element: Security On   This field indicates whether the budget
                       is securing individuals from access.
                       Y = Yes
                       N = No

ODB-MART-CREATOR       Alpha 20  (Lower Case)                    IA10.1
Element: Mart Creator

ODB-DATABASE-SPACE     Alpha 25  (Lower Case)                    IA10.1  IASV.1
Element: Database Space

ODB-CREATED-GEN        Alpha 1                                   IA10.1  IA150
Element: Created Gen   Y = Yes                                   IANM.1
                       N = No
                       " " = No

ODB-TABLE-CHANGE       Alpha 1                                   ACDL.1  AMDL.1
Element: Table Change                                            GLOP.1  HCDL.1
                                                                 HCHP.1  IA10.1
                                                                 IA150   IANM.1
                                                                 POA3.1  SALD.1
                                                                 WODL.1

ODB-FACT-TBL-NAME      Alpha 50  (Lower Case)
Element: Fact Tbl Name

ODB-NBR-COLUMNS        Numeric 3                                 ACDL.1  AMDL.1
Element: Nbr Columns                                             GLOP.1  HCDL.1
                                                                 HCHP.1  IA150
                                                                 POA3.1  SALD.1
                                                                 WODL.1

ODB-OLAP-TYPE          Alpha 1
Element: Olap Type     X = XML OUTPUT
                       C = CSV OUTPUT

ODB-DRILL-ENABLED      Alpha 1                                   IA05.1  IA10.1
Element: Drill Enabled This field indicates whether drill
                       around functionality should be enabled
                       for this data mart.
                       Y = Yes
                       N = No

ODB-SERVICE-OPTION     Alpha 1                                   IASV.1
Element: Service OptionThis flag determines whether the data
                       mart will be built by an internal
                       server or a service provider.
                       Y = Yes
                       N = No

ODB-CONVERTED          Alpha 1                                   IA120
Element: Converted     " " = Requires Conversion
                       N = Does Not Require Conversion

ODB-OLAP-STORAGE       Alpha 1                                   IA05.3  IA10.1
Element: Olap Storage  This determines the data storage that
                       will be utilized for the data mart cube.
                       The options are Molap
                       (multidimensional), Rolap (relational),
                       or Holap (hybrid of relational and
                       multidimensional).
                       M = Molap
                       R = Rolap
                       H = Holap

ODB-OLAP-AGGR-OPT      Alpha 1                                   IA05.3  IA10.1
Element: Olap Aggr Opt Olap aggregation option: perform
                       aggregations until the OLAP-AGG-LIMIT is
                       hit.
                       S = Storage
                       P = Performance

ODB-OLAP-AGGR-LIMT     Alpha 10                                  IA05.3  IA10.1
Element: Olap Aggr LimtOlap aggregation limit: max storage size
                       or performance percentage in which to
                       perform aggregations. This field and the
                       OLAP-AGGR-OPT are concatenated together
                       to describe how aggregation should
                       function.

ODB-OBJ-ID-PREFIX      Numeric 3
Element: Obj Id Prefix

ODB-OBJ-ID-SUFFIX      Numeric 9
Element: Obj Id Suffix

ODB-ENABLE-XML         Alpha 1
Element: Enable Xml    " " = Destination Default
                       A = XML Output Active
                       X = XML Output Only

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

                         OLAPDBM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ODBSET1   DATA-MART-NAME                                         ACBA.1  ACBC.1
                                                                 ACBP.1  ACBR.1
                                                                 ACBS.1  ACBU.1
                                                                 ACBY.1  ACDL.1
                                                                 AMAS.1  AMBK.1
                                                                 AMCV.1  AMDL.1
                                                                 AMLF.1  AMMD.1
                                                                 AMME.1  AMPD.1
                                                                 AMYR.1  HCAG.1
                                                                 HCCP.1  HCDL.1
                                                                 HCEM.1  HCHM.1
                                                                 HCHP.1  HCJC.1
                                                                 HCMS.1  HCPO.1
                                                                 HCRV.1  HCSC.1
                                                                 HCSU.1  HCYR.1
                                                                 ...

ODBSET2   APPLIC-TYPE   KeyChange                                IA01.1  IA01.3
          DATA-MART-NAME                                         IASV.1

ODBSET3   APPLIC-NAME   KeyChange                                IA10.1  IASD.1
          DATABASE-NAME                                          IASV.1
          DATA-MART-NAME

ODBSET4   DATABASE-SPACEKeyChange                                IA00.1  IA00.6
          DATA-MART-NAME

ODBSET5   DATABASE-SPACEKeyChange
          FACT-TBL-NAME
          DATA-MART-NAME

                         OLAPDBM FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Applictype     APPLICTYPE   Required

                            ODB-APPLIC-TYPE       -> IAA-APPLIC-TYPE  (IAASET1)

Rolapdbs       ROLAPDBS     Not Required

                            ODB-DATABASE-SPACE    -> DBS-DATABASE-SPACE

                         OLAPDBM FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Aliastable     ALIASTABLE

                            ODB-DATA-MART-NAME    -> ALI-DATA-MART-NAME
                                                     ALI-ALIAS-TABLE

Datasource     DATASOURCE

                            ODB-DATA-MART-NAME    -> DAT-DATA-MART-NAME
                                                     DAT-DATA-LOAD-NAME

Dimdatarel     DIMDATAREL

                            ODB-DATA-MART-NAME    -> DDR-DATA-MART-NAME
                                                     DDR-USER-DIM-NAME
                                                     DDR-DATA-LOAD-NAME

Member         MEMBER

                            ODB-DATA-MART-NAME    -> MBR-DATA-MART-NAME
                                                     MBR-MEMBER-NAME

Olapdim        OLAPDIM

                            ODB-DATA-MART-NAME    -> OLD-DATA-MART-NAME
                                                     OLD-USER-DIM-NAME

Olapdim 3      OLAPDIM

                            ODB-DATA-MART-NAME    -> OLD-DATA-MART-NAME
                                                     OLD-SEQUENCE-NBR
                                                     OLD-USER-DIM-NAME

Olapprof       OLAPPROF

                            ODB-DATA-MART-NAME    -> OLP-DATA-MART-NAME
                                                     OLP-DATA-MART-GRP
                                                     OLP-PROFILE-NAME

Olapuda        OLAPUDA

                            ODB-DATA-MART-NAME    -> UDA-DATA-MART-NAME
                                                     UDA-UDA-NAME

Profdatrel     PROFDATREL

                            ODB-DATA-MART-NAME    -> PFL-DATA-MART-NAME
                                                     PFL-PROFILE-NAME
                                                     PFL-DATA-LOAD-NAME