What is Ad Hoc?
Ad hoc analysis is a business intelligence process designed to answer a single, specific business question. The product of ad hoc analysis is typically a statistical model, analytic report, or other type of data summary.
Ad hoc reporting refers to reports that are put together creatively by users in real-time, rather than pre-designed according to a template.
An ad hoc report is a report that is created on the fly, displaying information in a table or a chart that is the result of a question that has not already been codified in a production report. There is a limit to the number of such production reports and business questions that can be anticipated and coded in advance so that users can consult them whenever they want.
Moreover, as businesses are always changing, the questions people want to ask of their data are always changing, so any reporting system needs to accommodate the creation and running of ad hoc reports. Making that an easy process for the average business user is key because most ad hoc reporting tools are designed for database experts to use, often requiring knowledge of structured query language, or SQL.
Videos for What is Adhoc Reporting
https://www.youtube.com/watch?v=GXk0Si83pxk