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.
To create view in the object navigator:
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.
After executing the operations determine settings on the view wizard pages:
Basic Settings/Basic Properties. It is used to set object name, identifier and comment
Parameters. A list of parameters is created. The page is available only in the desktop application.
Properties. Database, physical name, and query text to create the view are specified.
Indexes. Forms a list of indexes, which will be further used to check data uniqueness.
See also: