Working with relational queries

The Queries view provides an alternative way to modify existing reports or to author new reports. In this view, you can perform complex tasks that are difficult to do in the report layout. For example, use this view for the following tasks:

• Improve report performance by changing the order in which items are queried from the database, or by changing query properties to allow the report server to execute queries concurrently when possible.
  Note: Only queries that are referenced in the report layout can be executed concurrently. If a query is defined in the Queries view by joining two or more existing queries, the source queries cannot be executed concurrently. By default, queries run sequentially. Your administrator must enable the concurrent query execution feature. For more information, see Concurrent query execution.
• View or add filters and parameters, and modify their properties.
• View or add dimensions, levels, and facts.
• Incorporate SQL statements from other reports or reports that you create.
• Create complex queries by using set operations and joins.