IBM Support

PI57697: PI57697 MDX-QUERY DOESN'T WORK

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • Using a TI with Datasource ODBOMDXQUERY to copy values from a
    cube of a Source TM1-Server to a Target TM1-Server with the
    following MDX-Query, doesn't work (no dataset can be received):
    
    WITH
    SET [dimension1 Set] AS { [dimension1].[-] }
    SET [dimension2 Set] AS   {
    TM1FILTERBYLEVEL([dimension2].MEMBERS, 0)}
    SELECT NON EMPTY
    {  } ON COLUMNS,
    {  [dimension1 Set] * [dimension2 Set] } ON ROWS
    FROM [cube]
    

Local fix

Problem summary

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

Problem conclusion

  • Code Fix
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI57697

  • Reported component name

    TM1 SERVER

  • Reported component ID

    5724W49SE

  • Reported release

    A22

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-02-22

  • Closed date

    2016-07-26

  • Last modified date

    2016-07-26

  • 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 SERVER

  • Fixed component ID

    5724W49SE

Applicable component levels

  • RA22 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":"A22","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
21 September 2021