IBM Support

PM97755: AFTER APPLYING 10.2.1 FP1, CUBE DESIGNER THROWS AN ERROR FOR A S ECURITY FILTER BASED ON A LEVEL WITH MULTIPLE NON-KEY ATTRIBUTES

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • A Cube Designer model is created which includes a lookup table
    security filter.  The level which is filtered has 1 column
    marked as the Unique Level Key and several attributes are not.
    The key is mapped to the corresponding column in the security
    table.  This works fine in 10.2.1 GA, but if the same design is
    opened or created in 10.2.1 Fix Pack 1 the cube will fail to
    publish and the following error is thrown when validating the
    hierarchy:????The security filter FilterName in the hierarchy
    HierarchyName in the dimension DimName has a filter item on the
    level LevelName but not all of the level unique key attributes
    of the level have filter items. The level LevelName has more
    than one attribute as its level unique key. You need to set
    filter items for all of attributes of the level unique key.
    

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  *
    * 2                                                            *
    ****************************************************************
    

Problem conclusion

  • Code Fix
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM97755

  • 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

    2013-09-24

  • Closed date

    2014-01-31

  • Last modified date

    2014-01-31

  • 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:
31 January 2014