Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OLAPDIM


                              OLAPDIM FILE

                          Data Mart Dimensions

The Data Mart Dimensions (OLAPDIM) file stores the dimension settings for
each data mart. The information in this file comes from IA15.1 (Dimension
Settings).

REFERENCED BY

ACDL.1    AMDL.1    HCOP.1    HCOP.2    GLOP.1    POA3.1
WODL.1    IADE.1

UPDATED BY

IAAP.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

OLD-DATA-MART-NAME     Alpha 20  (Lower Case)                    IAAP.1
Element: Data Mart Name

OLD-USER-DIM-NAME      Alpha 50  (Lower Case)                    IAAP.1
Element: User DimensionThe 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.


OLD-LAW-DIM-NAME       Alpha 50  (Lower Case)                    IAAP.1
Lawson Dimension       The Lawson Dimension Name is the name
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.

OLD-SEQUENCE-NBR       Numeric 4                                 IAAP.1
Element: Sequence Number

OLD-ALIAS-NAME         Alpha 80  (Lower Case)                    IAAP.1
Element: Alias Name    The Alias Name field contains an alias
                       name for the dimension.

OLD-DIMENSION-TYPE     Alpha 1                                   IAAP.1
Element: Dimension TypeThe Dimension Type field specifies the
                       dimension owner.

                       Value values are:
                       L = Lawson
                       U = User

OLD-DIMENSION-CAT      Alpha 1                                   IAAP.1
Element: Dimension CateThe 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
                       " "
                       X = Attribute

OLD-DENSITY-VALUE      Alpha 1                                   IAAP.1
Element: Density Value The Density Value field specifies
                       whether the data in the dimension is
                       dense or sparse. In a dense data mart, a
                       relatively high percentage of the
                       possible combinations (intersections) of
                       all dimension members contain data
                       values. In a sparse dimension, a higher
                       percentage of the intersections have
                       missing data.

                       Valid values are:
                       D = Dense; Default value.
                       S = Sparse

OLD-PROTECT-REBLD      Alpha 1                                   IAAP.1
Element: Static DimensiThe Static Dimension field lets you
                       prevent this dimension from being
                       rebuilt when the rest of the outline is
                       rebuilt. You can use this feature on
                       static dimensions where members are not
                       added, moved, or deleted on a regular
                       basis.

                       Valid values are:
                       Y = Yes
                       No = No; Default value.

OLD-DIM-BUILD-DTE      Numeric 8  (yyyymmdd)
Element: Dimension BuilThe Dimension Build Date field contains
                       the most recent date that this dimension
                       was updated in the outline. The date
                       format used is YYYYMMDD.

OLD-DIM-BUILD-TME      Numeric 6  (hhmmss)
Element: Dimension BuilThe Dimension Build Time field contains
                       the most recent time that this dimension
                       was updated in the outline. The time
                       format used is HHMMSS.

OLD-OLD-DIM-NAME       Alpha 50  (Lower Case)
Previous Dimension     The Previous Dimension Name field
Name                   contains the previous user dimension
                       name if the name was changed.

OLD-MODIFY-ALLOW       Alpha 1                                   IAAP.1
Element: Allow ModificaThe Allow Modifications field
                       determines whether modifications are
                       allowed to the Dimension Category or
                       Density Value fields. Changes to the
                       Density Value field may cause data mart
                       size and performance issues. Changes to
                       the Dimension Category will require the
                       outline to be rebuilt.

                       Valid values are:
                       Y = Yes; Default value.
                       No = No

OLD-NUMBER-OF-MBRS     Numeric 7
Element: Number of MembThe Number of Member field contains the
                       actual number of members for the
                       dimension in the outline.

OLD-DIM-OBJ-ID         Numeric 12                                IAAP.1
Dimension Object       The Dimension Object Identifier field
Identifier             contains a unique numeric identifier
                       assigned to the dimension, which
                       associates this record to the member
                       records.

OLD-META-PROGRAM       Alpha 6                                   IAAP.1
Dimension Build        The Outline Build Program field
Program                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.

OLD-META-FORMAT        Alpha 1                                   IAAP.1
Dimension Build        The Dimension Build Source file
Source                 contains the value that represents the
                       source for the dimension outline.

                       Valid values are:
                       1 = Program; Default value.
                       2 = Rules File
                       3 = Manual
                       4 = Rules File with SQL Connection

OLD-META-FILE-PATH     Alpha 100  (Lower Case)                   IAAP.1
Element: Path and File The Path and File Name field contains
                       name of the text file that contains the
                       data mart outline (description of the
                       data) for the dimension. If a dimension
                       build program is not specified, a text
                       file and a rules file are required. The
                       text file contains the outline and the
                       rules file contains the outline build
                       rules.

OLD-RULES-FILE         Alpha 100  (Lower Case)                   IAAP.1
Element: Rules File    The Rules File field contains file name
                       of the rules file to be used by the data
                       mart. If a rules file is used, the data
                       source is the file specified in the Data
                       Source File field. The rules file is
                       responsible for loading the data source
                       file into the data mart. Both the rules
                       file and the data source file must be
                       placed in the $ARBORPATH/app/application
                       name/database path before using IA120
                       (Data Mart Load).

OLD-IA-OUTLINE-IND     Alpha 1                                   IAAP.1
Element: Retain Member The Retain Member list field specifies
                       the value that determines whether a list
                       of members is retained in the Analytic
                       Architect system when the data mart is
                       created. This list of member names is
                       used during the operand mapping process
                       for the Performance Indicator suite.
                       M = Member
                       A = Member & Alias
                       N = No

OLD-UPDATE-STYLE       Alpha 1                                   IAAP.1
Element: Update Style  1 = Refresh
                       2 = Changes & Deletes
                       3 = Changes Only
                       4 = No Update

OLD-MBR-LIST-OPT       Alpha 1                                   IAAP.1
Element: Mbr List Opt  Y = Yes
                       N = No

OLD-ALIAS-NAME-OPT     Alpha 1                                   IAAP.1
Element: Alias Name OptY = Yes
                       N = No

                         OLAPDIM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

OLDSET1   DATA-MART-NAMEKeyChange                                ACDL.1  AMDL.1
          USER-DIM-NAME                                          HCOP.1  HCOP.2
                                                                 IAAP.1  GLOP.1
                                                                 POA3.1  WODL.1

OLDSET2   DATA-MART-NAMEKeyChange                                IAAP.1
          LAW-DIM-NAME
          USER-DIM-NAME

OLDSET3   DATA-MART-NAMEKeyChange, Subset                        ACDL.1  AMDL.1
          SEQUENCE-NBR  Where DIMENSION-CAT != "X"               HCOP.1  HCOP.2
          USER-DIM-NAME                                          GLOP.1  POA3.1
                                                                 WODL.1

OLDSET4   DATA-MART-NAMEKeyChangeDuplicates
          DIM-OBJ-ID

OLDSET5   DIM-OBJ-ID                                             IAAP.1  IADE.1
          DATA-MART-NAME

                         OLAPDIM FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Olapdbm        OLAPDBM      Required

                            OLD-DATA-MART-NAME    -> ODB-DATA-MART-NAME

                         OLAPDIM FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Dimdatarel     DIMDATAREL

                            OLD-DATA-MART-NAME    -> DDR-DATA-MART-NAME
                            OLD-USER-DIM-NAME     -> DDR-USER-DIM-NAME
                                                     DDR-DATA-LOAD-NAME

Member         MEMBER

                            OLD-DATA-MART-NAME    -> MBR-DATA-MART-NAME
                            OLD-DIM-OBJ-ID        -> MBR-DIM-OBJ-ID
                                                     MBR-MEMBER-NAME
                                                     MBR-OBJ-ID