Cognos Web Services: Direct Access to Report Results

Cognos Web Services (CWS) allows report authors to share a URL that provides direct access to report results. Traditionally, generating report results requires a user to log in to Cognos Connection, navigate through the UI to the desired report, and select prompts and run options each time new results are needed. Utilizing CWS for a report streamlines the user experience to using a URL and getting up-to-date results without the user knowing or accessing Cognos.

CWS URLs can be modified to perform several different tasks including:

  • specifying filters for a report
  • accessing previous versions of a report
  • changing the output data format
  • selecting a specific subsection of the report to display

Because every parameter required to get reporting results is contained within a single URL, it is easier to interface Cognos reports with other software options like Alteryx and Pentaho. Modifying a report for use with CWS is simple and many existing reports won’t require any modification.

Implementation Example:
A company needs to automate a verification process that compares the reports of two different data software packages. They decide to outsource this process to a contractor and would like to share to-the-minute report results without the contractor needing access to the Cognos environment. Using CWS, the contractor only needs the connection address and the relevant report IDs to filter and download data for the comparison.

URL Format:
http://webservername:portnumber/ibmcognos/cgi-bin/cognos.cgi/rds/resource_type/source_type/source_id?option1=val1&option2=val2…

  • webservername:portnumber: Local Cognos Connection Address
  • resource_type: Type of result desired, e.g. outputFormats, promptDescriptions
  • source_type: Specifies source such as path or report
  • source_id: Report-specific unique identifier

Once the source is specified, the user can alter the output with parameters like:

User credentials can be saved in-browser, specified for each URL, using a credentials prompt option.

Examples:
http://test.server/ibmcognos/cgi-bin/cognos.cgi/rds/outputFormat/report/i4FAD7993E84645DEA0B8C2C555E5E5EF/CSV&selection=UPlist&p_usage=sale

http://test.server/ibmcognos/cgi-bin/cognos.cgi/rds/outputFormat/report/i4FAD7993E84645DEA0B8C2C555E5E5EF/XML&p_product=res

For additional information, please contact us at marketing@capitalizeconsulting.com

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.

About the author

All Posts

ABBYY
Subscribe to our newsletter

Sign up for the very best tutorials and the latest news.

We care about your data in our privacy policy.

Related blog posts

Alteryx, Business Intelligence & Analytics, Customer Stories, Splunk, Tableau
Streamlining Internal HR Processes for Splunk
AlteryxCustomer StoriesHRHR metricsSplunkTableauworkforce analytics
Business Intelligence & Analytics, Press Releases
Capitalize Analytics Announces a New Partnership with DVW Analytics to Bring Easier Data Access to SAP Users
AlteryxAlteryx connectorDVW Analyticspress releaseprocess automationSAP
Business Intelligence & Analytics, UiPath
5 Tips for Automating Business Processes Using UiPath

Aliquet metus magna congue auctor

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Contact Us

Interested in learning more? Contact info@capitalizeconsulting.com.