Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

DIMDATAREL


                            DIMDATAREL FILE

                         Dimension Data Source

The Dimension Data Source Relationship (DIMDATAREL) file contains the member
name that is used for the specified dimension and data source. This member
name is independent of the data source. The information in this file comes
from IA14.1 (Dimension Member Overrides).

REFERENCED BY

IAFM.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

DDR-DATA-MART-NAME     Alpha 20  (Lower Case)
Element: Data Mart Name

DDR-USER-DIM-NAME      Alpha 50  (Lower Case)
Element: 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.


DDR-DATA-LOAD-NAME     Alpha 12  (Lower Case)
Element: Data Load NameThe Data Source Name field contains the
                       unique name for the source containing
                       the data values you are loading. You can
                       define multiple data sources for a
                       single data mart. Examples of data
                       sources are programs or rules files.
                       This user-defined name can contain up to
                       12 characters of any kind.

DDR-MEMBER-NAME        Alpha 50  (Lower Case)
Element: Member Name   This is an override member name for
                       Data Mart dimensions with no association
                       to a Budget dimension.

DDR-META-ID            Numeric 9
Element: Meta Id

                         DIMDATAREL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

DDRSET1   DATA-MART-NAMEKeyChange
          USER-DIM-NAME
          DATA-LOAD-NAME

DDRSET2   DATA-MART-NAMEKeyChange                                IAFM.1
          DATA-LOAD-NAME
          USER-DIM-NAME