Cognos Drill Through from Rave Chart to Intranet Page
Requirement: In IBM Cognos 10.2.2 summary Bubble Rave Chart is created to show distribution across regions. There is need to open Intranet Web page by passing document number directly. Please note that opening webpage in iframe is denied by security set up. Solution: Normal drill through functionality can pass data item value to another report and create URL. Using JavaScript, we can concatenate strings to form complete URL containing Document Number. At the same time, we can close drill through Report automatically so that the solution looks transparent to end users. Steps: 1. Create Drill through report with prompt value to pass from summary page. Create query to parse parameter. 2. Create Value prompt and add HTML item with below code. String for URL depends on destination URL structure. var form = getFormWarpRequest(); var dropDownL = form._oLstChoicespromptOper; dropDownL.remove(1); dropDownL.remove(0); var jsObj = dropDownL.options[0].value; document.write(