View

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

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

In the desktop application:

Execute one of the operations:

Select the Create > Table context menu item.
Click the New Object button in the Create group on the Home ribbon tab and select the Table item.

Select a type of object to be created on the Object Type page.

Working with View

To edit the view selected in the object navigator:

In the web application:

Select the Edit item in the query's context menu.
Press F4.

Then click the Settings button

In the desktop application select the Edit item on the Home ribbon tab

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.
Double-click the object.
Press the ENTER key.
Select the Open button on the Home ribbon tab in the desktop application.
Click the Open > In Default Tool button on the Home ribbon tab in the desktop application.

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 view report data in the desktop application:

Click the Open > Regular Reports button on the Home ribbon tab.
Select the Open With > Regular Reports item in the object's context menu.

To import data in the desktop application:

Click the Open > Data Import Wizard button on the Home ribbon tab.
Select the Open With > Data Import Wizard item in the object's context menu.

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 reflected 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 tale information when the view opens.

If the view is opened for view and table information is refreshed, execute the following to refresh data:

In the web application click the Refresh Table Contents button on the toolbar
In the desktop application:

Click the Refresh Table Contents button on the toolbar.
Select the Table > Refresh main menu item.
Press F5.

After executing the operations the view contents is refreshed.

If the Saved View checkbox was selected on creating a view, data is refreshed according to basic tables using the Refresh Data item in the view's context menu. If the checkbox is deselected, data is refreshed automatically when the view opens.

NOTE. Refreshing data of the saved view is available only in the desktop application.

NOTE. It is available only in the desktop application.

View recreation is used to refresh metadata view on the database server.

To recreate a view, select the Recreate View item in the view's context menu.

NOTE. It is available only in the desktop application.

If the repository is connected to version control system, the view can be added to the system to control changes in its version. To do this, select the Add to VCS context menu item for view in the object navigator. After adding the object to VCS server one can track its changes. Version control system stores view text and parameter settings. For details about working with objects added to the version control system, see the Developing Applications in a Team section.