An ad hoc report is a report that is created on demand for unanticipated business questions. In contrast to a production report that is pre-designed for known business questions, ad hoc report requirements exhibit noticeably different characteristics:
Ad Hoc Report | Production Report | |
Report Creators | Self-service business users | IT oriented developers/analysts |
Data Preparedness | No ready support | Well prepared. May even be supported by a data warehouse |
Output Requirement | From paginated to visual analytic reports | Paginated reports |
Ad hoc reports are often also used to meet analytic requirements. In these scenarios, the business question is not only unanticipated but also not well defined. For example, a sales manager may try to find the root cause of the sudden popularity of a particular product. For analysis oriented ad hoc reports, the key requirements are the ability to:
Ad hoc reports are usually created for a single use. However, valuable ad hoc reports often turn into useful long-term assets. The sales manager may want to schedule the report or to repeat the analysis on an on-going basis. It also may become worthy of sharing with other users.
SAFE(simple, adaptable, flexible and endurable) are four defining properties of a robust ad hoc reporting solution:
#1 Ranking: Read how InetSoft was rated #1 for user adoption in G2's user survey-based index | Read More |