Adding URL-based reports
You can add customized reports that users can display in the Operations view.
Before you begin
Obtain the URL of the report that you want to add.
To obtain a URL for a Cognos® report,
do the following steps:
- To open the Cognos Connection console, in the Solution Administration view, click .
- In the Cognos Connection console, locate the report that you want to display.
- In the actions column for the report, click Set properties.
- On the General tab, click View the search path, ID and URL.
- Note the value of the Default Action URL.
- In the IBM® Intelligent Operations Center Solution Administration view, click , and copy the host name and the port number from the Value field.
- In the default action URL that you noted, replace the host name and the port number with the host name and the port number that you copied from the AnalyticServerDispatchUrl system property.
- Ensure that the edited default action URL uses the HTTPS protocol.
- To hide the Cognos header and toolbar in the report, append the following value to the URL: &cv.header=false&cv.toolbar=false
If you want to display Cognos reports in a high availability environment, you must complete the configuration that is described in the Configure the Cognos model in a high availability environment link.
Procedure
To add a customized report, edit the ReportViewConfig system property with the details.
Example
[{"id" : "report1", "name" : {"group":"Report","key":"reportname1"},
"url":"https://host:port/ServletGateway/servlet/Gateway?
b_action=cognosViewer&ui.action=run
&ui.object=%2fcontent%2fpackage%5b%40name%3d%27IOC%27%5d%2freport%5b%40name%3d%27ReportA%27%5d
&ui.name=ReportA&run.outputFormat=&run.prompt=true" },
{"id" : "report2", "name" : {"group":"Report","key":"reportname2"},
"url":"https://host:port/ServletGateway/servlet/Gateway?
b_action=cognosViewer&ui.action=run
&ui.object=%2fcontent%2fpackage%5b%40name%3d%27IOC%27%5d%2freport%5b%40name%3d%27ReportB%27%5d
&ui.name=ReportB&run.outputFormat=&run.prompt=true"}]
Where:- The value of id must be unique.
- The value of name is the translatable name
of the report. By changing their locale, users can view the report name in multiple languages. To insert a globalization value for the report name into the I18N_RESOURCE table in the IOC database, enter the following command. At a minimum, replace the values for KEY and VALUE:
Where:INSERT INTO IOC.I18N_RESOURCE ("GROUP", "LOCALE", "KEY", "VALUE") VALUES ('CustomReport', 'default', 'insert_key_here', 'insert_translatable_name_here');
- The value of LOCALE indicates the locale that the value is for.
- The value of KEY is a unique name for the translated string.
- The value of VALUE is the translated string for the report name.
- The value of url is the URL for the report.
- The value of pdfUrl is an optional URL value
for a PDF version of the report. Note: For Cognos reports, you can generate a PDF version of the report through the URL. In the value for url, replace run.outputFormat= with run.outputFormat=PDF.