Cognos Delivery
A Cognos report can be ‘delivered’ to the consumer in multiple formats and in multiple ways.
Method | Recommended Formats | Pro | Con |
|---|---|---|---|
Link to interactive in-portal report | HTML | -Follows UCSD Security best practices -Consumer can interact with prompts, creating their own filters -Data is refreshed nightly -Report can link to other reports or non-Cognos locations -Single location for all consumers -Consumer responsible for any data downloads | -May not be the format (email attachment) consumer is used to -Large reports may take longer to run than the consumer wants |
Link to saved in-portal report | PDF, Excel, Excel Data, CSV | -Follows UCSD Security best practices -Single location for all users -Data refreshed with each report run and save -Quick load time -Consumer responsible for any data downloads -Can be scheduled to run before consumer starts work | -May not be the format (email attachment) consumer is used to -Cannot save full history of every time the report is run |
Email link to report | HTML, PDF, Excel, Excel Data, CSV | -Can be used to notify consumer that report data has been updated -See all benefits of link to interactive in-portal report and link to saved in-portal report | -Email clutter if the consumer isn’t looking at the report every day |
Email attachment | HTML, PDF, Excel, Excel Data, CSV | -What the consumer is used to -Email address can be set up to save attachment to file location for external access | -Does NOT follow UCSD Security best practices -Report developer is responsible for data download and distribution of attachment -Email limit on size of attachment -Stagnant data |
Save report as external file | PDF, Excel, Excel Data, CSV | -Allows for file pick-up and movement to non-Cognos file storage location | -Does NOT follow UCSD Security best practices -Requires set up by ITS-BIA and ITS-AP -Saves to single location, available to all using this delivery method -Limited control over file name -File system must have third-party encryption -Not available in Cognos cloud |
Send report to mobile device | Not supported at UCSD |
|
|
Not supported at UCSD |
|
|