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.
See also: