Help on cognos javascript to pass parameter from one report to another dynamically

[sruthi2016]

Hi All,

I am working on cognos 10.2 .Please see below requirement on which i need inputs/advice from you. Requirement to create a template for adhoc reports that help user to analysis data.

I have 2 framework packages namely LEVEL1,LEVEL2,. LEVEL2 is detailed version of LEVEL1 with more dimensions . The requirement is to create template kind of 2 advanced work spaces EACH points to these packages receptively. Both templates need to blank initially.

-The user first opens the cognos work space advanced LEVEL1 blank report

- he can drag the attributes and metrics(DIMENSIONS AND FACTS) whatever he needs for his analysis

- run the report.

The data opens in cognos viewer .

Now when the user click on any of the column /field ,a cognos work space advanced that points to level 2 package should opens up.

For eg : if the user clicks on "country name " ( a column in cross tab in LEVEL1 advanced report) - country name(data value eg -USA ) should be passed as a parameter to LEVEL 2 blank report.

Now when the user drags dimensions/facts to LEVEl 2 report ,it should be sliced or filtered based on the parameter passed from LEVEL 1 report.- that means if the user drags product details and sales amount in LEVEL 2 report and run - it should only show the product details under country name USA.(passed from LEVEL 1)

What i have done so far :

Created advanced work space Level 1 report - added a HTML item with cognoslaunch function () defined to open LEVEL 2 cognos workspace onclick using button . (set input type as Button and onclick execute the cognoslaunch function())

i have defined the cognos launch function to pass parameter as well - and level 2 report is filtering accordingly

but this case only works for predefined set of dimensions and facts. in my case , iam not sure what the user is going to drag to the workspace and based on what dimension he wants to drill through to the level 2 report. so i need a javascript that will capture the data item whatever it is ,based on user click and pass it to level 2 report which will PRE FILTER THE REPORT DATA before literally dragging any of the fields to it. (in short it should be a pre filtered template on level 2 package)

I hope my requirement is clearly conveyed. Appreciate any advice on the same.

please help

Thanks

Sruthi