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.
REFERENCED BY
HC01.1 HC02.1 IA04.1 IA04.2 IA08.1 IA115
IA12.1 IA12.2 IA12.3 IA13.1 IA14.1 IA16.1
IA200 IA300 IADE.1 IAMB.1 IAMD.1 IAMR.1
IAPF.1 IASD.1 IA01.1 IA01.3 IA00.1 IA00.6
UPDATED BY
ACDL.1 AMDL.1 HCOP.1 HCOP.2 IA05.1 IA05.3
IA10.1 IA10.2 IA11.2 IA120 IA15.1 IA15.4
IA150 IA20.1 IAAP.1 IANM.1 IASV.1 IASV.2
GLOP.1 POA3.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ODB-DATA-MART-NAME Alpha 20 (Lower Case) IA10.1 IASV.1
Data Mart Name
ODB-DESCRIPTION Alpha 30 (Lower Case) IA10.1 IASV.1
Description The Description field contains a
description of the data mart.
ODB-APPLIC-TYPE Alpha 3 IA10.1 IASV.1
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) IA10.2 IA120
Dimension Build Date The Dimension Build Date field contains IASV.2
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) IA10.2 IA120
Dimension Build Time The Dimension Build Time field contains IASV.2
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) IA10.2 IA120
Data Load Date The Data Load Date field contains the IA150 IASV.2
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) IA10.2 IA120
Data Load Time The Data Load Time field contains the IA150 IASV.2
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 IA10.1 IA120
Required Dimension The value in the Required Dimension IA15.1 IAAP.1
Rebuild Rebuild field is set by the system. The
value is based on whether changes that
require the dimensions to be rebuilt
have been made to the data mart.
Valid values are:
Y = Yes
N = No; Default value.
ODB-REQ-DATA-REBLD Alpha 1 IA10.1 IA120
Required Data Reload The Required Data Reload field is set IA150 IAAP.1
by the system. The setting is based on
whether changes that require the data
values to be reloaded have been made to
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 IA05.1 IA05.3
Processing The Processing field shows the current IA120 IA150
status of the data mart. It provides a IASV.1
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 IA15.1 IAAP.1
Last Dimension The Last Dimension Sequence Number
Sequence Number field contains the sequence number of
the last dimension in the outline. The
number in this field determines the
number of the next dimension that is
added to the outline.
ODB-STAGE-APP-NAME Alpha 8 (Lower Case) IA11.2
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 IA05.1 IA10.1
External Data The External Data Sources Exists field IASV.1
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-DATA-TARGET Alpha 1 IA10.1
Data Target 1 = Hyperion Essbase Server
2 = Star Schema Format
ODB-ARBOR-PATH Alpha 100 (Lower Case) IA05.1 IA10.1
Arbor Path The Arbor Path field contains the name IASV.1
of the directory where all CSV output
files are stored.
ODB-DTA-DRILL-PATH Alpha 100 (Lower Case)
Dta Drill Path
ODB-APPLIC-NAME Alpha 8 (Lower Case) IA05.1 IA10.1
Application Name The Application Name is the name of the IASV.1
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) IA05.1 IA10.1
Database Name The Database Name is the name of the IASV.1
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-ACTIVE-STATUS Alpha 1 IA10.1
Status The status of the account. If Inactive,
no posting can be done to the account.
A = Active
I = Inactive
ODB-SECURITY-ON Alpha 1 IA10.1 IA20.1
Security On This field indicates whether the budget
is securing individuals from access.
Y = Yes
N = No
ODB-MART-CREATOR Alpha 20 (Lower Case) IA10.1
Mart Creator
ODB-DATABASE-SPACE Alpha 25 (Lower Case) IA10.1 IASV.1
Database Space
ODB-CREATED-GEN Alpha 1 IA10.1 IA150
Created Gen Y = Yes IANM.1
N = No
" " = No
ODB-TABLE-CHANGE Alpha 1 ACDL.1 AMDL.1
Table Change GLOP.1 HCOP.1
HCOP.2 IA10.1
IANM.1 POA3.1
ODB-FACT-TBL-NAME Alpha 50 (Lower Case)
Fact Tbl Name
ODB-NBR-COLUMNS Numeric 3 ACDL.1 AMDL.1
Nbr Columns GLOP.1 HCOP.1
HCOP.2 POA3.1
ODB-OLAP-TYPE Alpha 1
Olap Type X = XML OUTPUT
C = CSV OUTPUT
ODB-DRILL-ENABLED Alpha 1 IA05.1 IA10.1
Drill Enabled This field indicates whether drill
around functionality should be enabled
for this data mart.
Y = Yes
N = No
ODB-SERVICE-OPTION Alpha 1 IASV.1
Service Option This flag determines whether the data
mart will be built by an internal
server or a service provider.
Y = Yes
N = No
ODB-CONVERTED Alpha 1 IA120
Converted " " = Requires Conversion
N = Does Not Require Conversion
ODB-OLAP-STORAGE Alpha 1 IA05.3 IA10.1
Olap Storage This determines the data storage that
will be utilized for the data mart cube.
The options are Molap
(multidimensional), Rolap (relational),
or Holap (hybrid of relational and
multidimensional).
M = Molap
R = Rolap
H = Holap
ODB-OLAP-AGGR-OPT Alpha 1 IA05.3 IA10.1
Olap Aggr Opt Olap aggregation option: perform
aggregations until the OLAP-AGG-LIMIT is
hit.
S = Storage
P = Performance
ODB-OLAP-AGGR-LIMT Alpha 10 IA05.3 IA10.1
Olap Aggr Limt Olap aggregation limit: max storage size
or performance percentage in which to
perform aggregations. This field and the
OLAP-AGGR-OPT are concatenated together
to describe how aggregation should
function.
ODB-OBJ-ID-PREFIX Numeric 3
Obj Id Prefix
ODB-OBJ-ID-SUFFIX Numeric 9
Obj Id Suffix
ODB-ENABLE-XML Alpha 1
Enable Xml " " = Destination Default
A = XML Output Active
X = XML Output Only
OLAPDBM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ODBSET1 DATA-MART-NAME ACDL.1 AMDL.1
HC01.1 HC02.1
HCOP.1 HCOP.2
IA04.1 IA04.2
IA05.1 IA05.2
IA05.3 IA08.1
IA10.1 IA10.2
IA11.1 IA11.2
IA11.3 IA115
IA12.1 IA12.2
IA12.3 IA120
IA13.1 IA14.1
IA15.1 IA15.4
IA150 IA16.1
IA20.1 IA20.2
...
ODBSET2 APPLIC-TYPE KeyChange IA01.1 IA01.3
DATA-MART-NAME IASV.1
ODBSET3 APPLIC-NAME KeyChange IA10.1 IASD.1
DATABASE-NAME IASV.1
DATA-MART-NAME
ODBSET4 DATABASE-SPACEKeyChange IA00.1 IA00.6
DATA-MART-NAME
ODBSET5 DATABASE-SPACEKeyChange
FACT-TBL-NAME
DATA-MART-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)
Rolapdbs ROLAPDBS Not Required
ODB-DATABASE-SPACE -> DBS-DATABASE-SPACE
OLAPDBM FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Aliastable ALIASTABLE
ODB-DATA-MART-NAME -> ALI-DATA-MART-NAME
ALI-ALIAS-TABLE
Datasource DATASOURCE
ODB-DATA-MART-NAME -> DAT-DATA-MART-NAME
DAT-DATA-LOAD-NAME
Dimdatarel DIMDATAREL
ODB-DATA-MART-NAME -> DDR-DATA-MART-NAME
DDR-USER-DIM-NAME
DDR-DATA-LOAD-NAME
Member MEMBER
ODB-DATA-MART-NAME -> MBR-DATA-MART-NAME
MBR-MEMBER-NAME
Olapdim OLAPDIM
ODB-DATA-MART-NAME -> OLD-DATA-MART-NAME
OLD-USER-DIM-NAME
Olapdim 3 OLAPDIM
ODB-DATA-MART-NAME -> OLD-DATA-MART-NAME
OLD-SEQUENCE-NBR
OLD-USER-DIM-NAME
Olapprof OLAPPROF
ODB-DATA-MART-NAME -> OLP-DATA-MART-NAME
OLP-PROFILE-NAME
Olapuda OLAPUDA
ODB-DATA-MART-NAME -> UDA-DATA-MART-NAME
UDA-UDA-NAME
Profdatrel PROFDATREL
ODB-DATA-MART-NAME -> PFL-DATA-MART-NAME
PFL-PROFILE-NAME
PFL-DATA-LOAD-NAME
|
