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

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

External Data Prompts

Started by CognoSimplify, 10 Aug 2020 07:47:57 AM

Previous topic - Next topic

CognoSimplify

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

erikc