Cognos 10.2.0 / 10.1.1 BI Crosstab Report shows double records for one of the Items from common dimension.

Technote (troubleshooting)


Problem(Abstract)

List report shows double rows for some of the Items which belongs to the spesific level in a hierarchy. Report contains Union Query and grouping.

Symptom

Extra rows were shown on month level Item - list showed multiple identical rows under month level grouping where other columns also had identical values.


Cause

Product issue. Stitching of queries failed to match records with 'NULL' values correctly and remove corresponding rows. Design change to product code was made for Cognos 10.2.1 (10.2 RP1) where stitch functionality was improved introducing "StitchWithNulls" -parameter (ref. APAR PM83742).

Environment

IBM Cognos 10.1.1 and 10.2.0

Diagnosing the problem

Happens using either Conventional Query Mode (CQM) or Dynamic Query Mode (DQM).

Resolving the problem

To enbale advanced parameter "StitchWithNulls", locate "CQEConfig.xml" file under "[Cognos Install]/configuration" directory on application server and add xml entry under the "QueryEngine" section:


<entry name="StitchWithNulls" value="1"/>

.


Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Cognos Business Intelligence
Cognos Connection

Software version:

10.1.1, 10.2, 10.2.1

Operating system(s):

Linux, Windows

Software edition:

All Editions

Reference #:

1641032

Modified date:

2013-06-17

Translate my page

Machine Translation

Content navigation