Query

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.

Creating a Query

To create a query in the object navigator:

After executing the operations determine settings on the pages of the query wizard:

Working with a Query

Edit a query

Browse data

Refresh

Design

Version control

See also:

Creating Table Data Sets | IQuery | Working with Data Set