If you are unable to create a new account, please email support@bspsoftware.com

 

Javascript to capture the value ofdataitem and pass as parameter toother report

Started by cognoise2016, 14 May 2016 02:16:35 AM

Previous topic - Next topic

cognoise2016



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 open 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