Working in IBM Cognos Cloud

Below are few observations from day to day working on IBM Cloud Environment.

Features:
  • IBM using saml namespace to provide single sign on for users. It is done using script in back end.
  • Cognos is using Apache Mode gateway for connections
  • Cognos Framework Manager settings uses additional encryption settings to make connection secure
  • Users are required to be added in Roles for both saml namespace as well as AD group ( in case they want to continue to use AD group). This means My folder of both ids are separate.
  • Report performances are faster on Production environment and caching helps.
  • Session parameter for user account includes complete email id instead of user name and hence scripts/functionality related to it needs to be changed.
  • With Encrypted security enabled and Soft Token usage, Cognos can be accessed like any other website to consume data instead of going via remote logon to system. 
  • Have Common deployment folder across environments

Issues/Work around:
  • Old FM models when trying to publish may face issue while publishing package for name conflict. To avoid this error, create new project and import all contents to it and reverify model.
  • Date drill through was seen an issue. If possible, convert them in character for passing to detail reports

Here are few issues we faced as of now being actively resolved:
  • Running report within Report Studio crashing VM Environment
  • DashDB connection creating multiple data sources connections while importing tables.
  • Running Drill Through reports when copying using clipboard have issue in making connection. This is caused by issue of passing timestamp to detail report.
  • Some reports not showing package in report properties but running fine. They don't show up in impact analysis done using FM for Query Subject dependencies.
  • Audit Log showing Timestamp in CET instead of local time though Cognos connection shows correct Local time.
  • Cube and Relation reports combined reports doesn't work since it's in DQM Mode only
  • There are data socket errors when reading large data. 




Popular posts from this blog

Cognos Excel Text Wrapping Issue - Row Merge and Column Merge

Below are the properties to set to keep column size and width with text wrapping: Column Merge issue  http://www-01.ibm.com/support/docview.wss?uid=swg21674298 Set the advanced server property RSVP.EXCEL.XLS2007_COLUMN_WIDTH_CONTROL to TRUE for both BatchReportService and ReportService services.        Row Merge issue http://www-01.ibm.com/support/docview.wss?uid=swg21440556 RSVP.EXCEL.XLS2007_ALLOW_WRAPPING_SINGLE_CELL also to be set to TRUE  for both BatchReportService and ReportService services.   Once done, you can set any column width to be fixed and see same result in Excel as well as HTML. Please note that above properties will not be honored if you have unchecked Grouping repeating cells Report property in Report Properties menu. 
Read more

Cognos: How to replace an existing report without breaking links?

Below IBM document explains behavior of copy/move or overwriting impact of objects:- https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.wig_cr.doc/c_gtstd_copy_move_items.html If you copy and overwrite an existing report, the copied report ID and links replace those of the existing report. In this case, you might need to update links, such as links to job schedules. If you move and overwrite an existing report, the existing report ID and links are maintained. In this case, references to the moved entry are broken. However, this doesn't work in all cases and we see drill through links broken in some cases. Best approach in such case is to use cognos deploy method where you update reports in separate folder in same environment and import it to destination location. You can create single export and import tasks to use for all such updates.
Read more

How to change package for a report in IBM Cognos Analytics (ICA)?

In Cognos 10.x and 8.x , this was the simple to handle on Cognos Connection or via Repot Studio interface.  In Cognos 11.0.6, You  need to load classic view (Cognos Connection) to go back to this interface to change the package. In Cognos Cloud environment, we have single environment for Development and UAT. In such cases, when we move content from Dev folder to UAT area, we need to switch to classic mode to change the package.
Read more