Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             ROLAPDIM FILE

REFERENCED BY

IAAH.1    IADE.1    ACDL.1    AMDL.1    HCOP.1    HCOP.2
GLOP.1    POA3.1

UPDATED 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    HCAC.1    HCAG.1    HCCL.1
HCCP.1    HCEC.1    HCEM.1    HCEO.1    HCEX.1    HCGL.1
HCGN.1    HCJC.1    HCLO.1    HCMS.1    HCMS.2    HCPL.1
HCPO.1    HCRV.1    HCSC.1    HCSH.1    HCST.1    HCSU.1
HCTM.1    HCUF.1    HCUL.1    HCUN.1    HCYR.1    IAAP.1
GLBA.1    GLBD.1    GLBP.1    GLBT.1    GLBY.1    IFBA.1
IFBC.1    IFBO.1    IFBS.1    POAB.1    POAM.1    POAO.1
POAP.1    POAV.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ROL-USER-DIM-NAME    Alpha 50  (Lower Case)                      IAAP.1
User Dim Name        The User Dimension Name is the name
                     associated with the dimension in the
                     data mart outline. This user-defined
                     name can contain up to 50 alphanumeric
                     characters. For example, you might name
                     a dimension Fiscal Year or Organization.


ROL-DIM-OBJ-ID       Numeric 12                                  IAAP.1
Dim Obj Id           The Dimension Object Identifier field
                     contains a unique numeric identifier
                     assigned to the dimension, which
                     associates this record to the member
                     records.

ROL-LAST-META-ID     Numeric 9                                   ACBA.1  ACBC.1
Last Meta Id                                                     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  GLBA.1
                                                                 GLBD.1  GLBP.1
                                                                 GLBT.1  GLBY.1
                                                                 HCAC.1  HCAG.1
                                                                 HCCL.1  HCCP.1
                                                                 HCEC.1  HCEM.1
                                                                 HCEO.1  HCEX.1
                                                                 HCGL.1  HCGN.1
                                                                 HCJC.1  HCLO.1
                                                                 HCMS.1  HCMS.2
                                                                 HCPL.1  HCPO.1
                                                                 HCRV.1  HCSC.1
                                                                 HCSH.1  HCST.1
                                                                 HCSU.1  HCTM.1
                                                                 HCUF.1  HCUL.1
                                                                 HCUN.1  HCYR.1
                                                                 IFBA.1  IFBC.1
                                                                 IFBO.1  IFBS.1
                                                                 POAB.1  POAM.1
                                                                 POAO.1  POAP.1
                                                                 POAV.1

ROL-LAST-PARENT-ID   Numeric 9                                   ACBA.1  ACBC.1
Last Parent Id                                                   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  GLBA.1
                                                                 GLBD.1  GLBP.1
                                                                 GLBT.1  GLBY.1
                                                                 HCAC.1  HCAG.1
                                                                 HCCL.1  HCCP.1
                                                                 HCEC.1  HCEM.1
                                                                 HCEO.1  HCEX.1
                                                                 HCGL.1  HCGN.1
                                                                 HCJC.1  HCLO.1
                                                                 HCMS.1  HCMS.2
                                                                 HCPL.1  HCPO.1
                                                                 HCRV.1  HCSC.1
                                                                 HCSH.1  HCST.1
                                                                 HCSU.1  HCTM.1
                                                                 HCUF.1  HCUL.1
                                                                 HCUN.1  HCYR.1
                                                                 IFBA.1  IFBC.1
                                                                 IFBO.1  IFBS.1
                                                                 POAB.1  POAM.1
                                                                 POAO.1  POAP.1
                                                                 POAV.1

ROL-GENERATIONS      Numeric 2                                   ACBA.1  ACBC.1
Generations                                                      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  GLBA.1
                                                                 GLBD.1  GLBP.1
                                                                 GLBT.1  GLBY.1
                                                                 HCAC.1  HCAG.1
                                                                 HCCL.1  HCCP.1
                                                                 HCEC.1  HCEM.1
                                                                 HCEO.1  HCEX.1
                                                                 HCGL.1  HCGN.1
                                                                 HCJC.1  HCLO.1
                                                                 HCMS.1  HCMS.2
                                                                 HCPL.1  HCPO.1
                                                                 HCRV.1  HCSC.1
                                                                 HCSH.1  HCST.1
                                                                 HCSU.1  HCTM.1
                                                                 HCUF.1  HCUL.1
                                                                 HCUN.1  HCYR.1
                                                                 IAAP.1  IFBA.1
                                                                 IFBC.1  IFBO.1
                                                                 IFBS.1  POAB.1
                                                                 POAM.1  POAO.1
                                                                 POAP.1  POAV.1

ROL-ASYMETRIC-OPT    Alpha 1
Asymetric Opt

ROL-LAW-DIM-NAME     Alpha 50  (Lower Case)                      IAAP.1
Law Dim Name         The Lawson Dimension Name is the name
                     of the Lawson defined dimension name.
                     Instead of the User Dimension Name, this
                     name is assigned by the Analytic
                     Architect system and is used by the
                     system that provides data to the
                     Analytic Architect system. If a user
                     changes the User Dimension Name, data
                     sent to the data mart is unaffected.

ROL-DIM-BUILD-DTE    Numeric 8  (yyyymmdd)
Dim Build Dte        The Dimension Build Date field contains
                     the most recent date that this dimension
                     was updated in the outline. The date
                     format used is YYYYMMDD.

ROL-DIM-BUILD-TME    Numeric 6  (hhmmss)
Dim Build Tme        The Dimension Build Time field contains
                     the most recent time that this dimension
                     was updated in the outline. The time
                     format used is HHMMSS.

ROL-DATABASE-SPACE   Alpha 25  (Lower Case)                      IAAP.1
Database Space

ROL-META-FILE-NAME   Alpha 50  (Lower Case)                      IAAP.1
Meta File Name

ROL-DIMENSION-TYPE   Alpha 1                                     IAAP.1
Dimension Type       The Dimension Type field specifies the
                     dimension owner.

                     Value values are:
                     L = Lawson
                     U = User

ROL-SECURITY-ON      Alpha 1                                     IAAP.1
Security On          This field indicates whether the budget
                     is securing individuals from access.
                     Y = Security is On
                     N = Security is Off

ROL-PARAMS-EXIST     Alpha 1
Params Exist         Y = Yes
                     N = No

ROL-TABLE-CHANGE     Alpha 1                                     ACBA.1  ACBC.1
Table Change         Y = Yes                                     ACBP.1  ACBR.1
                     N = No                                      ACBS.1  ACBU.1
                                                                 ACBY.1  AMAS.1
                                                                 AMBK.1  AMCV.1
                                                                 AMLF.1  AMMD.1
                                                                 AMME.1  AMPD.1
                                                                 AMYR.1  GLBA.1
                                                                 GLBD.1  GLBP.1
                                                                 GLBT.1  GLBY.1
                                                                 HCAC.1  HCAG.1
                                                                 HCCL.1  HCCP.1
                                                                 HCEC.1  HCEM.1
                                                                 HCEO.1  HCEX.1
                                                                 HCGL.1  HCGN.1
                                                                 HCJC.1  HCLO.1
                                                                 HCMS.1  HCMS.2
                                                                 HCPL.1  HCPO.1
                                                                 HCRV.1  HCSC.1
                                                                 HCSH.1  HCST.1
                                                                 HCSU.1  HCTM.1
                                                                 HCUF.1  HCUL.1
                                                                 HCUN.1  HCYR.1
                                                                 IAAP.1  IFBA.1
                                                                 IFBC.1  IFBO.1
                                                                 IFBS.1  POAB.1
                                                                 POAM.1  POAO.1
                                                                 POAP.1  POAV.1

ROL-DEFN-PROGRAM     Alpha 5                                     IAAP.1
Define Program       The Data Mart Setup Program field
                     contains the name of the program that
                     provides the dimensions, members, and
                     data selection parameters required by
                     the data mart.

ROL-META-PROGRAM     Alpha 6                                     IAAP.1
Meta Program         The Outline Build Program field
                     contains the name of the program that
                     the Analytic Architect system calls to
                     supply the outline (description of the
                     data) to the data mart. This may be the
                     same program as the data values load
                     program.

ROL-FACT-TABLE-OPT   Alpha 1
Fact Table Opt

ROL-NBR-COLUMNS      Numeric 3                                   ACBA.1  ACBC.1
Nbr Columns                                                      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  GLBA.1
                                                                 GLBD.1  GLBP.1
                                                                 GLBT.1  GLBY.1
                                                                 HCAC.1  HCAG.1
                                                                 HCCL.1  HCCP.1
                                                                 HCEC.1  HCEM.1
                                                                 HCEO.1  HCEX.1
                                                                 HCGL.1  HCGN.1
                                                                 HCJC.1  HCLO.1
                                                                 HCMS.1  HCMS.2
                                                                 HCPL.1  HCPO.1
                                                                 HCRV.1  HCSC.1
                                                                 HCSH.1  HCST.1
                                                                 HCSU.1  HCTM.1
                                                                 HCUF.1  HCUL.1
                                                                 HCUN.1  HCYR.1
                                                                 IFBA.1  IFBC.1
                                                                 IFBO.1  IFBS.1
                                                                 POAB.1  POAM.1
                                                                 POAO.1  POAP.1
                                                                 POAV.1

ROL-CREATED-GEN      Alpha 1                                     IAAP.1
Created Gen          Y = Yes
                     N = No
                     " " = No

ROL-TABLE-FORMAT     Alpha 1                                     IAAP.1
Table Format         L = Level Heirarchy
                     P = Parent/Child

ROL-SORT-OPTION      Alpha 1                                     IAAP.1
Sort Option          This field will determine whether the
                     members of the dimension will appear in
                     an alphabetical or input order in the
                     star schema tables. The input order is
                     the order that would typically be seen
                     on a report or screen within Lawson.
                     Or, in other words, the logical order of
                     members.
                     A = Alphabetical
                     I = Input Order

ROL-COLUMNS-KNOWN    Alpha 1                                     IAAP.1
Columns Known        This field is used to indicate wheter
                     the Star Schema Columns for this
                     dimension table are known yet.
                     Y = Yes
                     N = No

ROL-DIMENSION-CAT    Alpha 1                                     IAAP.1
Dimension Cat        The Dimension Category field specifies
                     the category to be assigned to the
                     dimension in the outline. Choose this
                     category by the type of data that will
                     populate the data mart.

                     Dimension categories are predefined by
                     the data mart. Categories specify the
                     attributes for the dimension. These
                     attributes affect how the data mart
                     performs and stores data.

                     Value values are:
                     ~ = No category
                     A = Accounts
                     C = Currency
                     T = Time
                     Y = Country

ROL-ALIAS-NAME       Alpha 80  (Lower Case)
Alias Name           The Alias Name field contains an alias
                     name for the dimension.

                         ROLAPDIM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ROLSET1   USER-DIM-NAME KeyChange                                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  HCAC.1
                                                                 HCAG.1  HCCL.1
                                                                 HCCP.1  HCEC.1
                                                                 HCEM.1  HCEO.1
                                                                 HCEX.1  HCGL.1
                                                                 HCGN.1  HCJC.1
                                                                 HCLO.1  HCMS.1
                                                                 HCMS.2  HCPL.1
                                                                 ...

ROLSET2   DIM-OBJ-ID    KeyChange                                ACDL.1  AMDL.1
                                                                 HCOP.1  HCOP.2
                                                                 GLOP.1  POA3.1

ROLSET3   LAW-DIM-NAME  KeyChange
          USER-DIM-NAME

ROLSET4   LAW-DIM-NAME  KeyChange
          DIM-OBJ-ID

ROLSET5   DATABASE-SPACEKeyChange
          USER-DIM-NAME

                         ROLAPDIM FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Iadimtypes     IADIMTYPES   Required

                            ROL-LAW-DIM-NAME    -> IDT-LAW-DIM-NAME  (IDTSET2)

                         ROLAPDIM FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Iaattrib       IAATTRIB     Delete Cascades

                            ROL-DIM-OBJ-ID      -> IAT-DIM-OBJ-ID
                                                   IAT-ATTRIBUTE-NAME

Olapdim        OLAPDIM

                            ROL-DIM-OBJ-ID      -> OLD-DIM-OBJ-ID
                                                   OLD-DATA-MART-NAME

Rolapids       ROLAPIDS

                            ROL-DIM-OBJ-ID      -> RID-DIM-OBJ-ID
                                                   RID-META-ID