Users now have more power to create data reports with the information that is important to their teams with the new SQLite DB export capability and the AutoPIPE Report Manager.
The following are the limitations associated with this Technology Preview.
On the Create Report tab, the < filter is not available.
All default supports reports require at least one un-designed hanger selection result to be available.
Unit labels are missing for same tables.
No aggregate functions like Max, Min, and AVG are available on the Create Report tab and can be defined only by direct SQL input.
No Group By or Sort By options are available on the Create Report tab and can be defined only by direct SQL input.
Only a single filter per column is available on the Create Report tab; however, users can define additional filters only in direct SQL input.
Select File > Import/Export > Export > SQLITE Database (*.db) to display the Export to SQLITE Database dialog.
Enable the Select All check-box to select all data to be exported. Enabling this check-box automatically enables the Input, Output, and Hanger Selection check-boxes.
Enable the Input check-box to export input data only.
Enable the Output check-box to export output data only.
Enable the Hanger Selection check-box to export the selected hanger data only.
Disable the Open Database in AutoPIPE Report Manager check-box.
NOTE: Enabling the Open Database in AutoPIPE Report Manager check-box automatically opens the AutoPIPE Report Manager when the export is completed. If you have enabled this option, continue with Step 9.
Press OK. The SQLite database file is exported to the same directory as the current model file and uses the name of the model file (e.g. MODELNAME.DB).
Select Tools > Report Manager > Report Manager to display the AutoPIPE Report Manager.
Press the Browse button adjacent to the Source File field to display the Open dialog.
Select the appropriate database file (*.db), then press Open.
Select the Default Reports tab to display a list of fixed (read-only) reports.
NOTE: All reports require that an un-designed hanger is present in the system and hanger selection is performed.
Select the Custom Reports tab to display a list of custom reports (saved SQL queries).
Select the SQL tab to enter a custom SQL query.
Select the Create Report tab to create a custom report. For this sample workflow, you will create a custom report for Gravity displacement < -0.1.
Select Displacement Data from the Choose Tables/Columns list, then press Add Table to next selection for report generation.
Expand the Displacement Data column within the Selected Tables/Columns list, then select the Translation_X table and press Remove Table/Column from this selection .
Repeat this process and remove the Translation_Z, Rotation_X, Rotation_Y, and Rotation_Z tables.
Select Load_Combination from the Selected Tables/Columns list, then press Add/Modify Filter to display the Filter Condition dialog.
Select LIKE from the drop-down pick-list, then type GR in the adjacent field, then press OK.
Select Translation_Y from the Selected Tables/Columns list, then press Add/Modify Filter to display the Filter Condition dialog.
Select <= from the drop-down pick-list, then type 0.1 in the adjacent field, then press OK.
Press Generate Report. Once the report generation has completed, a status message is displayed within the status bar.
The custom report (.xlsx) is exported to the same directory as the current model file and uses the name of the model file (e.g. MODELNAME_JoinsReport.xlsx).
AutoPIPE Technology Previews
Bentley AutoPIPE