Setting the data warehouse installation parameters

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.

Enter 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.

Note: 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. Note: 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. Note: 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.

Note: 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.