IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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

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 number

    PM82996

  • Reported component name

    COG CUBE DESIGN

  • Reported component ID

    5724W12CD

  • Reported release

    A20

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2013-02-18

  • Closed date

    2013-06-11

  • Last modified date

    2013-06-11

  • 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

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCHNWP","label":"Cube Designer v11x"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.2","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
11 June 2013