PH17524: XQE-V5-0017 V5 SYNTAX ERROR USING EXPLORE > EXPAND MEMBER IN DIMENSIONAL REPORT

APAR status

• Closed as fixed if next.

Error description

• Report based on Dimensional Package run from Report Studio in
  HTML format is able to use the Explore > Expand Member without
  error.  When the same report is executed directly from Cognos
  Analytics folders the same functionality results in errors.
  
  Errors encountered:
  Failure	XQE-V5-0017 V5 syntax error found for data item
  'data_item_name' of query 'query_name', invalid token "," found
  after "hierarchize(union(".
  
  Failure	RSV-SRV-0003 The report specification contains an error
  at line ' 118', column ' 4,152'.
  Not enough elements to match content model :
  'All(setDefinition,dmDimension,dmHierarchy,setSorting,XMLAttribu
  tes,dataItemSharing)'
  
  XQE-GEN-0010 Found an internal error: 'Failed to resolve
  MFWNodeHandle from node key:
  [Package_name].[Dimension_name].[Hierarchy].[Property_name]'.
  

Local fix

• Workaround: Re-author the spec, don't use a low level data item
  and expect interactivity with the interactive viewer
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Analytics 11.2.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