Interactive Reporting documents (BQYs) are files you create and use to retrieve information from a database, analyze the information, and build reports. Because Interactive Reporting is an integrated query, analysis, and reporting tool, Interactive Reporting documents have multiple sections, each of which governs one part of the query and reporting process. You create sections progressively: first you query a database, then retrieve results, and last generate reports.
Interactive Reporting documents can contain data from any number of relational databases queries, multidimensional database queries, and/or from imported data. Documents usually include one or more of the following items:
A data model, which is a visual representation of actual database tables
A query or multiple queries for retrieving a subset of data from the database
Join options, including local joins between different data sets within a single document, local join filters, and optional join path generation
Reports presenting customized hierarchical views of your data
Multidimensional pivot tables that permit drill-down analysis of data results
Charts that graphically display your query results and allow different angles of vision on the data.
All Interactive Reporting documents usually have at least one Query section and one Results section. From the Results section, you can create multiple Pivot, Chart, Table, and Report sections to analyze and present data. Developers can also create Dashboard sections, which provide an automated push-button interface to a document for use by other users across the enterprise.