 |
Lawson Insight Technical Documentation |
|
ROLAPDIM FILE
REFERENCED BY
IA80.1 IA85.1 IAAH.1 IADE.1 IASD.1 ACDL.1
AMDL.1 HCOP.1 HCOP.2 GLOP.1 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 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 IA00.6
IA02.1 IA100 IA120 IA15.4 IA150 IAAP.1
IAMB.1 IANM.1 IATM.1 IAYR.1 GLBA.1 GLBD.1
GLBP.1 GLBT.1 GLBY.1 IFBA.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) IA02.1 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 IA02.1 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
IA120 IA150
IAMB.1 IATM.1
IAYR.1 IFBA.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
IA120 IA150
IAMB.1 IATM.1
IAYR.1 IFBA.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
IA120 IA150
IAAP.1 IAMB.1
IATM.1 IAYR.1
IFBA.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) IA02.1 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) IA150
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
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
Database Space IAAP.1
ROL-META-FILE-NAME Alpha 50 (Lower Case) IA02.1 IA15.4
Meta File Name IAAP.1
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
IA120 IA150
IAAP.1 IAMB.1
IANM.1 IATM.1
IAYR.1 IFBA.1
IFBO.1 IFBS.1
POAB.1 POAM.1
POAO.1 POAP.1
...
ROL-DEFN-PROGRAM Alpha 5 IA02.1 IA100
Define Program The Data Mart Setup Program field 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 IA02.1 IA100
Meta Program The Outline Build Program field IA15.4 IAAP.1
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
IA120 IA150
IAMB.1 IATM.1
IAYR.1 IFBA.1
IFBO.1 IFBS.1
POAB.1 POAM.1
POAO.1 POAP.1
POAV.1
ROL-CREATED-GEN Alpha 1 IA02.1 IA150
Created Gen Y = Yes IAAP.1 IANM.1
N = No
" " = No
ROL-TABLE-FORMAT Alpha 1 IA02.1 IAAP.1
Table Format L = Level Heirarchy
P = Parent/Child
ROL-SORT-OPTION Alpha 1 IA02.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 IA02.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
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
|