Cognos 10.2.2 Tips for Development Challenges

Below are some of tips on how Cognos 10.2.2 behaves to resolve issues quickly:-
  1. In Native SQL used in RS, it doesn't accept ";" as select terminator.
  2. When you copy main report and drill through report together and paste in same folder, drill through link starts using new links drill through report
  3. During deployment, if report is imported in different location and copied to target location, it can break report view links. This is changed behavior in Cognos 10 so best practice will be to keep source and target location same during export and import of deployment package.
  4. When we use Native SQL in RS, and in source query we apply aggregation functions, report can fail after migration. To circumvent this issue, use native sql based query as source query (without applying any aggregation). Other way is to push query to FM so it becomes virtual source query for further aggregations.
  5. When pulling a field in FM, if it is put as Fact, it can't be used for Chart x axis dimension. You need to convert it in identifier.
  6. If in a Cognos 10.2.1 report have starts with filter, make sure to test it in Cognos 10.2.2. Based on data, it may not like it and result in blank output without throwing any error.
  7. If Embedding query in FM doesn't work but works in database, change Type of SQL in Options to "Native" to make it work.
  8. While copying report from one folder to another, if you open new tab, copy item is lost and navogating to and fro takes time. You can ctrl click on Public Folder link to open new tab and this tab will share everything you copied in original tab.


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