OELs and Amounts

DataSource Transactional Data 0EHSM_HSS_RAS_02

Use

You can use this DataSource to extract amounts that have been compared to their respective limit value as part of a risk analysis from the conducted risk assessments 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 objects:

  • Business object EHHSS_RISK

    • ROOT

    • REVISION

    • ANALYSIS

    • OEL_VALUES

  • Business object EHFND_DATA_AMOUNT

    • ROOT

  • Business object EHHSS_AGENT/EHFND_CHEMICAL

    • ROOT (only the ID field)

    • LIMIT

  • Business object EHHSS_RISK_ASSESSMENT

    • ROOT (only the fields KEY and ID)

  • Business object EHFND_LOCATION

    • ROOT (only the ID field)

  • Business object EHHSS_JOB

    • ROOT (only the ID field)

The DataSource extracts data only for those risks for which an exposure 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 Start of the navigation pathSAP EHS Management Next navigation step Foundation for EHS Management Next navigation step Analytical Reporting Next navigation step Configure ExtractorsEnd of the navigation path.

  • 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 Start of the navigation pathSAP EHS Management Next navigation step Foundation for EHS Management Next navigation step Analytical Reporting Next navigation step BAdI: Determination of Objects to ExtractEnd of the navigation path.

  • 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 Start of the navigation pathSAP EHS Management Next navigation step Foundation for EHS Management Next navigation step Analytical Reporting Next navigation step BAdI: Extraction of One ObjectEnd of the navigation path.

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 - -
HAZ_CAT Hazard Category - -
OPERATION_STATUS Operational Status - -
RAS_TYPE Risk Assessment Type - -
AGENT_ID Agent ID - -
AGENT_KEY_REF Agent Key - -
JOB_ID Job ID - -
SPLIT_DATE Revision Date - -
STATUS Risk Status - -
OEL_KEY_REF Analysis Key - -
TYPE Risk Type - -
ACT_VALUE_MEAS Action Value for Exposure Analysis - -
EXP_RESULT Result of Exposure Analysis - -
LIMIT_VALUE OEL Value - -
LIMIT_UNIT OEL Unit - -
AMOUNT_CAT Amount Category - -
AMN_VALUE Amount Value - -
AMN_UNIT Amount Unit - -
RATING Exposure Rating - -
LOCATION_ID Location ID - -
RAS_ID Risk Assessment ID - -
REGULATION Regulation/Regulatory List for OEL - -
SAMPLING_DATE Sampling Date - -
VALUE_TYPE Amount Value Type - -
SAMPLING_DUR Duration of Sampling Period - -
OEL_AGNT_KEY_REF Agent With Limits or Amounts - -
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_LIMITS 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.

The sampling duration for the field SAMPLING_DUR is derived from the start date/time and the end date/time from the amount record. When no end date/time has been maintained, this field remains empty. The extractor creates a language-independent description of the duration where language-dependent texts are represented by placeholders. For example, the duration 1 Hour is extracted as 1 #hh# where #hh# is the placeholder for Hour. The system inserts the language-dependent texts during the query runtime in BW depending on the current user’s logon language.

To create the values for the RATING field, the extractor concatenates the hazard from the root record with the rating from the OEL record separated by a period (dot). This allows entering rating texts depending on the hazard. For non-chemical hazards, the extractor also appends a number to the rating code that corresponds to one of the texts entered in the source system in the Customizing activity for SAP EHS Management under Start of the navigation pathRisk Assessment Next navigation step Risk Analysis Next navigation step Exposure Analysis Next navigation step Specify Exposure Ratings for Non-Chemical AgentsEnd of the navigation path.

The field OEL_AGNT_KEY_REFcontains the agent for which the OEL or amount exists. This is not necessarily the agent for which the risk is defined. The risk could be defined for a chemical mixture, whereas the limit values are defined for the mixture’s ingredients.

Verification of Key Figures

In the exposure analysis, the system compares the amount (AMN_VALUE) that was collected for an agent to the selected occupational exposure limit (OEL) (LIMIT_VALUE) of the agent to produce the exposure result (EXP_RESULT). For non-chemicals, the system subtracts the value of the OEL from the value of the amount. For chemicals, the system divides the value of the amount by the value of the OEL, and multiplies the result by 100 to express the result as a percentage. To verify these key figures, check the exposure analysis in the application for the inherent risk, initial risk, and residual risk of 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.