Building Queries for Analysis

Data analysis in Interactive Reporting starts with the configuration of the query. Since Interactive Reporting provides the user with flexibility to perform manipulations on the data returned to the document, the user building the query must determine the level of detail, filtering, and manipulation to apply before the results are returned from the database. While this sounds trivial, there are reasons for building a simpler query and retrieving more data into the Results section than needed for analysis. When making decisions on building queries, query performance as well as data volume must be taken into account when designing the query. The best practice approach to determining the best query design is to find the most efficient balance between the data volume (taking into account the level of detail needed for ...