ad hoc query
ประเภท
Ad hoc analysis may be used to create a report that does not already exist, or drill deeper into a static report to get details about accounts, transactions, or records. The process may be also used to get more current data for the existing areas covered by a static report.
OLAP dashboards are specifically designed to facilitate ad hoc analysis by providing quick, easy access to data from the original report. Allowing the user (typically a manager or executive) access to data through a point-and-click interface eliminates the need to request data and analysis from another group within the company. This capacity allows for quicker response times when a business question comes up, which in turn should help the user respond to issues and make business decisions faster.
Although most ad hoc reports and analyses are meant to be run only once, in practice they often end up being reused and run on a regular basis. This relatively common practice can lead to unnecessary reporting processes that impact high-volume reporting periods. Reports should be reviewed periodically for efficiencies to determine whether they continue to serve a useful business purpose.