PM24644: Model Advisor gives error if relationship uses item in a folder in a dimension table

APAR status

• Closed as program error.

Error description

• If a relationship in a model links to an item in a dimension
  table that is inside a folder and that is a uniquely identified
  derterminant, this error is generate when the Model Advisor is
  run:????The relationship <item name><--><item name> does not
  reference all the keys of any uniquely identified determinant in
  the query subject <query subject name>. The relationship has a
  0:1 or 1:1 cardinality, indicating that its keys should be an
  exact match to the keys of a uniquely identified determinant.
  Please review the cardinality of the relationship and the
  determinant information to determine if adjustments are
  required.????If the Query item is moved out of the folder, the
  error is not generated.  Likewise, if the item is made to not be
  a determinate, then there is no error when it is in the folder
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Business Intelligence 10.1 Refresh     *
  * Pack 1                                                       *
  ****************************************************************
  

Problem conclusion

• Code Fix
  

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

• Fixed component name

  COG BI FRAMEWK

• Fixed component ID

  5724W12FM

Applicable component levels

• RA11 PSN

     UP