*** No WebI report using this universe has been refreshed by end users in 2016 ***

To be flagged as obsolete in 10-2019 ? Access to be removed ?


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 connections

In Oracle, user ICRDBA

 

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 Documentation

RAP.UNX

Data Foundation (PDF)

Business Layer (PDF)

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.

 

Useful links

Link to UpToDate documentation of universes (from 360 eyes)

Link to Knowledge Transfer documents for RAP