Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ROLAPDIM


                             ROLAPDIM FILE

REFERENCED BY

AM88.1    IAAH.1    IADE.1    IFEO.1    POA2.1    POA2.3
ACDL.1    AMDL.1    HCOP.1    HCOP.2    GLOP.1    POA3.1
WODL.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    WOME.1    WOOR.1    WOPR.1    WOSC.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ROL-USER-DIM-NAME      Alpha 50  (Lower Case)                    IAAP.1
Element: 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
Element: 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
Element: 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  WOME.1
                                                                 WOOR.1  WOPR.1
                                                                 WOSC.1

ROL-LAST-PARENT-ID     Numeric 9                                 ACBA.1  ACBC.1
Element: 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  WOME.1
                                                                 WOOR.1  WOPR.1
                                                                 WOSC.1

ROL-GENERATIONS        Numeric 2                                 ACBA.1  ACBC.1
Element: 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
                                                                 WOME.1  WOOR.1
                                                                 WOPR.1  WOSC.1

ROL-ASYMETRIC-OPT      Alpha 1
Element: Asymetric Opt

ROL-LAW-DIM-NAME       Alpha 50  (Lower Case)                    IAAP.1
Element: 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)
Element: 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)
Element: 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
Element: Database Space

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

ROL-DIMENSION-TYPE     Alpha 1                                   IAAP.1
Element: Dimension TypeThe Dimension Type field specifies the
                       dimension owner.

                       Value values are:
                       L = Lawson
                       U = User

ROL-SECURITY-ON        Alpha 1                                   IAAP.1
Element: 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
Element: Params Exist  Y = Yes
                       N = No

ROL-TABLE-CHANGE       Alpha 1                                   ACBA.1  ACBC.1
Element: 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
                                                                 WOME.1  WOOR.1
                                                                 WOPR.1  WOSC.1

ROL-DEFN-PROGRAM       Alpha 5                                   IAAP.1
Element: Define ProgramThe 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
Element: 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
Element: Fact Table Opt

ROL-NBR-COLUMNS        Numeric 3                                 ACBA.1  ACBC.1
Element: 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  WOME.1
                                                                 WOOR.1  WOPR.1
                                                                 WOSC.1

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

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

ROL-SORT-OPTION        Alpha 1                                   IAAP.1
Element: 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
Element: 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
Element: 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)
Element: 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  AM88.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
                                                                 ...

ROLSET2   DIM-OBJ-ID    KeyChange                                ACDL.1  AMDL.1
                                                                 HCOP.1  HCOP.2
                                                                 GLOP.1  POA3.1
                                                                 WODL.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