PI05166: QE-DEF-0359 THE QUERY CONTAINS A REFERENCE TO AT LEAST ONE OBJECT THAT DOES NOT EXIST

APAR status

• Closed as fixed if next.

Error description

• A package is created from a TM1 cube which has a dimension
  containing an element attribute with Name = ID and Type = Alias.
  ?Attempting to create a report against this package results in
  the following error :??QE-DEF-0030 Expression parsing
  error.??QE-DEF-0359 The query contains a reference to at least
  one object?'[(ja)
  plan_BudgetPlan].[plan_business_unit].[plan_business_unit].[ID]'
  ?that
  does not exist.??The problem only occurs if the content language
  is not set to English and when importing the cube in Framework
  Manager, no language was specified for the ID alias. Also, the
  problem doesn't occur if the alias is called something other
  than ID.??The problem occurs in both Analysis Studio and Report
  Studio in the user interface when attempting to expand the
  dimension containing the attribute.
  

Local fix

• Either change the name of the element attribute in TM1 to someth
  ing other than ID or when importing the cube into Framework Mana
  ger, ensure that a locale is assigned to the ID alias.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Business Intelligence 10.2 Refresh     *
  * Pack 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

• RA22 PSN

     UP