A query is a request to a database server to return data to your desktop. Each query is constructed of topic items selected from topics in a Data Model. Each item you include in your query retrieves data from the database server or servers when the query is processed.
For example, you might ask, "Show me January sales for the Northeast." Processing this query would yield all database records pertaining to January's transactions in the Northeast region. Perhaps you are most interested in sales figures for the State of Vermont. You could apply a filters to the query, and retrieve only the records specific to Vermont, or only those exceeding a certain dollar amount.
A single query can be constructed against a single Data Model in the same Interactive Reporting document file A single Interactive Reporting document file can also contain multiple query section, each query retrieving its data from a different database including: relational databases, local files, and OLAP servers.
Use the point and click feature to build complex queries such as: unions, intersections, minuses, subqueries and correlated subqueries.
You can build queries graphically, process them with a push of a button. The requested data is retrieved and displayed in tabular format in the Results section, ready for review, modification and analysis. You can make changes to the items in your query, and even sort or compute new data.