IBM Support

PI82092: XQE-PLN-0020 ERROR WITH FOUR LEVEL NESTED CROSSTAB

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as unreproducible.

Error description

  • The following error is generated with a nested crosstab with
    four levels against a TM1 or DMR using DQM when an attribute is
    used in the crosstab:
    
    XQE-PLN-0020   The V5 Query could not be planned by the Query
    Service. The 'V5ValueSet' node is invalid for the OLAP
    Transformation Library and the Query Service Planner is
    currently not able to resolve it.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to IBM Cognos Business Intelligence 10.2.2 Fix Pack  *
    * 9                                                            *
    ****************************************************************
    

Problem conclusion

  • Code Fix
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI82092

  • Reported component name

    COG WRKSPC ADV

  • Reported component ID

    5724W12BA

  • Reported release

    A22

  • Status

    CLOSED UR5

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-05-24

  • Closed date

    2017-09-19

  • Last modified date

    2017-09-19

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

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

    PI83557

Fix information

Applicable component levels

  • RA22 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.2","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
19 September 2017