Introduction to Cognos Mashup Services

Why Cognos Mashup Services?

There are several alternatives when it comes to accessing a cognos report from an external application, but when we just need to execute a cognos report and get the result quickly without bothering about advanced cognos features, then CMS is our best choice.

The objective of CMS is narrowly focussed on running the report and getting the output by passing the input parameters required by the report logics.

How to use CMS

REST interface could be used to extract specific part of a cognos report

A Typical CMS URL for a REST request would look like:

Application + report path + report name + CMS specific attributes + input parameters.

Example:

Choosing a Global Software Development Partner to Accelerate Your Digital Strategy

To be successful and outpace the competition, you need a software development partner that excels in exactly the type of digital projects you are now faced with accelerating, and in the most cost effective and optimized way possible.

Get the Guide

http://servername:port/cognos8/cgi-bin/cognos.cgi/rds/report _path/report_name?selection=SalesList&fmt=JSON?Date=’01-01-2016’&Product=Lantern

Where ‘selection’ refers to a specific cognos object to be extracted from the report, and ‘fmt’ is the attribute which defines response format, and remaining input parameters defined in the cognos report.

Let’s consider the below table as SalesList:

The CMS response in JSON would look this:

[{“Date”:”01-01-2016″,”Product”:”Lantern”,”Sales”:2500}]

Multi select request:

To perform multi select, we need to reiterate the input parameter with multiple values:

Example:

http://servername:port/cognos8/cgi-bin/cognos.cgi/rds/report _path/report_name?selection=SalesList&fmt=JSON?Date=’01-01-2016’&Product=Lantern&Product=Tents

Response:

[{“Date”:”01-01-2016″,”Product”:”Lantern”,”Sales”:2500},

{“Date”:”01-01-2016″,”Product”:”Tents”,”Sales”:6000}]