Product(s):	AssetWise APM Foundation
	Version(s):	07.11.00.27
	Environment:	N\A
	Area:	N/A
	Subarea:	N\A

Problem Description

When checking the riskplot of an analysis of certain site/factory, it has been noticed that there are more assets considered in the riskplot than there are in the analyses. We were able to see assets from other sites that shouldn't be there according to the analysis.

When selecting a certain score, the assets belonging to the score show down below. There you can see assets belonging to other sites.

Steps to Resolve

1. We need to display SQL from risk plot table.
2. Check the where clause. In this case. the SQL is missing the first part of the Where clause, the clause that limits the assets to the current analysis.
3. A filter should be added to the configuration to fix the issue.
4. Open the Assets configuration.
5. Browse and add the object ID of the analysis.
6. Click Browse.
7. Using the Join Path selector open the analysis node. (The node might be named something like Asset Prioritization Analysis or Asset Analysis).
8. Select the Object ID column and add it to the configuration column.
9. On the Filtering tab, add a new filter, Column to Filter = Object ID (the column you added), Condition = This attribute’s value.
10. The attribute to filter on control will now be enabled (and mandatory). Select the Object ID attribute. It should be the only attribute available to be selected.
11. Save the configuration. Restart the application.
12. Display the SQL again. The SQL should now have a Where clause something like the highlighted one below, the ACAAnalysisoi= a number (the object ID of the analysis).

SELECT c.TotConsScore,a1.Title,a1.icon,p.Probability,a1.AssetNumber,a1.FuncPosition,c.RelativeRisk,c.AnalysisStat,p.FailureRate_fl,c.CriticalityA_oi,c.Asset_oi,c.AssetCritica_oi,c.ProbabilityO_oi,c.ACAAnalysisAssetoi,c1.Site_oi

FROM MNT.CriticaltyAnalysis c1,(((MNT.CriticalityAsset c

   LEFT OUTER JOIN MNT.PFFailure p ON c.ProbabilityO_oi=p.ACAProbabilityOfFailureoi)

   LEFT OUTER JOIN MNT.AssetCriticality a ON c.AssetCritica_oi=a.AssetCriticalityoi)

   LEFT OUTER JOIN MNT.Asset a1 ON c.Asset_oi=a1.Assetoi)

WHERE (c.CriticalityA_oi=c1.ACAAnalysisoi) AND (((c.ACAAnalysisAssetoi IN (27251,27252,27253,27254,27255,27256,27257,27258,27259,27260,27261,27262,27263,27264,27265,27266,27267,27268,27269,27270,27271,27272,27273,27274,27275,27276,27277,27278,27279,27280,27281,27282,27283) AND p.ACAProbabilityOfFailureoi IN (7) AND a.AssetCriticalityoi IN (14)) AND ((c1.ACAAnalysisoi=26193))))

ORDER BY a1.AssetNumber ASC/* SliceContext MCLBConfigurationOI=1040013934 */