PM82996: RELATIVE TIME CATEGORIES RESULTS IN XQE-V5-0011 SYNTAX ERROR

APAR status

• Closed as fixed if next.

Error description

• When publishing a dynamic cube, containing relative time
  categories, in german, the cube can be successfully published
  and started. However using the relative time categories in the
  studios results in an XQE-V5-0011 V5 syntax error.??Full error
  message from XQE log:?Caught error in V5QueryHandler:
  XQE-V5-0011 V5 syntax error found in expression
  "AGGREGATE(CURRENTMEMBER( [cubename].[Measures]) WITHIN SET
  PERIODSTODATE( [cubename].[TimeDimension].[TimeDimension].[Year]
  ,
  [cubename].[TimeDimension].[TimeDimension].[Month]->:[RO].[TimeD
  imension].[TimeDimension].[Alle].[YYYY].[YYYYQ].[YYYYMM]))",
  invalid token " " found after "AGGREGATE(CURRENTMEMBER(
  [cubename].[Measures]) WITHIN SET PERIODSTODATE(
  [cubename].[TimeDimension].[TimeDimension].[Year] ,".?
  

Local fix

• Start Cube Designer in english, instead of german.
  http://www-01.ibm.com/support/docview.wss?rs=3528&uid=swg2161611
  1
  

Problem summary

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

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

• RA21 PSN

     UP