Hi,
My requirement is as follows:
An excel file is stored in an online storage. We can access it via it's URL. That excel file contains simple data with just 2 columns and several rows. for example: country, states
That excel file has to be used as a input (prompt) to my report. Can that be done using java script?
Can't use External Data feature in cognos, as that file should accessible to the business users who would be updating the file regularly.
Thank you,
Hardik
See https://public.dhe.ibm.com/software/data/sw-library/cognos/mobile/scriptable_reports/ValuePromptControl.html
Good luck reading the Excel file using JavaScript. You may need to create a web service (C# ashx file? PHP file?) that does most of the work for you. Then your script can consume the result and populate the prompt control.
Can anyone help me with this please! :)
Hi,
You can load your Excel using Cognos Notebook to a data set.
After, in your report, use a custom control (Cognos samples has one called SetValuePrompt) to set your prompt default value.