The Ad Hoc Metrics feature provides a means to trend virtually any query, provided it fits within the constraints imposed by the table that the query results are written to, the agl_trending_adhoc table. The feature works by automatically executing queries in one XML file, the trending_custom_queries.xml file, that are enabled in another XML file, the TrendingSchedulerConfiguration.xml file. These queries can be executed on a daily, weekly, or monthly basis. The frequency can be set in the TrendingSchedulerConfiguration.xml file or in the RiskVision user interface by going to the Administration -> Scheduled Jobs page and scheduling the Trending Data Collection for Ad Hoc Views job to the desired interval. Before providing instructions for enabling existing queries and creating new ones, we will provide an overview of the files used to define the queries and control their execution, the trending_custom_queries.xml and TrendingSchedulerConfiguration.xml files.
