Submitted By Viral Raval and Amit Shivde
This document provides the technique of implementing drill up-drill down as well as drill through on a single object (chart/crosstab/list).
This solution has been created and tested in COGNOS 10.1. This is only applicable to dimensional models.
You need to add all the levels of the dimension to the Target report. In our case we have added the Year, Quarter and Month levels in our drill up-down as well as drill-through target report report.
Drill up-down as well as drill through on a single object:
It is a very generic requirement where in we need to have a drill up-down as well as drill through features enabled on a single object of a dashboard. In dimensional models this case is possible.
Two sample reports have been created using the Great Outdoors package. One sample report is for the drill through target and another sample report is for the drill through source. Source report is the one which has an object with drill up-down as well as drill-through features implemented.
It is a best practice to first create the drill-through target report and then to create the drill through source report. Download: