COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: rajurokz on 24 May 2017 01:28:59 PM

Title: Excel file as an Input to Prompt
Post by: rajurokz on 24 May 2017 01:28:59 PM
Hello All,

I have a requirement where in we need to pass an excel file containing Account_numbers captured by a set of users. These Account_numbers are present in the database as well.But different users across different regions  want to pass these item codes from the excel sheet to a value prompt in the report studio.Can this be done using Javascript ?? If so please help me with the script and how to acheive this..

Also, help me understand the limitations around this.

Thanks in Adv!
rajurokz
Title: Re: Excel file as an Input to Prompt
Post by: bdbits on 25 May 2017 04:51:08 PM
If these are going to be constant for each group over time, I would advise creating filters for each set in your model. Then they can just drag/drop in Cognos, no Excel or javascript needed.