Overview
The RAP BI4 application deals with HSE dioxine rates control, by collecting result of analysis of samples (sludges, wastes, soils,etc) from external labs.
Database Design
RAP BI4 Database Diagram
The main fact table is RAP_RESULTAT_ANALYSE
Data Loading
The loading process is done by using the RAP tool (with embedded version of QuikLoad) on the following table layouts:
The loading frequency is eventual (usually twice a month).
Link to RAP Tool
Universe Design
RAP.UNX
Data Foundation
Business Layer
Main BI4 Reports
BI4 core folder: 46 - RAP HSE (Solvay Legacy)
Access restriction applied on the BI4 folder.
There are two core reports "Resultats d'analyses" and "Error_Data_Sample_Results" that contains a scheduled publication.
