IBM Support

PI12227: A NESTED CROSSTAB REPORT WITH SORTING DEFINED ON THE MEASURE BASED ON A DATA ITEM CAUSES PERFORMANCE ISSUES

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • A nested crosstab report with sorting defined on the measure
based on a data item causes performance issues. If the sorting
is removed, the report runs speedily but with the sorting
itself, the report takes very long compared to the behavior in
Cognos 10.1.1

Local fix

  • 



Problem summary


    

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

    



Problem conclusion


    

  • Code Fix

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    PI12227
    • 

  • Reported component name
    COG WRKSPC ADV
    • 

  • Reported component ID
    5724W12BA
    • 

  • Reported release
    A21
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2014-02-20
    • 

  • Closed date
    2014-08-15
    • 

  • Last modified date
    2014-08-15
    • 





    

  • 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
    COG WRKSPC ADV
    • 

  • Fixed component ID
    5724W12BA
    • 



Applicable component levels


    

  • RA21  PSN
       UP
    • 








      
              
                            

              

              [{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SUNSET","label":"PRODUCT REMOVED"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.2.1","Edition":"","Line of Business":{"code":"","label":""}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            15 August 2014
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback