Drill-through is a great feature that Cognos TM1 supports. One of the most obvious uses for this functionality is to provide the ability to examine the transactional data that makes up a total. Although setting up a TM1 drill-through to capture and display underlying transactional data is straightforward, you as a developer should make every effort to optimize the performance of the drill. Areas to examine are SQL statement optimization, relational database indexing schemas, and even possibly restricting the maximum number of records that can be drilled to.
The following is a very simple example of restricting a drill-through by providing a minimum and maximum year range that is drillable. It checks the version selected in the drill-from cube for a year (all version names start with a YYYY
year) and the year value in a system control cube (Sys_TI_Variables
) and then does some math to determine if the year is within the predetermined range:
# Filter by date # Filter...