Hello,
I am looking at automating a Cognos report for use in Excel. Currently, I can automate the majority of the report by having the end user select prompts within Excel and then having VBA amend the report URL to account for those filters. However, there is some data that needs to be imported into Cognos through external data, which I cannot seem to automate using VBA.
My question would be, is it at all possible to have external data be based on an address rather than a prompt? If the file is going to be in the same location for every user (i.e.: C:\DataFile.xlsx), can I just setup the report to just grab this file from the end user without prompting them to browse for it?
Thank you
You can set the prompt parameters in the report link. Maybe is this an option for your problem.
https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ca_gtstd.doc/c_wig_cr_create_custom_url.html