 |
Lawson Insight Technical Documentation |
|
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
|