Custom SQL drill through

Custom drill through can be set up by Infor professional consultants or CPM administrators familiar with creating SQL queries. It requires detailed knowledge of the financial information that ties into the data loaded into the CPM model.

Drill through shows the results of a custom query related to the summary value stored in CPM. To use drill through, select the cell you want to investigate and click Custom Drill Through. The Custom Drill report displays the results of the custom query. The report contains hyperlinks if there is a second level of drill through. Clicking a linked value displays further detail from a secondary query, URL, or report view depending on what the administrator defined.