View

A view is a logical table based on tables. Contents of this table is selected from basic tables by running SQL queries. A view only displays basic tables data without the ability to edit data. It can also be a data source for dimensions and cubes.

Creating a View

To create view in the object navigator click the

Create button in the main menu and select the object type on the New Object side panel.

Working with View

To edit the view selected in the object navigator:

Select the Edit item in the object's context menu.
Select the Edit in a New Tab item in the object's context menu.
Select the Edit in a New Window item in the object's context menu.
Press F4.

Then click the Settings button.

The view wizard opens. Determine settings on corresponding pages of the wizard.

To view data, select the corresponding object in the object navigator and execute one of the operations:

Select the Open item in the object's context menu.
Select the Open in a New Tab item in the object's context menu.
Select the Open in a New Window item in the object's context menu.
Double-click the object.
Press the ENTER key.

After executing one of the operations the corresponding data object opens. For details about principles of work with a data set see the Working with Data Set section.

To dynamically manage data displayed in the view, enter parameter values on the parameters panel. Click the Apply button to apply parameter values. For details about changing query contents see the Managing Parameters section.

As an external table only refers to a physical table, changes made in the physical object, on which the external table is based, are not displayed in the external table.

To refresh information of the table, based on which a view is created, select the Refresh Table Information item in the view's context menu in the object navigator. The following information from the database is refreshed:

Number of table rows and columns.
Type of field data.
List of indexes.
Time of the last refresh of table data in the version log.

Data contained in the view is automatically refreshed according to the obtained table information when the view opens.

If the view is opened for view and its information is refreshed, to refresh data, click the Refresh Table Contents button on the toolbar.

After executing the operations the view contents is refreshed.