Prerequisites
Before starting, ensure you have:- Risksheet installed and licensed in your Siemens Polarion ALM project
- Administrative access to edit the sheet configuration
- Severity and probability rating enumerations defined in Polarion Administration > Enumerations
- Custom fields on your risk work item type bound to those enumerations
- Familiarity with the configuration editor
When to Use Action Priority vs. RPN
The AIAG & VDA Failure Mode and Effects Analysis (FMEA) Handbook introduced Action Priority as a replacement for traditional RPN scoring. Rather than multiplying three numerical ratings, Action Priority maps severity and occurrence (or probability) directly to action categories.| Low Probability | Medium Probability | High Probability | |
|---|---|---|---|
| High Severity | Further Investigation | Unacceptable | Unacceptable |
| Medium Severity | Acceptable | Further Investigation | Unacceptable |
| Low Severity | Acceptable | Acceptable | Further Investigation |
- Acceptable — No action required
- Further Investigation — Evaluate further, action recommended
- Unacceptable — Action mandatory
Define Rating Scales as Polarion Enumerations
Risksheet does not define rating scales inside the sheet configuration. Instead, rating values live in standard Polarion enumerations, and the sheet configuration references them by enum ID.
- In Polarion, go to Administration > Enumerations for your project (or the global scope).
- Create two enumerations, for example
risk-severityandrisk-probability. Add values such as1 - Minor,2 - Moderate,3 - Significant,4 - Severe,5 - Criticalfor severity and a comparable set for probability. - On your risk work item type, define two custom fields — for example
severityandprobability— each typed as the corresponding enumeration.
type: rating:<enumId> and bindings: <fieldId>. No rating definitions are duplicated in the sheet configuration.Create the Risk Value Formula
Define a Adjust the threshold combinations to match your organization’s risk acceptance criteria.
riskValue function in the formulas section of the sheet configuration. The formula maps severity and probability to action categories using conditional logic:Configure the Risk Value Column
Add severity, probability, and a calculated column that references the The
riskValue formula. Note the rating type syntax rating:<enumId>, which loads enum values from Polarion automatically:actionPriority column is automatically read-only because it uses a formula property.Add Conditional Formatting
Apply color-coded styling to the Action Priority column using Style values must be wrapped in
cellDecorators and styles. Use toggleClass so cells reuse classes correctly during scrolling:{} braces. The result is a traffic-light display:| Action Priority | Color | Meaning |
|---|---|---|
| Acceptable | Green | No further action required |
| Further Investigation | Yellow | Evaluate and decide on risk reduction |
| Unacceptable | Red | Action is mandatory |
Customizing the Matrix
To adapt the Action Priority matrix to your specific risk acceptance criteria:- Adjust thresholds — modify the if-statement conditions in the
riskValueformula to change which severity/probability combinations map to each category. - Add categories — extend the formula with additional return values (for example “Monitor”, “Urgent”) and add matching styles.
- Use numeric scores — if you prefer a numeric Action Priority score instead of categories, return a calculated number and use threshold-based
cellDecoratorssimilar to RPN formatting.
Verification
After saving the sheet configuration:- Reload the Risksheet document in your browser.
- You should now see Severity and Probability input columns alongside the calculated Action Priority column.
- Enter severity and probability values for a risk item — the Action Priority cell should display a color-coded category.
- Verify that different severity/probability combinations produce the expected action categories.
See Also
- Configure FMEA Workflows — traditional RPN-based risk assessment
- Set Up Risk Matrices — custom matrix configurations
- Configure Calculated Columns — formula syntax reference
- Apply Conditional Formatting — additional cell styling options
- Configure HARA Workflows — HARA with risk matrix lookup