Cognos Analytics

Hi Moises,

the Cognos Mashup Sevice (CMS) sounds like what you are looking for (In fact, the early internal working name for CMS was "RaaS - reports as a service". 😎). CMS is built into CA, so it's ready to be used (there are samples available as well).  CMS provides both a REST interface and a SOAP (doc/lit) interface to consume a Cognos report as a web service. CMS also allows you to choose the output format used in the response, to match your needs (for your usecase, you probably want to look at the DataSet, DataSetJSON, or the JSON output formats).

Here's a link to the documentation on Cognos Mashup Service: https://www.ibm.com/docs/en/cognos-analytics/11.0.0?topic=guide-overview-mashup-service 

The above documentation will show you the options on how to authenticate (including the CMS auth service option), how to send a request to the report web service, for the respective report (and specify the desired output format), and more advanced use cases (such as dealing with prompts and how to work with saved report output versions in the CMS API).

jim

------------------------------
Jim Boland
LinkedIn: https://www.linkedin.com/in/jimboland

Original Message:
Sent: Tue November 29, 2022 11:14 AM
From: moises suarez
Subject: RaaS - report as a service

#CognosAnalyticswithWatson

Hi , 

I cant find the cms c# samples which was suppose to be there in installation_location/sdk/cms_samples/csharp/ path as mentioned in the documentation https://www.ibm.com/docs/en/cognos-analytics/11.2.0?topic=dmsausi-logging-logging-off 

can somebody provide the correct path or else any sample cms C# sample code as im getting null report content using the getReportData command.

I have tried the below code to get the ReportData using ReportDataService object (C# application). after successfull authentication accessed by adding  generic service WSDL file(http://webservername:portnumber/ibmcognos/bi/v1/disp/rds/wsdl)

            ReportDataService svc = new ReportDataService();
            svc.biBusHeaderValue = new Generic.biBusHeader();
            svc.biBusHeaderValue.Any = authService.biBusHeaderValue.Any;
            svc.Url = url;
            GetReportDataRequest request = new GetReportDataRequest();
            request.sourceID = StoreID;
            request.sourceType = SourceTypeEnum.report;
            request.format = "JSON";
            GetOutputResponse outputResponse = new GetOutputResponse();
            outputResponse = svc.getReportData(request);
            outputResponse.output.ToString();

------------------------------
Anitha Royal

Original Message:
Sent: Wed November 30, 2022 06:53 AM
From: Jim Boland
Subject: RaaS - report as a service

Hi Moises,

the Cognos Mashup Sevice (CMS) sounds like what you are looking for (In fact, the early internal working name for CMS was "RaaS - reports as a service". 😎). CMS is built into CA, so it's ready to be used (there are samples available as well).  CMS provides both a REST interface and a SOAP (doc/lit) interface to consume a Cognos report as a web service. CMS also allows you to choose the output format used in the response, to match your needs (for your usecase, you probably want to look at the DataSet, DataSetJSON, or the JSON output formats).

Here's a link to the documentation on Cognos Mashup Service: https://www.ibm.com/docs/en/cognos-analytics/11.0.0?topic=guide-overview-mashup-service 

The above documentation will show you the options on how to authenticate (including the CMS auth service option), how to send a request to the report web service, for the respective report (and specify the desired output format), and more advanced use cases (such as dealing with prompts and how to work with saved report output versions in the CMS API).

jim

------------------------------
Jim Boland
LinkedIn: https://www.linkedin.com/in/jimboland

Original Message:
Sent: Tue November 29, 2022 11:14 AM
From: moises suarez
Subject: RaaS - report as a service

#CognosAnalyticswithWatson

Hi Moises,

the Cognos Mashup Sevice (CMS) sounds like what you are looking for (In fact, the early internal working name for CMS was "RaaS - reports as a service". 😎). CMS is built into CA, so it's ready to be used (there are samples available as well).  CMS provides both a REST interface and a SOAP (doc/lit) interface to consume a Cognos report as a web service. CMS also allows you to choose the output format used in the response, to match your needs (for your usecase, you probably want to look at the DataSet, DataSetJSON, or the JSON output formats).

Here's a link to the documentation on Cognos Mashup Service: https://www.ibm.com/docs/en/cognos-analytics/11.0.0?topic=guide-overview-mashup-service 

The above documentation will show you the options on how to authenticate (including the CMS auth service option), how to send a request to the report web service, for the respective report (and specify the desired output format), and more advanced use cases (such as dealing with prompts and how to work with saved report output versions in the CMS API).

jim

------------------------------
Jim Boland
LinkedIn: https://www.linkedin.com/in/jimboland

Original Message:
Sent: Tue November 29, 2022 11:14 AM
From: moises suarez
Subject: RaaS - report as a service

#CognosAnalyticswithWatson