Generate an Editable EDE View from a View-Only EDE - Intergraph Smart Instrumentation - Help

Intergraph Smart Instrumentation Help

Language
English
Product
Intergraph Smart Instrumentation
Search by Category
Help
Smart Instrumentation Version
13.1

When converting a SQL statement in the SQL Editor folder to a view-only EDE, the EDE view loses any relationships, and does not allow any editing of data in the grid. You can still run reports, and report revisions from this view-only EDE, with the exception of running the Report Comparison Wizard.

To be able to edit a view-only EDE, you need to follow this procedure:

  1. From EDE Explorer, open the view-only EDE you want to convert.

  2. In the EDE Actions tab, click Convert to Editable EDE using the Query Builder EDE Edit EDE Definition .

  3. In the View Properties dialog box, the EDE name is already provided and can be edited, in the Name field.

  4. Select a view type from the View Type list.

  5. Select a report type from the Report Type list.

  6. Select a document type from the Published Document Type, (only available in an integration environment).

  7. Click OK.

  8. In the Query Builder, right-click an item, and select Add relation to, from the list select the items to create the relationship with.

  9. Right click Relation Relationship DB Icon.

  10. From the Relation dialog box, select the relationship type and relationship method.

  11. From the Query Builder toolbar, select Save Query .

  12. Close the query.

  13. In the EDE Explorer, navigate to the folder of your saved EDE view, click to open it.

    Your EDE view is now editable. For more information on working with the EDE view, see Working with EDE Views.