How to use an Ad Hoc Topic with input controls for an Ad Hoc view

This short video will show you how to use an Ad Hoc Topic that can be created by following the instructions here.

It shows how to introduce a parameter in the Ad Hoc Topic and leverage it when creating an Ad Hoc View to select only the needed and meaningful data in order to limit the database response time and speed up the Ad Hoc View creation and execution. 

In this way, the data retrieved from the Database will be limited to the result set of the Ad Hoc Topic SQL query, and the management of the data loaded into memory will be less onerous and more efficient.

This is a more efficient alternative that will only require the values initially requested in the topic parameter, as an alternative to using filters created directly on an Ad Hoc View which will require loading the entire result set into memory.