PM20686: CROSSTAB SHOWS WRONG DATA WHEN USED WITH STORED PROCEDURE AND SESSION PARAMETER

APAR status

• Closed as unreproducible.

Error description

• Report Studio Crosstab report (Query Studio Pivot Report) shows
  wrong data when stored procedure is used to link user session
  parameter to values that are retrieved from database.
  Crosstab report shows wrong data when stored procedure is used
  to link user session parameter to values that are retrieved from
  database. FM model has Sored Prcedure based Query Subject that
  uses user session parameter '#$account.personalInfo.userName#'
  to retrieve user spesific ID value from database. Based on ID
  (model relationships) relevant data is linked and shown to a
  user in a report.    This works well with list report, but
  crosstab shows incorrect data for IDs. Happens in Query Studio
  pivot report as well. Tested with 8.4.1 FP2 Win32 version
  against Oracle 10 but has reported to happen in AIX/Linux/Oracle
  11 also.     Workaround: not available for stored procedure,
  otherwise addd user session parameter based filter to Query
  Subject in a model
  

Local fix

• N/A with Stored procedures, add user session parameter based fil
  ter to Query Subject in a model
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Business Intelligence 10.2.1 Fix Pack  *
  * 1                                                            *
  ****************************************************************
  

Problem conclusion

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  COG8 BI QUERY S

• Fixed component ID

  5724W12QS

Applicable component levels

• RA21 PSN

     UP