Risks
DataSource Transactional Data 0EHSM_HSS_RAS_01
Use
You can use this DataSource to extract risk analysis data from SAP EHS Management into SAP NetWeaver Business Warehouse (SAP NetWeaver BW). The DataSource extracts the data from the following nodes of the following business object:
-
Business object EHHSS_RISK
-
ROOT
-
REVISION
-
ANALYSIS
-
-
Business object EHHSS_RISK_ASSESSMENT
-
ROOT (only the fields KEY and ID)
-
-
Business object EHFND_LOCATION
-
ROOT (only the ID field)
-
-
Business object EHHSS_AGENT/EHFND_CHEMICAL
-
ROOT (only the ID field)
-
-
Business object EHHSS_JOB
-
ROOT (only the ID field)
-
The DataSource extracts data only for those risks for which a risk analysis has been performed.
Technical Data
| Application Component | SAP EHS Management (EHS-MGM-RAS) |
|---|---|
| Exchange Available as of Release | Component Extension 2.0 for SAP EHS Management |
| Shipment | SAP NetWeaver 7.0 BI Content Add-On 7 SP 02 |
| Content Versions | EHM200, EHM300 |
| RemoteCube-Capable | No |
| Delta-Capable | Yes |
| Extraction from Archives | No |
| Verifiable | No |
Prerequisites
-
You have configured the DataSource in Customizing in the source system under
SAP EHS Management 
Foundation for EHS Management Analytical Reporting Configure Extractors
. -
The BAdI implementation BADI_EHFND_FW_BI_BOPF_OBJ_LIST must be an active default implementation of the BAdI BADI_EHFND_FW_BI_OBJ_LIST. For more information, see Customizing in the source system under
SAP EHS Management Foundation for EHS Management Analytical Reporting BAdI: Determination of Objects to Extract. -
The BAdI implementation BADI_EHFND_FW_BI_BOPF_EXTRACT must be an active default implementation of the BAdI BADI_EHFND_FW_BI_EXTRACTOR. For more information, see Customizing in the source system under
SAP EHS Management Foundation for EHS Management Analytical Reporting BAdI: Extraction of One Object.
Data Modeling
Delta Update
The delta update used for this DataSource is AIED (After-Images with Deletion Indicator by Extractor). The deciding field for the update is BW_DELTATIMESTMP.
Fields of Origin for the Extraction Structure
| Fields in the Extraction Structure | Description of the Field in the Extraction Structure | Table of Origin | Field in the Table of Origin |
|---|---|---|---|
| ID | Risk ID | - | - |
| RISK_ROOT_KEY_REF | Risk Key | - | - |
| HAZARD | Hazard | - | - |
| RAS_ROOT_KEY_REF | Risk Assessment Key | - | - |
| RAS_ID | Risk Assessment ID | - | - |
| LOCATION_ID | Location ID | - | - |
| OPERATION_STATUS | Operational Status | - | - |
| AGENT_ID | Agent ID | - | - |
| AGENT_KEY_REF | Agent Key | - | - |
| JOB_ID | Job ID | - | - |
| SPLIT_DATE | Revision Date | - | - |
| STATUS | Risk Status | - | - |
| ANALYSIS_KEY_REF | Internal Key of Analysis Instance | - | - |
| TYPE | Risk Type | - | - |
| LEVEL | Risk Level | - | - |
| SCORE | Risk Level Score | - | - |
| LIKELIHOOD | Likelihood | - | - |
| SEVERITY | Severity | - | - |
| EXPOSURE | Exposure Frequency | - | - |
| EVALUATION | Evaluation | - | - |
| NUM_UNACC_RISKS | Number of Unacceptable Risks | - | - |
| NUM_INADEQ_CTRL | Number of Inadequate Controls | - | - |
| BW_RECORDNUMBER | Serial number of record since one risk can have multiple records | Generated (by extractor) | - |
| BW_RECORDMODE | Record mode that allows flagging records for deletion in BW | Generated (by extractor) | - |
| BW_DELTATIMESTAMP | Time stamp for delta load | Input for extractor | - |
Extractor Logic
The extractor extracts only the most recent revision of a risk. The actual extractor logic is implemented as a BOPF determination of the transient node BI_RISKS of the business object EHHSS_RISK. The business object EHHSS_RISK saves references to the following business objects:
-
EHHSS_RISK_ASSESSMENT
-
EHFND_LOCATION
-
EHHSS_AGENT
-
EHFND_CHEMICAL
-
EHHSS_JOB
These references consist of internal keys (GUIDs). Except for agents, the extractor does not extract these internal keys. Instead, the extractor translates these keys into the ID of the corresponding business object instance. Because the agent IDs are not necessarily unique (depending on how the number range objects are maintained in Customizing), the extractor also extracts internal keys for agents.
The hazard category is not saved in the business object EHHSS_RISK directly. The extractor determines the hazard category from the customizing table EHHSSC_HAZARD.
The key figures are extracted 1:1 without any transformations or calculations.
Verification of Key Figures
You can verify the key figures in the following way:
|
Key Figure |
Verification |
|---|---|
|
SCORE |
Checks the risk value for the inherent risk, initial risk, and residual risk in the most recent revision of the respective risk. |
|
NUM_UNACC_RISKS |
Counts the number of inherent risks, initial risks, and residual risks with evaluation Unacceptable in the most recent revision of the respective risk. |
|
NUM_INADEQ_CTRL |
Counts the number of controls with effectiveness Inadequate in the most recent revision of the respective risk. |
Unsychronized Backup Recovery in BI System
The DataSource does not use an own time stamp management. The DataSource uses the generic delta functionality.