Data Warehouse Control Settings

(Data Warehouse System Control Settings)

Access

This routine stores the settings used with the STORIS Data Warehouse STORIS' Data Warehouse (SDW) is a data analysis tool that provides great flexibility in manipulating and outputting data. (SDW) feature. Use SDW to export STORIS data into a centralized reporting database. Then, you separate the data into reporting units known as “data marts.”

Some system control settings are accessible by STORIS personnel only.

Next Batch Number(LOCKED - STORIS access ONLY!) This field is used in the transmission of multiple files each night. The files are grouped for transmission sequentially.

Suffix for Xmit Files(LOCKED - STORIS access ONLY!) Specify the file extension you want to use when transmitting files to the Data Warehouse.

Suppress Message Log Success Messages

 Resync/Setup Data Warehouse(LOCKED - STORIS access ONLY!) If you check the box at this field, the End of Day process does not run the Data Warehouse export process.   

STORIS references this field during initial installation or during full re-synchronization of the Data Warehouse. Normally, you leave this field blank.  

Data Source Warehouse ID(LOCKED - STORIS access Only!) Enter the Data Warehouse source ID (that is, the source of the data that flows into the Data Warehouse). STORIS assigns a source ID number for each of your data sources. All records imported into the Data Warehouse include a Source ID number.

For more information about data sources, contact your STORIS representative.

Data Marts Active