Hello, Thank you in advance for your help.
I have a package that contains large amounts of data. The data is fragmented into different 'connections' split by time period.
When I run a report on the package, after my prompts, Cognos prompts me to select a connection. I know that you can have a SQL query to pull from different packages, however i cannot find a way to specify pulling from two or more connections in the same package. Anyone have a trick for this?
Alternatively, if the above is not possible, When i repormpt my report i can enter new prompt data, but it will not reprompt the connection. Can I set the report to reprompt the connection and keep the prompt data that I had already selected.
Again thank you for your help