IBM Support

PH08190: XQE-V5-0011 V5 SYNTAX ERROR WHEN CREATING DATA GROUP USING THE UI WHILE THE CONTENT LANGUAGE IS SET TO DANISH

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as fixed if next.

Error description

  • XQE-V5-0011 V5 syntax error when creating data group using the
    UI while the content language is set to Danish in CA11.1.1
    
    Reproduction steps:
    
    Set Content Language to Danish
    
    1. New > Data module
    2. Select Source: Samples > Data > Source files >
    Customer_analysis.csv
    3. double click on Customer ..sis Csv table or drag it to the
    work area (you must see the entire table in the work area)
    4. Right click on the "State" Column > "Create Data Group"
    5. Column name: State group TEST
    6. "+ New group" > Name it "TEST" > Select "Arizona" and
    "California" and drag to "Group items" (click on arrow)
    7. "+ New group" > Name it "ANOTHER TEST" > Select "Nevada" and
    drag to "Group items" (click on arrow)
    8. Check "Group remaining and future items in... Name it "REST"
    > OK
    
    This will produce a screen with "You can't preview this data"
    This is the error when you view details:
    
    XQE-V5-0011 V5 syntax error found in expression "CASE WHEN
    (State_ IN ('Arizona', 'California')) THEN ('TEST') WHEN (State_
    IN ('Nevada')) THEN ('ANOTHER TEST') ELSE ('REST') END", invalid
    token " " found after "CASE WHEN (State_ IN ('Arizona',".
    
    You can eliminate the error by:
    
    1. Go to the new Data item "State group TEST" and right click >
    Properties
    2. Edit calculation > Replace the comma in ('Arizona',
    'California') to semicolon ('Arizona'; 'California')> OK
    3. Now the new column will appear properly
    
    Such problem should not happen as the client is creating the
    data group using the shipped user interface.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Users                                                    *
    *                                                              *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    *                                                              *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to IBM Cognos Analytics 11.1.2                       *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PH08190

  • Reported component name

    COGNOS ANALYTIC

  • Reported component ID

    5724W12XX

  • Reported release

    B07

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-02-05

  • Closed date

    2019-06-04

  • Last modified date

    2019-06-04

  • 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



Document information

More support for: Cognos Analytics

Software version: B07

Reference #: PH08190

Modified date: 04 June 2019