Thursday, July 21, 2016

Passing Parameters to Cognos Report via URL

Currently Cognos is one of the leading reporting tools in the software Industry and calling a Cognos report with parameters can be tricky.

To initiate a cognos report directly via URL with parameters we need to follow below steps:

1. Click on more options:


2. Click on Set Properties

3. Click on View Search Path , ID and URL



4. Copy the Default Action URL :

It should look something like this :
https://theanalyticsworld.com/ibmcognos/cgi-bin/cognos_module?b_action=cognosViewer&ui.action=run&ui.object=%2fcontent%2ffolder%5b%40name%3d%27XYZ%27%5d%2ffolder%5b%40name%3d%27new%20Queries%27%5d%2ffolder%5b%40name%3d%27X%20-%20abc%20Query%20Folders%27%5d%2ffolder%5b%40name%3d%27Rohan%27%5d%2freport%5b%40name%3d%27current_report%27%5d&ui.name=current_report&run.outputFormat=&run.prompt=true


https://theanalyticsworld.com/ibmcognos/cgi-bin/cognos_module?b_action=cognosViewer&ui.action=run&ui.object=%2fcontent%2ffolder%5b%40name%3d%27XYZ%27%5d%2ffolder%5b%40name%3d%27new%20Queries%27%5d%2ffolder%5b%40name%3d%27X%20-%20abc%20Query%20Folders%27%5d%2ffolder%5b%40name%3d%27Rohan%27%5d%2freport%5b%40name%3d%27current_report%27%5d&ui.name=current_report&run.outputFormat=&run.prompt=false&p_PARAMETER_1=VALUE%201000&p_PARAMETER_2=VALUE%202000


Collaborators : Rohan Patil and Sathappan Ramanathan






No comments:

Post a Comment