Set the data warehouse installation parameters to specify which data marts will be populated by the ETL driver. The installation parameters work in conjunction with the data warehouse run parameters to establish the date range by which the ETL process extracts data from the system and then populates the specified data marts within the data warehouse with the extracted data.
Specifically, the data warehouse installation parameters indicate the system modules for which the ETL process is going to load the data. The data warehouse run parameters establish the date range of a load type (full or incremental) for loading and purging data from the data warehouse.
See the following table for a list of the data warehouse installation parameters:
|
Installation Parameter |
Description |
ETL Module |
Table Values |
|---|---|---|---|
|
DWLABOR |
Booked Labor hours and Available Labor |
LABOR |
Trades, occupation types, personnel, and work orders |
|
DWMATL |
Daily Material transactions |
MATL |
Daily material transactions, stores, suppliers, work orders |
|
DWPARTS |
Parts and Stores daily values |
PARTS |
Parts, purchase orders, suppliers, classes, and stores for the SDS and PDS |
|
DWORDERS |
Purchase orders and order lines |
ORDERS |
Purchase orders, order line types, stores, suppliers, and part classes on orders |
|
DWSTATUS |
Daily Status changes |
STATUS |
Entities and status changes |
|
DWWARNTY |
Warranty claims accumulating values |
WARRANTY |
Equipment, suppliers, and warranty claims |
|
DWWORK |
Work orders accumulating and daily values |
WORK |
Equipment, service requests, work orders, budgets, and work order costs |
Each of the previous parameters indicates a specific data mart. For example, the DWLABOR parameter represents the LABOR ETL module (data mart) for which the ETL extracts data for trades, occupation types, personnel, and work orders.
Specify the appropriate setting for each of the parameters/data marts as necessary. You can also change the setting of the data warehouse parameters to temporarily enable or disable the loading of data into any of the data marts.
-
Select Administration > Security > Install Parameters
Filter the list of installation parameter records to display only the data warehouse
installation parameters using the Quick Filter.
-
Select the data warehouse parameter for which to enter a setting, and then click the Record View tab.
-
Specify one of the following settings for the data mart Value:
Option
Description
ON
Specify to indicate that the data mart is activated and will be populated by the ETL process based on the date entered for Load from Date on the Data Warehouse Run Parameters form.
The default Value setting for each parameter is ON.
OFF
Specify to indicate that the data mart is not active and will not be populated by the ETL process.
If you set the data mart to OFF, any data that is currently in the selected data
mart at the time you set the parameter to OFF will remain in the data mart.
TRUNCATE
Specify to indicate that the ETL process will truncate the respective date mart tables, and the data mart will not be populated in the future (which is the same as setting the parameter to OFF) based on the date entered for Load from Date on the Data Warehouse Run Parameters form.
If you change the setting of a data warehouse parameter from TRUNCATE to OFF, the
change will have no effect on the data mart, because both the OFF and the TRUNCATE
settings prevent the ETL process from loading data into the data mart. Changing the
setting from TRUNCATE to ON will activate the load process for the data mart, and
data will be loaded into the data mart by the ETL.
The DWTL driver must be enabled on the Job Setup form for any data mart to be populated by the ETL when you set any data warehouse installation parameter to ON.
However, if you set any of the parameters to OFF or TRUNCATE, the parameter setting will function as designed regardless of the setting of the DWTL driver.
-
Click Save Record.