Applies To
Product(s):	OpenPlant Reporting
Version(s):	08.11.09.XXX (SS5) | 08.11.11.XXX (SS6)
Environment:	Windows 7/8.1/10 (64 bit)
Area:	DGN Reporting
Subarea:	Grid Report
Original Author:	Harpreet Singh, Product Advantage Group

Background

This article will explain how X, Y, Z coordinates can be included in reports for each component in OpenPlant Modeler. By default, coordinates do not show up in the reports but with the help of changes in schema this can be achieved.

Steps to Accomplish

1. Launch class editor.
   
   
2. Load OpenPlant_3D schema and supplement it with OpenPlant_3D_Supplemental_Modeling schema.
   
   
3. Go to PIPING_COMPONENT class and add property X_POSITION as shown below:
   
   
   
   
4. Add “Calculated ECProperty Specification” custom attribute on this and add below expression.
   
   this.TRANSFORMATION_MATRIX.M03/1000
   
   
   
   
5. Now add another property, Y_POSITION.
   
   
   
   
6. Add “Calculated ECProperty Specification” custom attribute and write below expression in EC expression field.
   
   this.TRANSFORMATION_MATRIX.M07/1000
   
   
   
   
7. Similarly, for Z coordinate create new property Z_POSITION and add below expression in “Calculated ECProperty Specification” custom attribute.
   
   this.TRANSFORMATION_MATRIX.M11/1000
   
   
   
   
8. Save the changes in schema and re-open the model.
   
   
9. Right click on ‘BOM by Line Number’ report and select EDIT option.
   
   
   
   
10. Edit the query by clicking on the Ellipse button on the query field in the dialog as shown below:
    
    
    
    
11. Click on “Include these properties” option in this dialog.
    
    
    
    
12. Scroll down on the properties tab and check these highlighted properties on and click OK on subsequent dialogs.
    
    
    
    
13. Generate the reports and you should see the coordinates in the grid report window.
    
    
    
    
14. You can also export the report in an excel format and check.
    
    

NOTE: If you are working in Imperial projects, then expressions to calculate the X, Y, Z values would be different.

For X it would be this.TRANSFORMATION_MATRIX.M03/304800
For Y it would be this.TRANSFORMATION_MATRIX.M07/304800
For Z it would be this.TRANSFORMATION_MATRIX.M11/304800 assuming that UOR is 304800.

See Also

communities.bentley.com/.../19975.to-show-ec-class-name-property-for-supports-in-openplant-modeler-reports

communities.bentley.com/.../19972.how-to-extract-reports-for-multiple-component-class-in-openplant-modeler

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!