============================================================
============================================================
09.2020 - BI4-RAP decomissionned
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 DIAGRAM
The main fact table is RAP_RESULTAT_ANALYSE
BI4/Oracle CONNECTIONS
In Oracle, user ICRDBA
Data Loading - RAP QUIKLOAD
QuikLoad XLS file is available here : \\wdcbiaq01.eua.solvay.com
QuikLoad name : RAP_Tool_Ex2010_V06.xlsm
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
BI4 UNIVERSE
RAP.UNX
Data Foundation (PDF)
Business Layer (PDF)
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.
