Report Studio

Queries specify what data appears in the report. In Report Studio, you create and modify queries using Query Explorer. Query Explorer provides an alternative way to modify existing reports or author new reports. You can use Query Explorer to perform complex tasks and other tasks that are more difficult to do in the report layout.

For example, use Query Explorer to:

• improve 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 where possible
  Note: By default, queries run sequentially.
• view or add filters and parameters, and modify their properties
• view or add dimensions, levels, and facts
• create complex queries using set operations and joins

Queries determine what data items appear in the report. Sometimes you want detailed rows of data, which you obtain by using a simple SELECT statement. Other times you must calculate totals or averages using summary functions and grouped columns or must apply filters to show only the data you want.

Related Topics:

• Working with Queries—Ways to work with queries.
• Adding Queries to a Report—How to add queries to your reports.
• Creating a Query Union—How to create a query union.
• Creating a Join Relationship—How to create a join in your report.

Copyright © 2018 Daptiv Solutions, LLC. All Rights Reserved