Overview
The RAP BI4 application deals with HSE dioxine rates control.
Database Design
RAP BI4 Database Diagram
The main fact table is RAP_RESULTAT_ANALYSE
RAP BI4 Connection
- RAPICP_ODBC for the production environment
- RAPICR_ODBC for the development environment
Data Loading
The loading process is done by using the QuikLoad tool (version adjusted for RAP) on the following table layouts:
The loading frequency is eventual (usually twice a month).
Universe Design
RAP.UNX
Data Foundation
Business Layer
Main BI4 Reports
There are two core reports "Resultats d'analyses" and "Error_Data_Sample_Results" that contains a scheduled publication.
BI4 core folder: 46 - RAP HSE (Solvay Legacy)