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 |
| 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. |
|
||||||
| 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. |
|
||||||
| ROL-LAST-META-ID Element: Last Meta Id | Numeric 9 |
|||||||
| ROL-LAST-PARENT-ID Element: Last Parent Id | Numeric 9 |
|||||||
| ROL-GENERATIONS Element: Generations | Numeric 2 |
|||||||
| 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. |
|
||||||
| 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. |
|
||||||
| 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. |
|
||||||
| ROL-DATABASE-SPACE Element: Database Space | Alpha 25 (Lower Case) |
|
||||||
| ROL-META-FILE-NAME Element: Meta File Name | Alpha 50 (Lower Case) |
|
||||||
| ROL-DIMENSION-TYPE Element: Dimension Type | Alpha 1 The Dimension Type field specifies the dimension owner. Value values are: L = Lawson U = User |
|
||||||
| 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 |
|
||||||
| ROL-PARAMS-EXIST Element: Params Exist | Alpha 1 Y = Yes N = No |
|
||||||
| ROL-TABLE-CHANGE Element: Table Change | Alpha 1 Y = Yes N = No |
|||||||
| 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. |
|
||||||
| 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. |
|
||||||
| ROL-FACT-TABLE-OPT Element: Fact Table Opt | Alpha 1 |
|
||||||
| ROL-NBR-COLUMNS Element: Nbr Columns | Numeric 3 |
|||||||
| ROL-CREATED-GEN Element: Created Gen | Alpha 1 Y = Yes N = No " " = No |
|
||||||
| ROL-TABLE-FORMAT Element: Table Format | Alpha 1 L = Level Heirarchy P = Parent/Child |
|
||||||
| 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 |
|
||||||
| 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 |
|
||||||
| 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 |
|
||||||
| 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 |
|
| NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ROLSET1 |
USER-DIM-NAME |
|
|||||||||||||||||||
| ROLSET2 |
DIM-OBJ-ID |
|
| ||||||||||||||||||
| ROLSET3 |
LAW-DIM-NAME USER-DIM-NAME |
|
| ||||||||||||||||||
| ROLSET4 |
LAW-DIM-NAME DIM-OBJ-ID |
|
| ||||||||||||||||||
| ROLSET5 |
DATABASE-SPACE USER-DIM-NAME |
|
| ||||||||||||||||||
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||
|---|---|---|---|---|---|
| Iadimtypes | IADIMTYPES |
Required
|
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||
|---|---|---|---|---|---|---|---|---|
| Iaattrib | IAATTRIB |
Delete Cascades
| ||||||
| Olapdim | OLAPDIM |
| ||||||
| Rolapids | ROLAPIDS |
|
All trademarks and registered trademarks are the property of their
respective owners.