Summary
The Query section is the Interactive Reporting interface for returning data on-demand from a database. The goal of this chapter was to provide the business analyst with the tools necessary to effectively build and manage queries from a data model. The chapter began with an overview of the layout of the Query section. The chapter continued with information for building a query and configuring Request items. The chapter examined and provided examples of the different filtering options including Show Values, Custom Values, Importing from a file, and Variable filters. The chapter addressed Query sorting as well as the different processing options for executing the Query sections in the document. Finally, the chapter closed with an overview of locating metadata in the document through viewing table and column remarks.