ROLAPDIM

REFERENCED BY
AM88.1 HC02.2 HCDL.1 POA3.1 ACDL.1 AMDL.1
CBOP.1 HCHP.1 IA80.1 IA85.1 IAAH.1 IADE.1
IASD.1 GLOP.1 IFEO.1 POA2.1 POA2.3 WADL.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 WACP.1 WAD1.1
WAD2.1 WAD3.1 WAD4.1 WAMS.1 WAOP.1 WAPC.1
WAYR.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ROL-USER-DIM-NAME
Element: User Dim Name
Alpha 50 (Lower Case)
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.
HC10.1 IA02.1
IAAP.1
ROL-DIM-OBJ-ID
Element: Dim Obj Id
Numeric 12
The Dimension Object Identifier field contains a unique numeric identifier assigned to the dimension, which associates this record to the member records.
HC10.1 IA02.1
IAAP.1
ROL-LAST-META-ID
Element: Last Meta Id
Numeric 9
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 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 WACP.1
WAD1.1 WAD2.1
WAD3.1 WAD4.1
WAMS.1 WAOP.1
WAPC.1 WAYR.1
ROL-LAST-PARENT-ID
Element: Last Parent Id
Numeric 9
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 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 WACP.1
WAD1.1 WAD2.1
WAD3.1 WAD4.1
WAMS.1 WAOP.1
WAPC.1 WAYR.1
ROL-GENERATIONS
Element: Generations
Numeric 2
...
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 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
WACP.1 WAD1.1
WAD2.1 WAD3.1
WAD4.1 WAMS.1
WAOP.1 WAPC.1
ROL-ASYMETRIC-OPT
Element: Asymetric Opt
Alpha 1
ROL-LAW-DIM-NAME
Element: Law Dim Name
Alpha 50 (Lower Case)
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.
HC10.1 IA02.1
IAAP.1
ROL-DIM-BUILD-DTE
Element: Dim Build Dte
Numeric 8 (yyyymmdd)
The Dimension Build Date field contains the most recent date that this dimension was updated in the outline. The date format used is YYYYMMDD.
IA150
ROL-DIM-BUILD-TME
Element: Dim Build Tme
Numeric 6 (hhmmss)
The Dimension Build Time field contains the most recent time that this dimension was updated in the outline. The time format used is HHMMSS.
IA150
ROL-DATABASE-SPACE
Element: Database Space
Alpha 25 (Lower Case)
IA00.6 IA02.1
IAAP.1
ROL-META-FILE-NAME
Element: Meta File Name
Alpha 50 (Lower Case)
IA02.1 IA15.4
IAAP.1
ROL-DIMENSION-TYPE
Element: Dimension Type
Alpha 1
The Dimension Type field specifies the dimension owner. Value values are: L = Lawson U = User
HC10.1 IAAP.1
ROL-SECURITY-ON
Element: Security On
Alpha 1
This field indicates whether the budget is securing individuals from access.
Y = Security is On
N = Security is Off
HC10.1 IAAP.1
ROL-PARAMS-EXIST
Element: Params Exist
Alpha 1

Y = Yes
N = No
ROL-TABLE-CHANGE
Element: Table Change
Alpha 1

Y = Yes
N = No
...
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 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
WACP.1 WAD1.1
WAD2.1 WAD3.1
WAD4.1 WAMS.1
ROL-DEFN-PROGRAM
Element: Defn Program
Alpha 5
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.
HC10.1 IA02.1
IA100 IAAP.1
ROL-META-PROGRAM
Element: Meta Program
Alpha 6
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.
HC10.1 IA02.1
IA100 IA15.4
IAAP.1
ROL-FACT-TABLE-OPT
Element: Fact Table Opt
Alpha 1
ROL-NBR-COLUMNS
Element: Nbr Columns
Numeric 3
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 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 WACP.1
WAD1.1 WAD2.1
WAD3.1 WAD4.1
WAMS.1 WAOP.1
WAPC.1 WAYR.1
ROL-CREATED-GEN
Element: Created Gen
Alpha 1

Y = Yes
N = No
" " = No
HC10.1 IA02.1
IA150 IAAP.1
IANM.1
ROL-TABLE-FORMAT
Element: Table Format
Alpha 1

L = Level Heirarchy
P = Parent/Child
HC10.1 IA02.1
IAAP.1
ROL-SORT-OPTION
Element: Sort Option
Alpha 1
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
HC10.1 IA02.1
IAAP.1
ROL-COLUMNS-KNOWN
Element: Columns Known
Alpha 1
This field is used to indicate wheter the Star Schema Columns for this dimension table are known yet.
Y = Yes
N = No
HC10.1 IA02.1
IAAP.1
ROL-DIMENSION-CAT
Element: Dimension Cat
Alpha 1
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
HC10.1 IAAP.1
ROL-ALIAS-NAME
Element: Alias Name
Alpha 80 (Lower Case)
The Alias Name field contains an alias name for the dimension.
ROL-CHG-TO-MEASURE
Element: Chg To Measure
Alpha 1
HC10.1 IAAP.1


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 WADL.1
WAOP.1
ROLSET3 LAW-DIM-NAME
USER-DIM-NAME
KeyChange
IA00.1
ROLSET4 LAW-DIM-NAME
DIM-OBJ-ID
KeyChange
IADM.1
ROLSET5 DATABASE-SPACE
USER-DIM-NAME
KeyChange
IA00.1 IA00.6


ROLAPDIM FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Iadimtypes IADIMTYPES Required
ROL-LAW-DIM-NAME->IDT-LAW-DIM-NAME


ROLAPDIM FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 11:16:30 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.