IBM Support

PM86626: SLICE TO EXCEL RESULTS IN "INVALID NUMBER OF ARGUMENTS" AND "*KEY_ERR"

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Slice to Excel can be performed successfully for a smaller
    number of dimensions, used in a view. However when more
    dimensions are used (e.g. 8 in rows, 4 in columns), the Slice to
    excel is not overall successful. Excel successfully opens but
    shows error 'Invalid number of arguments'. After that the slice
    is successfully shown in Excel, but DBRW formulas show
    "*KEY_ERR" or "#WERT" . This is due to the fact, that brackets
    are not correctly set in VIEW function.??The number of
    dimensions, with which this behavior can be reproduce, varies
    depending on the TM1 server.?
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See error description.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Please upgrade to IBM Cognos TM1 10.2                        *
    ****************************************************************
    

Problem conclusion

  • Code Fix
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM86626

  • Reported component name

    TM1 PERSPECTIVE

  • Reported component ID

    5724W49PE

  • Reported release

    952

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-04-09

  • Closed date

    2013-09-12

  • Last modified date

    2013-09-12

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

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

Fix information

  • Fixed component name

    TM1 PERSPECTIVE

  • Fixed component ID

    5724W49PE

Applicable component levels

  • RA20 PSN

       UP

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

Document Information

Modified date:
21 September 2021