BI Data Analytics

Below are the list of issues faced during upgrade to ICA 11.0.6. Got error when trying to rename report Navigate to the report and click the 'More' icon beside its name. From the menu, select 'Properties. From here there are two methods to change the report's name: a) Click on 'Advanced' to see more properties. b) Click 'Set...' beside 'Languages' Error : Firewall Security Rejection  2. When running multiple reports, get  error Data source adapter error: java.sql.SQLRecoverableException: No more data to read from socket and on clicking Ok, the screen doesn't go away. It needs to be closed and go to actual report 3. Save As option Save As Option takes to main Team Content Folder instead of folder where the report was residing. 4. List within List is causing caching issue and On report prompt page doesn't reflect changes to outputs. 5. On reports using multiple pages, page down causes Query Service Internal E...

Problem: When we try to right click on query to see Tabular data, there is pop up comes for requesting "Allow Clipboard Access". The option is already set  in Report Studio Property to allow access to clipboard. Solution: 1. Go to Tools -> Internet Options.  2. Go to Security tab.  3. Select “Internet” zone, then click on “Custom level…” button.  4. Scroll down to “Scripting” section (at the bottom few).  5. Under “Allow Programmatic clipboard access” option, check or select (tick) Enable. Default action for this option is Prompt, which cause the pop-up message whenever there is any attempt to access the Clipboard.  6. Click Ok twice to exit from Internet Options.

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. 

If anyone is using IBM Cognos Analytics Version 11.0.0.0 to 11.0.5.0, there is security bulletin released by IBM to notify vulnerability where sensitive information can be revealed in its logs files:- http://www-01.ibm.com/support/docview.wss?uid=swg22000095 The recommended solution is to apply version 11.0.6.0 as soon as viable.