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

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 is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels