Applies To
Product(s):	OpenPlant Reporting
Version(s):	08.11.09.XXX (SS5) | 08.11.11.XX (SS6)
Environment:	Windows 7/8.1/10 (64 bit)
Area:	Piping Component
Subarea:	Weld Reports
Original Author:	Rahul Kumar, Bentley Product Advantage Group

Overview

To generate weld reports including slip on joint welds inside OpenPlant Modeler using DGN reporting.

Problem Description

In a model various welds can be generated while modeling a pipeline. In case of Slip On flange joint two types of welds are connected and hence weld quantity gets need to report as double. Currently in OpenPlant Modeler, when weld reports generated, it does not display any weld name and quantity to filter out based on Slip on Joint. However, with below customization process by modifying & creating few properties and applying custom attributes will solve the problem.

In OpenPlant Modeler check item tree browser for welds. Notice its sub nodes has no information about type of welds. 

Steps to Resolve

1. In Class Editor, Open “OpenPlant_3D.01.07.ecschema” & supplement it with below schemas.
   OpenPlant_3D_Supplemental_Modeling.01.07.ecschema
   OpenPlant_3D_Supplemental_ModelingViews.01.07.ecschema
   
   Note - On Adding & Supplementing schema procedure refer this>>>>> Link. 
   
   
2. Navigate to WELD class. Under properties tab, check NAME property and set override. See image below. 
   
   
   
   
3. Add custom attribute Calculated ECProperty Specification on NAME property. See below steps
   1. Right click on NAME property, select Add/Remove option. See image below.
      
      
      
      
   2. From Dialog box shown below, pull desired property & click OK. Select location to correct supplemental schema.
      
      
      
      
   3. It will get added inside NAME property. 
      
      
4. Add below expression to it & fill other required fields like shown in below image.
   this.GetRelatedInstance("JOINT_HAS_FASTENER:1:JOINT").GetRelatedInstance("PORT_HAS_JOINT:1:PORT").END_PREPARATION
   
   
   
   
5. This will display Weld item type attached to end preparation type.
   
   
   
   
6. To display total weld quantity including slip on weld, a new property need to be created in schema, say WELD_NO. 
   1. Copy existing property say UNIT. See image below. 
      
      
      
      
   2. Scroll down in an empty space of property tab and right click, do a paste. See image below.
      
      
      
      
   3. Rename it to WELD_NO and add custom attribute Calculated ECProperty Specification like explained in point 3 above.
      
      
7. Add expression as mentioned below and enter other data shown in image. 
   IIF(this.GetRelatedInstance("JOINT_HAS_FASTENER:1:JOINT").GetRelatedInstance("PORT_HAS_JOINT:1:PORT").END_PREPARATION="SLIP_ON","2","1")
   
   
   
   
8. Save & Close Schema.
9. Launch OpenPlant Modeler.
10. Select Item Reports option. See image below. 
    
    
    
    
11. Under Piping Components, create new report for welds like shown in image below. 
    
    
    
    
12. Enter Name for reports, query for weld class and select OK. See image below. 
    
    
    
    
13. Select Grid report template.
    
    
    
    
14. Right click on weld report to generate grid template.  
    
    
    
    
15. See report generated in grid template, which can also get exported to csv or excel file for further use. 
    
    
    
    
16. Notice Slip on weld type with 2 quantity and other weld count. 

See Also

stage-communities-bentley2-com.telligenthosting.net/.../openplant-reporting

Still a Problem?

If above problem still persist, then please create a Service Request and contact the Bentley Product Advantage group.  Please include a list of all relevant details to get in depth analysis for a solution or workaround. 

Comments or Corrections?

Bentley's Product Advantage Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!