|
|
OLAPDBM FILE
Data Mart Manager
The Data Mart Manager (OLAPDBM) file stores information about each data mart
that has been defined by IA10.1 (Data Mart Manager) program.
UPDATED BY
AC87.1 CXA1.1 HC01.1 HC02.1 GL87.1 GL88.1
POA1.1 SAA1.1 WOA1.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ODB-APPLIC-NAME Alpha 8 (Lower Case)
Application Name The Application Name is the name of the
application that describes the database
names it contains. This user-defined
name can contain up to eight characters.
The first letter of the name must be
capitalized.
ODB-DATABASE-NAME Alpha 8 (Lower Case)
Database Name The Database Name is the name of the
database that is stored within the OLAP
application. Each application may
contain more than one database. This
user-defined name can contain up to
eight characters. The first letter of
the name must be capitalized.
ODB-DESCRIPTION Alpha 30 (Lower Case)
Description The Description field contains a
description of the data mart.
ODB-APPLIC-TYPE Alpha 3
Data Mart Type The Application Type file stores the
names of the Lawson applications that
can be requested to supply information
to the OLAP database. The Lawson
applications that are currently
OLAP-ready are:
FIN = Financial Analyzer
FND = Daily Financial Analyzer
SA = Sales Analyzer
CX = Case Cart Analyzer
PO = Purchasing Analyzer
WO = Work Order Analyzer
ODB-SERVER-NAME Alpha 40 (Lower Case)
Server Name The Server Name field contains the IP
address of the server to which you are
connecting. You can also specify a name
that has been associated with the server
(DNS name).
ODB-DIM-BUILD-DTE Numeric 8 (yyyymmdd)
Dimension Build Date The Dimension Build Date field contains
the most recent date that this dimension
was updated in the outline. The date
format used is YYYYMMDD.
ODB-DIM-BUILD-TME Numeric 6 (hhmmss)
Dimension Build Time The Dimension Build Time field contains
the most recent time that this dimension
was updated in the outline. The time
format used is HHMMSS.
ODB-DATA-BUILD-DTE Numeric 8 (yyyymmdd)
Data Load Date The Data Load Date field contains the
most recent date that the OLAP data mart
was populated with data values. The date
format used is YYYYMMDD.
ODB-DATA-BUILD-TME Numeric 6 (hhmmss)
Data Load Time The Data Load Time field contains the
most recent time that the OLAP data mart
was populated with data values. The time
format used is HHMMSS.
ODB-REQ-DIM-REBLD Alpha 1 AC87.1 CXA1.1
Required Dimension The value in the Required Dimension GL87.1 GL88.1
Rebuild Rebuild field is set by the system. The HC01.1 HC02.1
value is based on whether changes that POA1.1 SAA1.1
require the dimensions to be rebuilt WOA1.1
have been made to the data mart.
Valid values are:
Y = Yes
N = No; Default value.
ODB-REQ-DATA-REBLD Alpha 1 AC87.1 CXA1.1
Required Data Reload The Required Data Reload field is set GL87.1 GL88.1
by the system. The setting is based on HC01.1 HC02.1
whether changes that require the data POA1.1 SAA1.1
values to be reloaded have been made to WOA1.1
the data mart.
Valid values are:
Y = Yes
N = No; Default value.
ODB-LOCK-OPTION Alpha 1
Lock Option The Lock Option field provides
additional security by preventing
changes to the data mart definition,
even if the user tries to initiate an
outline build or a data load. The
operation of this field depends on the
user's security privileges.
Value values are:
Y = Yes
N = No; Default value.
ODB-PROCESSING Alpha 1
Processing The Processing field shows the current
status of the data mart. It provides a
locking mechanism to prevent updates
when data is being loaded to the data
mart.
Value values are:
~ = No data is being processed
M = Outline build in process
D = Data load in process
C = Data mart calculation in process
" " = Not Processing
ODB-AUTO-REBUILD Alpha 1
Auto Rebuild The Auto Rebuild field determines
whether the data mart should be rebuilt
if dimensions or data values have
changed. If an incremental data load is
requested, this field uses the values in
the Required Dimension Rebuild and
Required Data Reload fields to determine
if the data mart should be reloaded. Set
this field to Y if all data for a
complete load is still available.
Valid values are:
Y = Yes
N = N; Default value.
ODB-ERROR-LOG-NBR Numeric 3
Error Log Number The Error Log Number field displays the
error message number found during the
outline build or data mart load.
ODB-LAST-DIM-SEQ Numeric 4 AC87.1 CXA1.1
Last Dimension The Last Dimension Sequence Number GL87.1 GL88.1
Sequence Number field contains the sequence number of HC01.1 HC02.1
the last dimension in the outline. The POA1.1 SAA1.1
number in this field determines the WOA1.1
number of the next dimension that is
added to the outline.
ODB-NON-LAW-MEMBER Alpha 1
Outline Changes The Outline Changes Exist field
Exist determines whether the user has added
members to the outline using the Essbase
Application Manager. If Y (Yes) is
specified, a new outline is created and
compared with the existing outline. The
two outlines are merged before the data
is loaded using IA120 (Data Mart Load).
This field applies to complete outline
builds and data loads only.
Valid values are:
Y = Yes
N = No; Default value.
ODB-STAGE-APP-NAME Alpha 8 (Lower Case)
Staging Application The Stage Application Name field
Name contains the name of the application
that is temporarily created when the
data mart staging option is set. Staging
a data mart lets users work with the
data mart while data is being loaded.
This name can contain up to 8 characters
of any kind.
ODB-ADDT-SOURCES Alpha 1
External Data The External Data Sources Exists field
Sources Exist determines whether external data sources
are used to update the data mart. A
value of Y (Yes) in this field indicates
that external data sources exist,
thereby preventing the administrator
from clearing the data mart prior to
updating it.
Valid values are:
Y = Yes. External data sources exist.
N = No; Default value.
ODB-ARBOR-PATH Alpha 100 (Lower Case)
Arbor Path The Arbor Path field contains the name
of the directory where all CSV output
files are stored.
OLAPDBM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ODBSET1 APPLIC-NAME AC87.1 CXA1.1
DATABASE-NAME HC01.1 HC02.1
GL87.1 GL88.1
POA1.1 SAA1.1
WOA1.1
ODBSET2 APPLIC-TYPE KeyChange
APPLIC-NAME
DATABASE-NAME
OLAPDBM FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Applictype APPLICTYPE Required
ODB-APPLIC-TYPE -> IAA-APPLIC-TYPE (IAASET1)
OLAPDBM FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Dimdatarel DIMDATAREL
ODB-APPLIC-NAME -> DDR-APPLIC-NAME
ODB-DATABASE-NAME -> DDR-DATABASE-NAME
DDR-USER-DIM-NAME
DDR-DATA-LOAD-NAME
Member MEMBER
ODB-APPLIC-NAME -> MBR-APPLIC-NAME
ODB-DATABASE-NAME -> MBR-DATABASE-NAME
MBR-MEMBER-NAME
Olapdim OLAPDIM
ODB-APPLIC-NAME -> OLD-APPLIC-NAME
ODB-DATABASE-NAME -> OLD-DATABASE-NAME
OLD-USER-DIM-NAME
Olapdim 3 OLAPDIM
ODB-APPLIC-NAME -> OLD-APPLIC-NAME
ODB-DATABASE-NAME -> OLD-DATABASE-NAME
OLD-SEQUENCE-NBR
OLD-USER-DIM-NAME
|