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)

Link to GDrive documentation