Modify a Business View
To modify a business view, sign in to the Angles Hub, and perform the following steps:
Modify required details on the Overview tab
Click Business Views. The Business Views page is displayed.
Click Grid View.
Enter the name of the view in the Search box.
Click Copy. Copy the view you want and modify it.
-
Enter the required details in the Overview tab.
Note: Update the ViewName, Short Description, Application Type, and Source Application.
Click Save view. To save as a new version, enter the comment, and click Save Changes.
Modify required details on the Query tab
Click Query. The Query tab is displayed.
-
Click SQL Query. The SQL Query tab is displayed.
Note: The changes you make in the Query Model, Columns Criteria, or SQL Query sections reflect in the other sections.
- Enter the SQL Query and click Next.
- Click Refresh.
- Click Columns Criteria.
- Customize the business views by:
Selecting, grouping, or renaming columns
Hiding or deleting columns
Modifying aggregation or sorting
- Optionally, customize the query of the business view through Query Model.
- To build your query, drag a table to the Query Model and create joins.
- Click Query Results.
Note: Keep updating the business views in SQL Query, Query Model, or Columns Criteria until you get the desired query result.
- Click Save view.
- To save as a new version, enter the comment and click Save changes.
Click Columns.
Enter the description of columns.
Click Save view.
To save as a new version, enter the comment and click Save changes.
Click Join Relations > Add Join. The Add/Edit Join window is displayed.
Enter the View to Join.
Enter the View Alias.
Select the Join Type.
Click Column Mapping.
Click Add Condition.
Select From View Column and To View Column.
Click Save > Save View.
To save as a new version, enter the comment, and click Save changes.
Compare different versions of a business view
Click Versions.
The different versions of the business views are available here.
To compare different versions of the business view, select the business views, and then Compare.
To delete different versions of the business view, select the business views, and then click Delete.