A query is a sampling of table data based on a specified SQL query. Queries as well as tables and views can be used as a data source for dimensions and cubes.
To create a query 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 pages of the query wizard:
Basic Settings/Basic Properties. It is used to set object name, identifier and comment
Parameters. List of parameters is created.
Properties. Specify query database, query text and advanced settings.
To save settings in the query wizard:
In the web application:
Click the Save button.
Select the Save and Close item in the drop-down menu of the Save button. After this the specified settings are saved, the wizard closes, and the data edit mode opens.
NOTE. The Save and Close item is available only on editing the settings.
In the desktop application click the Finish button.
See also: