PH26585: EXPRESSION INCORRECT WHEN ADDED FROM METADATA TREE SEARCH

APAR status

• Closed as fixed if next.

Error description

• Using the package search in Reporting with a CQM package may 
  match results with a data item with the incorrect model path.  
  When added to a report the query will fail to run because the 
  data item cannot be found.
  
  Error: 
  QE-DEF-0030 Expression parsing error.
  QE-DEF-0359 The query contains a reference to at least one 
  object '[Sales (analysis)].[Products].[Products].
  [Product (Alias)].[Base product number]' that does not exist.
  
  DQM packages are not affected by this issue.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Analytics 11.2.4                       *
  *                                                              *
  * Steps:                                                       *
  * 1. In the install_location/configuration directory, make     *
  *    a copy of the CQEConfig.xml.sample file and rename it to  *
  *    CQEConfig.xml.                                            *
  * 2. Open the install_location/configuration/CQEConfig.xml     *
  *    file in an editor.                                        *
  * 3. Under the line <component name="CQE"> add the following   *
  *    entry:                                                    *
  *                                                              *
  * <section name="General Options">                             *
  *      <entry name="RestoreItemReferences" value="0"/>         *
  * </section>                                                   *
  *                                                              *
  * 4. Save the file.                                            *
  * 5. Restart Cognos Analytics.                                 *
  ****************************************************************
  

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