tips n tricks using ariel data and rules - sds and ehs ...3ecompany.com/sites/default/files/3e...
TRANSCRIPT
Proprietary and Confidential. Not to be distributed or
reproduced without permission of 3E Company.
Tips n Tricks using Ariel Data and Rules – Flexible configuration
options to adapt to your business needs
Guneet Kaur, Product Manager
June 28, 2016
Proprietary and Confidential. Not to be distributed or
reproduced without permission of 3E Company.
Ariel Integrated Content for SAP EHS
Regulatory Data
ADM EHSAP (PS & DG)
Product level Data
ADM VSDS EXPERT RULES
SUBJECTIVE RULES
WWI TEMPLATES MULTILINGUAL
PHRASES
Regulatory Reference
Ariel WebInsight
Integrated Content
Proprietary and Confidential. Not to be distributed or
reproduced without permission of 3E Company.
Tip 1
• Attend Quarterly Update Webinars
When: - ~ 2 weeks prior to the release date Purpose: - One stop shop for all integrated
content product updates
Who should attend: - Product Stewards - Management - IT
Upcoming Quarterly Update Webinar - Tuesday, July 7th, 2016
Proprietary and Confidential. Not to be distributed or
reproduced without permission of 3E Company.
Tip 2
• Utilize the delivered documentation
DOCUMENT LIBRARY UPDATE DOCUMENTATION
Reference Documents Pertinent to the Release
Per content product
Per subscription module
Examples: 1. Technical Update instructions 2. User Manuals 3. Expert Rules Reference material.
1. Overview Databases (Props, Chars, Phrases used by Rules)
2. Advanced Logic Details (Multilayer logic, Bound exclusion etc)
3. Flexibilities Spreadsheet
Examples: 1. Release notes 2. Technical config for the release
(new Z table entries, reglists, sources, function modules
3. DDRs (Data Definition Reports)
Located on the FTP site
Proprietary and Confidential. Not to be distributed or
reproduced without permission of 3E Company.
Tip 3
Ariel provides a plethora of regulatory data
• Use Filters! -ADM PS Filters for Rules
and Templates delivered
by 3E every quarter.
-Import/Export filters from
Dev to Qual to Prod
• Make decisions! What PCTEC data to load
Which generics to load
What regulatory content is relevant
• Use Impact Analysis!
Proprietary and Confidential. Not to be distributed or
reproduced without permission of 3E Company.
Tip 4
Use the latest rules Interface to:
• Run multiple rules on multiple specs at the same time
• Run rules in background
• View stored logs at a later time
Proprietary and Confidential. Not to be distributed or
reproduced without permission of 3E Company.
Tip 5
• Order of execution is important!
Proprietary and Confidential. Not to be distributed or
reproduced without permission of 3E Company.
Tip 6
• With expert rules flexibilities, you have the POWER!
Disclose ppm level OELs in section 8? Disclose ppm level components for Cal prop 65? Utilize CLP classifications for OSHA? Disclose all inventories on the SDS? Overwrite classification cut-offs with SCLs? Show HNOC classification and labeling on the SDSs? Want to evaluate supplier data? Range vs Exact value in Section 3 for OSHA? Exclude Impurities?
Proprietary and Confidential. Not to be distributed or
reproduced without permission of 3E Company.
Tip 7
• Expert rules are only as smart as the data they get
Not hazardous No Data
Proprietary and Confidential. Not to be distributed or
reproduced without permission of 3E Company.
Tip 8
• Need explanation of Rule Output?
Use Explanation Component
The explanation component provides hazardous substance experts and dangerous goods experts with immediate and subsequent explanations of how secondary data is determined. In table form, the EH&S Expert explanation component visualizes which primary data, rules, and conditions led to the results.
Proprietary and Confidential. Not to be distributed or
reproduced without permission of 3E Company.
Tip 9
• 3E tools DO NOT overwrite manual data
• Do not change ingredient data loaded by
ADM
• Do not change Rule outputs on the mixture level
• Do not change supplier information loaded via VSDS
Proprietary and Confidential. Not to be distributed or
reproduced without permission of 3E Company.
Tip 10
• Which phrase to select – ARI0* or ARI-S*?
When in doubt, always select the ARI-S* phrase.
Proprietary and Confidential. Not to be distributed or
reproduced without permission of 3E Company.
Tip 11
• Do not write soft sections of the SDS manually, use the Rules Builder!
– Utilize 3E delivered soft section rules out of the box
OR
– Write your own Rules using your own phrases
Proprietary and Confidential. Not to be distributed or
reproduced without permission of 3E Company.
Excel: Track recommend
new / amended rule logic
Rules Builder GUI: Create / amend rule
logic
Generate new rule
files: rul & mdb; add to Test server
Test & qualify new
/amended rule logic
Copy rul & mdb files to Production
server
Correct any problems
Tip 12
Best practice approach to using the Rules Builder
Proprietary and Confidential. Not to be distributed or
reproduced without permission of 3E Company.
Tip 13
• Overwhelmed? We’re always here
3E’s Customer Support available 24/7/365 Supportcenteronline.com