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:
-
From EDE Explorer, open the view-only EDE you want to convert.
-
In the EDE Actions tab, click Convert to Editable EDE using the Query Builder .
-
In the View Properties dialog box, the EDE name is already provided and can be edited, in the Name field.
-
Select a view type from the View Type list.
-
Select a report type from the Report Type list.
-
Select a document type from the Published Document Type, (only available in an integration environment).
-
Click OK.
-
In the Query Builder, right-click an item, and select Add relation to, from the list select the items to create the relationship with.
-
Right click Relation .
-
From the Relation dialog box, select the relationship type and relationship method.
-
From the Query Builder toolbar, select Save Query .
-
Close the query.
-
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.