OLAPDBM – Data Mart Manager

System
Analytic Architect (IA)
Prefix
ODB
Primary key
DATA-MART-NAME
Fields
41
Updated by
22 programs
Referenced by
75 programs

OLAPDBM is the Data Mart Manager table in Lawson Analytic Architect (prefix ODB). It is indexed by DATA-MART-NAME (ODBSET1); alternate indexes: ODBSET2, ODBSET3, ODBSET4 and ODBSET5. It is related 1:1 to APPLICTYPE and ROLAPDBS and 1:M to ALIASTABLE, DATASOURCE, DIMDATAREL, MEMBER, OLAPDIM, OLAPPROF, OLAPUDA and PROFDATREL. It is updated by ACDL.1, AMDL.1, CBOP.1, GLOP.1, HC10.1, HCDL.1, HCHP.1, IA05.1 and 14 more and referenced by ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 and 67 more. The table has 41 fields, 5 indexes and 11 documented relations.

About OLAPDBM

The Data Mart Manager (OLAPDBM) file stores information about each data mart that has been defined by IA10.1 (Data Mart Manager) program.

Fields (41)

Column = COBOL field name without the ODB- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
ODB-DATA-MART-NAME PK
DATA_MART_NAME		Alpha 20 (Lower Case)This field contains the name of the data mart.IA10.1, IASV.1
ODB-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)The Description field contains a description of the data mart.IA10.1, IASV.1
ODB-APPLIC-TYPE
APPLIC_TYPE		Alpha 3The 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
IA10.1, IASV.1
ODB-SERVER-NAME
SERVER_NAME		Alpha 40 (Lower Case)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
DIM_BUILD_DTE		Numeric 8 (yyyymmdd)The Dimension Build Date field contains the most recent date that this dimension was updated in the outline. The date format used is YYYYMMDD.IA10.2, IA120, IASV.2
ODB-DIM-BUILD-TME
DIM_BUILD_TME		Numeric 6 (hhmmss)The Dimension Build Time field contains the most recent time that this dimension was updated in the outline. The time format used is HHMMSS.IA10.2, IA120, IASV.2
ODB-DATA-BUILD-DTE
DATA_BUILD_DTE		Numeric 8 (yyyymmdd)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.IA10.2, IA120, IA150, IASV.2
ODB-DATA-BUILD-TME
DATA_BUILD_TME		Numeric 6 (hhmmss)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.IA10.2, IA120, IA150, IASV.2
ODB-REQ-DIM-REBLD
REQ_DIM_REBLD		Alpha 1The value in the Required Dimension 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.
IA10.1, IA120, IA15.1, IAAP.1
ODB-REQ-DATA-REBLD
REQ_DATA_REBLD		Alpha 1The 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.
IA10.1, IA120, IA150, IAAP.1
ODB-LOCK-OPTION
LOCK_OPTION		Alpha 1The 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
PROCESSING		Alpha 1The 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 " " = Not Processing
  • M Outline build in process
  • D Data load in process
  • C Data mart calculation in process
  • L Process Lawson Data
  • A Process MSOLAP
  • F FTP Data
IA05.1, IA05.3, IA120, IA150, IASV.1
ODB-AUTO-REBUILD
AUTO_REBUILD		Alpha 1The 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
ERROR_LOG_NBR		Numeric 3The Error Log Number field displays the error message number found during the outline build or data mart load.—
ODB-LAST-DIM-SEQ
LAST_DIM_SEQ		Numeric 4The Last Dimension 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.IA15.1, IAAP.1
ODB-STAGE-APP-NAME
STAGE_APP_NAME		Alpha 8 (Lower Case)The Stage Application Name field 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.IA11.2
ODB-ADDT-SOURCES
ADDT_SOURCES		Alpha 1The External Data Sources Exists field 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.
IA05.1, IA10.1, IASV.1
ODB-DATA-TARGET
DATA_TARGET		Alpha 1—
  • 1 Hyperion Essbase Server
  • 2 Star Schema Format
IA10.1, IASV.1
ODB-ARBOR-PATH
ARBOR_PATH		Alpha 100 (Lower Case)The Arbor Path field contains the name of the directory where all CSV output files are stored.IA05.1, IA120, IASV.1
ODB-DTA-DRILL-PATH
DTA_DRILL_PATH		Alpha 100 (Lower Case)——
ODB-APPLIC-NAME
APPLIC_NAME		Alpha 8 (Lower Case)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.IA05.1, IA10.1, IASV.1
ODB-DATABASE-NAME
DATABASE_NAME		Alpha 8 (Lower Case)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.IA05.1, IA10.1, IASV.1
ODB-ACTIVE-STATUS
ACTIVE_STATUS		Alpha 1The status of the account. If Inactive, no posting can be done to the account.
  • A Active
  • I Inactive
IA10.1
ODB-SECURITY-ON
SECURITY_ON		Alpha 1This field indicates whether the budget is securing individuals from access.
  • Y Yes
  • N No
IA10.1, IA20.1
ODB-MART-CREATOR
MART_CREATOR		Alpha 20 (Lower Case)—IA10.1
ODB-DATABASE-SPACE
DATABASE_SPACE		Alpha 25 (Lower Case)—IA10.1, IASV.1
ODB-CREATED-GEN
CREATED_GEN		Alpha 1" " = No
  • Y Yes
  • N No
IA10.1, IA150, IANM.1
ODB-TABLE-CHANGE
TABLE_CHANGE		Alpha 1—ACDL.1, AMDL.1, CBOP.1, GLOP.1, HCDL.1, HCHP.1, IA10.1, IA150 +2 more
ODB-FACT-TBL-NAME
FACT_TBL_NAME		Alpha 50 (Lower Case)——
ODB-NBR-COLUMNS
NBR_COLUMNS		Numeric 3—ACDL.1, AMDL.1, CBOP.1, GLOP.1, HCDL.1, HCHP.1, IA150, POA3.1
ODB-OLAP-TYPE
OLAP_TYPE		Alpha 1—
  • X XML OUTPUT
  • C CSV OUTPUT
—
ODB-DRILL-ENABLED
DRILL_ENABLED		Alpha 1This field indicates whether drill around functionality should be enabled for this data mart.
  • Y Yes
  • N No
IA05.1, IA10.1
ODB-SERVICE-OPTION
SERVICE_OPTION		Alpha 1This flag determines whether the data mart will be built by an internal server or a service provider.
  • Y Yes
  • N No
IASV.1
ODB-CONVERTED
CONVERTED		Alpha 1" " = Requires Conversion
  • N Does Not Require Conversion
HC10.1, IA120
ODB-OLAP-STORAGE
OLAP_STORAGE		Alpha 1This 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
IA05.3, IA10.1
ODB-OLAP-AGGR-OPT
OLAP_AGGR_OPT		Alpha 1Olap aggregation option: perform aggregations until the OLAP-AGG-LIMIT is hit.
  • S Storage
  • P Performance
IA05.3, IA10.1
ODB-OLAP-AGGR-LIMT
OLAP_AGGR_LIMT		Alpha 10Olap 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.IA05.3, IA10.1
ODB-OBJ-ID-PREFIX
OBJ_ID_PREFIX		Numeric 3——
ODB-OBJ-ID-SUFFIX
OBJ_ID_SUFFIX		Numeric 9——
ODB-ENABLE-XML
ENABLE_XML		Alpha 1" " = Destination Default
  • A XML Output Active
  • X XML Output Only
—
ODB-NUMERIC-ID
NUMERIC_ID		Numeric 3—IA10.1, IASV.1

Indexes (5)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ODBSET1DATA-MART-NAMEPrimaryACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, ACDL.1 +22 more (list truncated in source)
ODBSET2APPLIC-TYPE, DATA-MART-NAMEKeyChangeIA01.1, IA01.3, IASV.1
ODBSET3APPLIC-NAME, DATABASE-NAME, DATA-MART-NAMEKeyChangeIA10.1, IASD.1, IASV.1
ODBSET4DATABASE-SPACE, DATA-MART-NAMEKeyChangeIA00.1, IA00.6
ODBSET5DATABASE-SPACE, FACT-TBL-NAME, DATA-MART-NAMEKeyChange—

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
ApplictypeAPPLICTYPERequiredODB-APPLIC-TYPE → IAA-APPLIC-TYPE (IAASET1)
RolapdbsROLAPDBSNot RequiredODB-DATABASE-SPACE → DBS-DATABASE-SPACE

One to many (9) — child tables

RelationTableRulesConditionField map
AliastableALIASTABLEODB-DATA-MART-NAME → ALI-DATA-MART-NAME, → ALI-ALIAS-TABLE
DatasourceDATASOURCEODB-DATA-MART-NAME → DAT-DATA-MART-NAME, → DAT-DATA-LOAD-NAME
DimdatarelDIMDATARELODB-DATA-MART-NAME → DDR-DATA-MART-NAME, → DDR-USER-DIM-NAME, → DDR-DATA-LOAD-NAME
MemberMEMBERODB-DATA-MART-NAME → MBR-DATA-MART-NAME, → MBR-MEMBER-NAME
OlapdimOLAPDIMODB-DATA-MART-NAME → OLD-DATA-MART-NAME, → OLD-USER-DIM-NAME
Olapdim 3OLAPDIMODB-DATA-MART-NAME → OLD-DATA-MART-NAME, → OLD-SEQUENCE-NBR, → OLD-USER-DIM-NAME
OlapprofOLAPPROFODB-DATA-MART-NAME → OLP-DATA-MART-NAME, → OLP-DATA-MART-GRP, → OLP-PROFILE-NAME
OlapudaOLAPUDAODB-DATA-MART-NAME → UDA-DATA-MART-NAME, → UDA-UDA-NAME
ProfdatrelPROFDATRELODB-DATA-MART-NAME → PFL-DATA-MART-NAME, → PFL-PROFILE-NAME, → PFL-DATA-LOAD-NAME

Programs

Updated by (22)

Referenced by (75)