Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ROLAPDIM


                             ROLAPDIM FILE

REFERENCED BY

ACDL.1    AM88.1    AMDL.1    CBOP.1    HC02.2    HCDL.1
HCHP.1    IA80.1    IA85.1    IAAH.1    IADE.1    IASD.1
GLOP.1    IFEO.1    POA2.1    POA2.3    POA3.1    IADM.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    CBBB.1    CBBC.1    CBBD.1
CBBO.1    CBBR.1    CBBT.1    HC10.1    HCAG.1    HCCP.1
HCEM.1    HCHM.1    HCJC.1    HCMS.1    HCPO.1    HCRV.1
HCSC.1    HCSU.1    HCYR.1    IA00.6    IA02.1    IA100
IA120     IA15.4    IA150     IAAP.1    IAMB.1    IANM.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
POAB.1    POAM.1    POAO.1    POAP.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ROL-USER-DIM-NAME      Alpha 50  (Lower Case)                    HC10.1  IA02.1
Element: User Dim Name The User Dimension Name is the name       IAAP.1
                       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                                HC10.1  IA02.1
Element: Dim Obj Id    The Dimension Object Identifier field     IAAP.1
                       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  CBBB.1
                                                                 CBBC.1  CBBD.1
                                                                 CBBO.1  CBBR.1
                                                                 CBBT.1  GLBA.1
                                                                 GLBD.1  GLBP.1
                                                                 GLBT.1  GLBY.1
                                                                 HCAG.1  HCCP.1
                                                                 HCEM.1  HCHM.1
                                                                 HCJC.1  HCMS.1
                                                                 HCPO.1  HCRV.1
                                                                 HCSC.1  HCSU.1
                                                                 HCYR.1  IA120
                                                                 IA150   IAMB.1
                                                                 IATM.1  IAVO.1
                                                                 IAYR.1  IFBA.1
                                                                 IFBC.1  IFBO.1
                                                                 IFBS.1  POAB.1
                                                                 POAM.1  POAO.1
                                                                 POAP.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  CBBB.1
                                                                 CBBC.1  CBBD.1
                                                                 CBBO.1  CBBR.1
                                                                 CBBT.1  GLBA.1
                                                                 GLBD.1  GLBP.1
                                                                 GLBT.1  GLBY.1
                                                                 HCAG.1  HCCP.1
                                                                 HCEM.1  HCHM.1
                                                                 HCJC.1  HCMS.1
                                                                 HCPO.1  HCRV.1
                                                                 HCSC.1  HCSU.1
                                                                 HCYR.1  IA120
                                                                 IA150   IAMB.1
                                                                 IATM.1  IAVO.1
                                                                 IAYR.1  IFBA.1
                                                                 IFBC.1  IFBO.1
                                                                 IFBS.1  POAB.1
                                                                 POAM.1  POAO.1
                                                                 POAP.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  CBBB.1
                                                                 CBBC.1  CBBD.1
                                                                 CBBO.1  CBBR.1
                                                                 CBBT.1  GLBA.1
                                                                 GLBD.1  GLBP.1
                                                                 GLBT.1  GLBY.1
                                                                 HCAG.1  HCCP.1
                                                                 HCEM.1  HCHM.1
                                                                 HCJC.1  HCMS.1
                                                                 HCPO.1  HCRV.1
                                                                 HCSC.1  HCSU.1
                                                                 HCYR.1  IA120
                                                                 IA150   IAAP.1
                                                                 IAMB.1  IATM.1
                                                                 IAVO.1  IAYR.1
                                                                 IFBA.1  IFBC.1
                                                                 IFBO.1  IFBS.1
                                                                 POAB.1  POAM.1
                                                                 POAO.1  POAP.1

ROL-ASYMETRIC-OPT      Alpha 1
Element: Asymetric Opt

ROL-LAW-DIM-NAME       Alpha 50  (Lower Case)                    HC10.1  IA02.1
Element: Law Dim Name  The Lawson Dimension Name is the name     IAAP.1
                       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)                     IA150
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)                       IA150
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)                    IA00.6  IA02.1
Element: Database Space                                          IAAP.1

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

ROL-DIMENSION-TYPE     Alpha 1                                   HC10.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                                   HC10.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  CBBB.1
                                                                 CBBC.1  CBBD.1
                                                                 CBBO.1  CBBR.1
                                                                 CBBT.1  GLBA.1
                                                                 GLBD.1  GLBP.1
                                                                 GLBT.1  GLBY.1
                                                                 HC10.1  HCAG.1
                                                                 HCCP.1  HCEM.1
                                                                 HCHM.1  HCJC.1
                                                                 HCMS.1  HCPO.1
                                                                 HCRV.1  HCSC.1
                                                                 HCSU.1  HCYR.1
                                                                 IA120   IA150
                                                                 IAAP.1  IAMB.1
                                                                 IANM.1  IATM.1
                                                                 IAVO.1  IAYR.1
                                                                 IFBA.1  IFBC.1
                                                                 IFBO.1  IFBS.1
                                                                 POAB.1  POAM.1
                                                                 POAO.1  POAP.1

ROL-DEFN-PROGRAM       Alpha 5                                   HC10.1  IA02.1
Element: Defn Program  The Data Mart Setup Program field         IA100   IAAP.1
                       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                                   HC10.1  IA02.1
Element: Meta Program  The Outline Build Program field           IA100   IA15.4
                       contains the name of the program that     IAAP.1
                       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  CBBB.1
                                                                 CBBC.1  CBBD.1
                                                                 CBBO.1  CBBR.1
                                                                 CBBT.1  GLBA.1
                                                                 GLBD.1  GLBP.1
                                                                 GLBT.1  GLBY.1
                                                                 HCAG.1  HCCP.1
                                                                 HCEM.1  HCHM.1
                                                                 HCJC.1  HCMS.1
                                                                 HCPO.1  HCRV.1
                                                                 HCSC.1  HCSU.1
                                                                 HCYR.1  IA120
                                                                 IA150   IAMB.1
                                                                 IATM.1  IAVO.1
                                                                 IAYR.1  IFBA.1
                                                                 IFBC.1  IFBO.1
                                                                 IFBS.1  POAB.1
                                                                 POAM.1  POAO.1
                                                                 POAP.1

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

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

ROL-SORT-OPTION        Alpha 1                                   HC10.1  IA02.1
Element: Sort Option   This field will determine whether the     IAAP.1
                       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                                   HC10.1  IA02.1
Element: Columns Known This field is used to indicate wheter     IAAP.1
                       the Star Schema Columns for this
                       dimension table are known yet.
                       Y = Yes
                       N = No

ROL-DIMENSION-CAT      Alpha 1                                   HC10.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.

ROL-CHG-TO-MEASURE     Alpha 1                                   HC10.1  IAAP.1
Element: Chg To Measure

                         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  ACDL.1
                                                                 AM88.1  AMAS.1
                                                                 AMBK.1  AMCV.1
                                                                 AMDL.1  AMLF.1
                                                                 AMMD.1  AMME.1
                                                                 AMPD.1  AMYR.1
                                                                 CBBB.1  CBBC.1
                                                                 CBBD.1  CBBO.1
                                                                 CBBR.1  CBBT.1
                                                                 CBOP.1  HC02.2
                                                                 HC10.1  HCAG.1
                                                                 HCCP.1  HCDL.1
                                                                 ...

ROLSET2   DIM-OBJ-ID    KeyChange                                ACDL.1  AMDL.1
                                                                 CBOP.1  HC10.1
                                                                 HCDL.1  HCHP.1
                                                                 IA150   GLOP.1
                                                                 POA3.1

ROLSET3   LAW-DIM-NAME  KeyChange                                IA00.1
          USER-DIM-NAME

ROLSET4   LAW-DIM-NAME  KeyChange                                IADM.1
          DIM-OBJ-ID

ROLSET5   DATABASE-SPACEKeyChange                                IA00.1  IA00.6
          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

                         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