IBM Support

PI17769: DYNAMIC CUBES - CROSSJOINS IN VIRTUAL CUBES NOT HANDLED EFFICIENTLY WHEN SUPPRESSING NULLS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When a crossjoin is implemented to create a Virtual Cube with
    null suppression on the source cubes, the SQL generated doesn't
    suppress nulls until all of the relevant data has been processed
    from both source cubes.  This is very inefficient.  Nulls should
    be suppressed on the source cubes before bringing the data back
    to be crossjoined.??
    

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

    PI17769

  • Reported component name

    COG CUBE DESIGN

  • Reported component ID

    5724W12CD

  • Reported release

    A21

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2014-05-12

  • 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 CUBE DESIGN

  • Fixed component ID

    5724W12CD

Applicable component levels

  • RA21 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCHNWP","label":"Cube Designer v11x"},"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