|
|
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
ACBA.1 ACBC.1 ACBP.1 ACBR.1 ACBS.1 ACBU.1
ACBY.1 AMAS.1 AMBK.1 AMCV.1 AMLF.1 AMMD.1
AMME.1 AMPD.1 AMYR.1 HC01.1 HC02.1 HCAC.1
HCAG.1 HCCL.1 HCCP.1 HCEC.1 HCEM.1 HCEO.1
HCEX.1 HCGL.1 HCGN.1 HCJC.1 HCLO.1 HCMS.1
HCMS.2 HCPL.1 HCPO.1 HCRV.1 HCSC.1 HCSH.1
HCST.1 HCSU.1 HCTM.1 HCUF.1 HCUL.1 HCUN.1
HCYR.1 IADE.1 GLBA.1 GLBD.1 GLBP.1 GLBT.1
GLBY.1 IFBA.1 IFBC.1 IFBO.1 IFBS.1 IFEO.1
POAB.1 POAM.1 POAO.1 POAP.1 POAV.1 WOME.1
WOOR.1 WOPR.1 WOSC.1
UPDATED BY
ACDL.1 AMDL.1 HCOP.1 HCOP.2 IAAP.1 GLOP.1
POA3.1 WODL.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ODB-DATA-MART-NAME Alpha 20 (Lower Case)
Element: Data Mart Name
ODB-DESCRIPTION Alpha 30 (Lower Case)
Element: 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)
Element: 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)
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.
ODB-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.
ODB-DATA-BUILD-DTE Numeric 8 (yyyymmdd)
Element: Data Load DateThe 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)
Element: Data Load TimeThe 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 IAAP.1
Required Dimension The value in the Required Dimension
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 IAAP.1
Element: Required Data The Required Data Reload field is set
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
Element: 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
Element: 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
L = Process Lawson Data
A = Process MSOLAP
F = FTP Data
ODB-AUTO-REBUILD Alpha 1
Element: 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
Element: Error Log NumbThe Error Log Number field displays the
error message number found during the
outline build or data mart load.
ODB-LAST-DIM-SEQ Numeric 4 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)
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-DATA-TARGET Alpha 1
Element: Data Target 1 = Hyperion Essbase Server
2 = Star Schema Format
ODB-ARBOR-PATH Alpha 100 (Lower Case)
Element: Arbor Path The Arbor Path field contains the name
of the directory where all CSV output
files are stored.
ODB-DTA-DRILL-PATH Alpha 100 (Lower Case)
Element: Dta Drill Path
ODB-APPLIC-NAME Alpha 8 (Lower Case)
Element: Application NaThe 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)
Element: 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-ACTIVE-STATUS Alpha 1
Element: 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
Element: Security On This field indicates whether the budget
is securing individuals from access.
Y = Yes
N = No
ODB-MART-CREATOR Alpha 20 (Lower Case)
Element: Mart Creator
ODB-DATABASE-SPACE Alpha 25 (Lower Case)
Element: Database Space
ODB-CREATED-GEN Alpha 1
Element: Created Gen Y = Yes
N = No
" " = No
ODB-TABLE-CHANGE Alpha 1 ACDL.1 AMDL.1
Element: Table Change GLOP.1 HCOP.1
HCOP.2 POA3.1
WODL.1
ODB-FACT-TBL-NAME Alpha 50 (Lower Case)
Element: Fact Tbl Name
ODB-NBR-COLUMNS Numeric 3 ACDL.1 AMDL.1
Element: Nbr Columns GLOP.1 HCOP.1
HCOP.2 POA3.1
WODL.1
ODB-OLAP-TYPE Alpha 1
Element: Olap Type X = XML OUTPUT
C = CSV OUTPUT
ODB-DRILL-ENABLED Alpha 1
Element: 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
Element: Service OptionThis 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
Element: Converted " " = Requires Conversion
N = Does Not Require Conversion
ODB-OLAP-STORAGE Alpha 1
Element: 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
Element: 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
Element: Olap Aggr LimtOlap 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
Element: Obj Id Prefix
ODB-OBJ-ID-SUFFIX Numeric 9
Element: Obj Id Suffix
ODB-ENABLE-XML Alpha 1
Element: Enable Xml " " = Destination Default
A = XML Output Active
X = XML Output Only
ODB-NUMERIC-ID Numeric 3
Element: Numeric Id
OLAPDBM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ODBSET1 DATA-MART-NAME ACBA.1 ACBC.1
ACBP.1 ACBR.1
ACBS.1 ACBU.1
ACBY.1 ACDL.1
AMAS.1 AMBK.1
AMCV.1 AMDL.1
AMLF.1 AMMD.1
AMME.1 AMPD.1
AMYR.1 HC01.1
HC02.1 HCAC.1
HCAG.1 HCCL.1
HCCP.1 HCEC.1
HCEM.1 HCEO.1
HCEX.1 HCGL.1
HCGN.1 HCJC.1
...
ODBSET2 APPLIC-TYPE KeyChange
DATA-MART-NAME
ODBSET3 APPLIC-NAME KeyChange
DATABASE-NAME
DATA-MART-NAME
ODBSET4 DATABASE-SPACEKeyChange
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
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
|
