PM32716: SORT ORDER DOESN'T WORK ON NESTED CROSSTAB USING SLICER WITH A PROMPT PARAMETER AND SET

APAR status

• Closed with unknown close code.

Error description

• On a nested crosstab report, sort order doesn't work at the
  following conditions.  -- contains crosstab space component and
  -- contains a level filtered by 'Measure' using filter function
     ex) filter( [sample_support].[Product Name].[Product
  Name].[Product Name1], [Revenue]<>0 ) and -- exists the total of
  the measure for some members of this level becomes zero and --
  uses a slicer  If one of the conditions is missed, sort order
  works correctly.  This issue is related to PM32557. The
  difference is that a report in PM32557 doesn't use a prompt
  parameter and set function in a slicer. Therefore, PM32557 can
  use tuple function as workaround but this case can't use it.
  

Local fix

• use zero suppression in Report Studio instead of filter function
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Business Intelligence 10.2 Refresh     *
  * 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

Applicable component levels

• RA21 PSN

     UP