Cognos Report Net to Cognos 8.x Migration- Common Issues

If you are a member of a Migration team where you have to migrate the Cognos Report Net reports to latest version of Cognos probably cognos 8.x. then you will come across various issues. Among them some important and common issues are given below along with the respective solutions.

Note: For convenience we have used CRN for Cognos Report Net and C8.4 for Cognos8.4



Issue 1:Sort order does not match with CRN (Cognos Report Net)
Soluton: There are some Grouped Key items, not sorted in CRN.
Please remove the sorting for those items in C8.4(Cognos 8.4)

It can be done at two places:
1. Dimension info
2. At the list level, Goto Grouping & Sorting and remove the required query item from the sort list. This needs to be done for each list in all the report pages.

Issue 2: Duplication of Data in the Summary Page
Description:
Instead of 1 row for each Data item, the data is getting duplicated in the C8.4

Solution:
In Page1 select the list which is producing the duplicate rows. Then go to the properties property of the list. Check only the items which are present in the layout.

Issue 3: While sorting the string variables, the C8.4 is case sensitive while the CRN is not case sensitive.
Solution: Suggested to have a query item UPPER (XXXX) and sort this, use the query item XXXX for displaying in the reports.

Issue 4: Decimal Precision between Cognos Report Net and Cognos 8.4 doesnot match.
Solution: Manually change the decimal Precision by selecting the option for formatting.

Issue 5: Footer Line width does not match with CRN in HTML alone
Description:
The width of the footer line does not match with CRN in the HTML version of the report

Solution:
1. Select Page from select ancestor icon.
2. Double Click Size & Overflow
3. Set Width to 100%

Issue 6: RQP-DEF-0244 Ambiguous item reference

While validating the report, it throws the following error:
QE-DEF-0459 CCLException
RQP-DEF-0149 The query specification is incorrect.
RQP-DEF-0244 Ambiguous item reference in the query

Solution:
Set the Override dimension info property to No.

Issue 7: Missing in Framework Error: QE-DEF-0359 The query contains a reference to at least one object that does not exist.
While validating the report, it throws the following error:
QE-DEF-0359 The query contains a reference to at least one object that does not exist.

Solution: The query item is missing in C8.4 Framework, while it is available in CRN1.1 Framework.So The framework of C8.4 should be refreshed and updated if required.

Issue 8: P-ERR-0144: Grouping on a property or property expression: ... is not supported
Error:
OP-ERR-0144 Grouping on a property or property expression: dataItem="",expression="Query Item" in valueSet="1" is not supported.

Solution:
Set the Override Dimension Info to No for the Query mapped to the chart.

Issue 9: The Data for the Cognos8.4 Chart page does not match with the data in the CRN chart page.
Solution: Go to the Properties at the Chart level (Pie Chart)
Under Chart label, Value Representaion ->Changed from Percent to Value

Issue 10: Chart axis label mismatch between CRN and C8.4
Description:
While running the report,
The Y-Axis label in the CRN chart page does not match with the Y-Axis Label in the C8.4 Chart page

Solution:
select Axis Title-->Properties-->Default Title-->Yes

Issue 11: The color of the Gridlines does not match with CRN
Solution:
select Y1 Axis-->Properties-->Gridlines-->Change color to Black

So, above are the most common Migration issues that are faced by the experts. If you still have any issues keep waiting for the next article on some more issues. Alternatively you can also subscribe to the feed or email address available and can also comment the issues or mail me for more complicated cognogs issues.

~Urs Krishan~