OLAPDBM

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
HCAG.1 HCCP.1 HCEM.1 HCJC.1 HCPO.1 HCRV.1
HCSC.1 HCSU.1 HCYR.1 POAP.1 WA01.1 WACP.1
WAD3.1 WAMS.1 WAYR.1 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
CBBB.1 CBBC.1 CBBD.1 CBBO.1 CBBR.1 CBBT.1
HCHM.1 HCMS.1 IA03.1 IA04.1 IA04.2 IA08.1
IA115 IA12.1 IA12.2 IA12.3 IA125 IA13.1
IA14.1 IA16.1 IA200 IA300 IADE.1 IAMB.1
IAMD.1 IAMR.1 IAPF.1 IASD.1 IATM.1 IAVO.1
IAYR.1 GLBA.1 GLBD.1 GLBP.1 GLBT.1 GLBY.1
IFBA.1 IFBC.1 IFBO.1 IFBS.1 IFEO.1 POA1.1
POA10 POAB.1 POAM.1 POAO.1 WA02.1 WAD1.1
WAD2.1 WAD4.1 WAPC.1 IA01.1 IA01.3 IA00.1
IA00.6


UPDATED BY
ACDL.1 AMDL.1 CBOP.1 HC10.1 HCDL.1 HCHP.1
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 WADL.1 WAOP.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ODB-DATA-MART-NAME
Element: Data Mart Name
Alpha 20 (Lower Case)
This field contains the name of the data mart.
IA10.1 IASV.1
ODB-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
The Description field contains a description of the data mart.
IA10.1 IASV.1
ODB-APPLIC-TYPE
Data Mart Type
Alpha 3
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
IA10.1 IASV.1
ODB-SERVER-NAME
Element: 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
Element: Dimension Build Date
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
Element: Dimension Build Time
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
Element: Data Load Date
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
Element: Data Load Time
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
Required Dimension
Rebuild
Alpha 1
The 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
Element: Required Data Reload
Alpha 1
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.
IA10.1 IA120
IA150 IAAP.1
ODB-LOCK-OPTION
Element: Lock Option
Alpha 1
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
Element: Processing
Alpha 1
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
IA05.1 IA05.3
IA120 IA150
IASV.1
ODB-AUTO-REBUILD
Element: Auto Rebuild
Alpha 1
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
Element: Error Log Number
Numeric 3
The Error Log Number field displays the error message number found during the outline build or data mart load.
ODB-LAST-DIM-SEQ
Last Dimension
Sequence Number
Numeric 4
The 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
Staging Application
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
External Data
Sources Exist
Alpha 1
The 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
Element: Data Target
Alpha 1

1 = Hyperion Essbase Server
2 = Star Schema Format
IA10.1 IASV.1
ODB-ARBOR-PATH
Element: 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
Element: Dta Drill Path
Alpha 100 (Lower Case)
ODB-APPLIC-NAME
Element: 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
Element: 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
Element: Active Status
Alpha 1
The status of the account. If Inactive, no posting can be done to the account.
A = Active
I = Inactive
IA10.1
ODB-SECURITY-ON
Element: Security On
Alpha 1
This field indicates whether the budget is securing individuals from access.
Y = Yes
N = No
IA10.1 IA20.1
ODB-MART-CREATOR
Element: Mart Creator
Alpha 20 (Lower Case)
IA10.1
ODB-DATABASE-SPACE
Element: Database Space
Alpha 25 (Lower Case)
IA10.1 IASV.1
ODB-CREATED-GEN
Element: Created Gen
Alpha 1

Y = Yes
N = No
" " = No
IA10.1 IA150
IANM.1
ODB-TABLE-CHANGE
Element: Table Change
Alpha 1
ACDL.1 AMDL.1
CBOP.1 GLOP.1
HCDL.1 HCHP.1
IA10.1 IA150
IANM.1 POA3.1
WADL.1 WAOP.1
ODB-FACT-TBL-NAME
Element: Fact Tbl Name
Alpha 50 (Lower Case)
ODB-NBR-COLUMNS
Element: Nbr Columns
Numeric 3
ACDL.1 AMDL.1
CBOP.1 GLOP.1
HCDL.1 HCHP.1
IA150 POA3.1
WADL.1 WAOP.1
ODB-OLAP-TYPE
Element: Olap Type
Alpha 1

X = XML OUTPUT
C = CSV OUTPUT
ODB-DRILL-ENABLED
Element: Drill Enabled
Alpha 1
This field indicates whether drill around functionality should be enabled for this data mart.
Y = Yes
N = No
IA05.1 IA10.1
ODB-SERVICE-OPTION
Element: Service Option
Alpha 1
This 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
Element: Converted
Alpha 1

" " = Requires Conversion
N = Does Not Require Conversion
HC10.1 IA120
ODB-OLAP-STORAGE
Element: Olap Storage
Alpha 1
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
IA05.3 IA10.1
ODB-OLAP-AGGR-OPT
Element: Olap Aggr Opt
Alpha 1
Olap aggregation option: perform aggregations until the OLAP-AGG-LIMIT is hit.
S = Storage
P = Performance
IA05.3 IA10.1
ODB-OLAP-AGGR-LIMT
Element: Olap Aggr Limt
Alpha 10
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.
IA05.3 IA10.1
ODB-OBJ-ID-PREFIX
Element: Obj Id Prefix
Numeric 3
ODB-OBJ-ID-SUFFIX
Element: Obj Id Suffix
Numeric 9
ODB-ENABLE-XML
Element: Enable Xml
Alpha 1

" " = Destination Default
A = XML Output Active
X = XML Output Only
ODB-NUMERIC-ID
Element: Numeric Id
Numeric 3
IA10.1 IASV.1


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 CBBB.1
CBBC.1 CBBD.1
CBBO.1 CBBR.1
CBBT.1 CBOP.1
HC10.1 HCAG.1
HCCP.1 HCDL.1
HCEM.1 HCHM.1
ODBSET2 APPLIC-TYPE
DATA-MART-NAME
KeyChange
IA01.1 IA01.3
IASV.1
ODBSET3 APPLIC-NAME
DATABASE-NAME
DATA-MART-NAME
KeyChange
IA10.1 IASD.1
IASV.1
ODBSET4 DATABASE-SPACE
DATA-MART-NAME
KeyChange
IA00.1 IA00.6
ODBSET5 DATABASE-SPACE
FACT-TBL-NAME
DATA-MART-NAME
KeyChange


OLAPDBM FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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-DATA-MART-GRP
  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


File created: Thu Jun 09 11:16:28 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.