PH14110: UNEXPECTED ERROR WHEN MIXING RELATIONAL AND DIMENSIONAL DATA ITEMS

APAR status

• Closed as fixed if next.

Error description

• When mixing relational and dimensional data items, ie. a
  Hierarchy filter in a relational query, the following error
  message is usually displayed:
  Expected error message: RSV-VAL-0010 Failed to load the report
  specification. XQE-PLN-0307 Reference to multiple
  cubes/namespaces in the same query is not supported.
  
  However when setting the filter to optional, error messages
  vary, based on the query design.
  Examples:
  RSV-VAL-0010 Failed to load the report specification.
  XQE-PLN-0004 Found an internal error on node 'V5DataItem'. The
  rollupAggregate setting 'automatic' is either unsupported or
  invalid.
  RSV-VAL-0010 Failed to load the report specification.
  XQE-PLN-0046 The keyword "distinct" is not supported for OLAP
  data sources. Data item name: 'rank'.
  
  The expected error message however is: RSV-VAL-0010 Failed to
  load the report specification. XQE-PLN-0307 Reference to
  multiple cubes/namespaces in the same query is not supported.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Analytics 11.2                         *
  ****************************************************************
  

Problem conclusion

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

Applicable component levels