IBM Support

PI48950: MS SASS CUBE WITH MEASURE FORMATS OF "#,##0.00 %" OR "#,##0.00" GIVE ERRORS WHEN THE CONTENT LANGUAGE IS SET TO DUTCH

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Problem with using a Microsoft SQL Server Analysis Services
    (SSAS/MSAS) cube in Cognos Analysis Studio.
    The SSAS cube is created as a data source in Cognos using CQM
    and DQM.
    A package is created in Framework Manager which points to the
    SSAS cube.
    Analysis Studio is working correct with this cube, except if a
    measure is used which has decimals with the format "#,##0.00 %"
    or "#,##0.00".
    
    Analysis Studio produces the error:
    ANS-MES-0003 A server error occurred. Unable to complete the
    action.
    
    The cogserver.log file has the errors:
    RSV-SRV-0040 The report server encountered an internal error.
    The specified localized pattern is invalid. pattern string:
    "#,##0.00 %", position: 5.
    or
    The specified localized pattern is invalid. pattern string:
    "#,##0.00", position: 5.
    
    Note that this error only occurs if the Content Language of the
    Cognos user is set to Dutch in Cognos Connection. But, it does
    work if set to English.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See error description.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to IBM Cognos Business Intelligence 10.2.2 Fix Pack  *
    * 4                                                            *
    ****************************************************************
    

Problem conclusion

  • Code Fix
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI48950

  • Reported component name

    COG ANALYSIS ST

  • Reported component ID

    5724W12AS

  • Reported release

    A21

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-09-17

  • Closed date

    2015-12-17

  • Last modified date

    2015-12-17

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

    PI48658

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

Fix information

  • Fixed component name

    COG ANALYSIS ST

  • Fixed component ID

    5724W12AS

Applicable component levels

  • RA22 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A21","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
06 March 2023