Planning Analytics 2.0.98.7 returns a null instead of non-null value when an AGGREGATE function is used

Troubleshooting

Problem

Planning Analytics (PA) 2.0.98.7 returns a null value instead of a non-null value.

Example MDX.

WITH
    MEMBER
        [plan_department].[plan_department].[XQEext_CM0] AS '
        AGGREGATE(
            {{[plan_department].[plan_department].[105],
              [plan_department].[plan_department].[110]}})',
        SOLVE_ORDER = 1
SELECT
    {[plan_department].[plan_department].[XQEext_CM0]}
    DIMENSION PROPERTIES PARENT_LEVEL,
        PARENT_UNIQUE_NAME
    ON AXIS(0),
    {{[plan_time].[plan_time].[Jan-2004],
      [plan_time].[plan_time].[Feb-2004],
      [plan_time].[plan_time].[Mar-2004]}}
    DIMENSION PROPERTIES PARENT_LEVEL,
        PARENT_UNIQUE_NAME
    ON AXIS(1)
FROM
    [plan_Report]
WHERE
    ([plan_business_unit].[plan_business_unit].[10110],
        [plan_chart_of_accounts].[plan_chart_of_accounts].[41101],
        [plan_exchange_rates].[plan_exchange_rates].[local],
        [plan_report].[plan_report].[Variance])
    CELL PROPERTIES CELL_ORDINAL,  FORMAT_STRING,   TM1RULEDERIVED,    VALUE

Symptom

PA 2.0.98.7 returns a cell set with null values instead of non-null values.

{
"@odata.context": "../$metadata#Cellsets('YLBV5FkDAIBiAAAg')/Cells(Ordinal,Status,Value,FormatString,RuleDerived)",
"@odata.count": 3,
"value": [{
"Ordinal": 0,
"Status": "Null",
"Value": null,
"FormatString": "#,##0;(#,##0)",
"RuleDerived": false
}, {
"Ordinal": 1,
"Status": "Null",
"Value": null,
"FormatString": "#,##0;(#,##0)",
"RuleDerived": false
}, {
"Ordinal": 2,
"Status": "Null",
"Value": null,
"FormatString": "#,##0;(#,##0)",
"RuleDerived": false
}
]
}

The same MDX in PA 2.0.97.6 returns the values

{
"@odata.context": "../$metadata#Cellsets('nd4v41cDAIBiAAAg')/Cells(Ordinal,Status,Value,FormatString,RuleDerived)",
"@odata.count": 3,
"value": [{
"Ordinal": 0,
"Status": "Data",
"Value": -625648.780000000028,
"FormatString": "#,##0;(#,##0)",
"RuleDerived": false
}, {
"Ordinal": 1,
"Status": "Data",
"Value": -620238.189999999944,
"FormatString": "#,##0;(#,##0)",
"RuleDerived": false
}, {
"Ordinal": 2,
"Status": "Data",
"Value": -629969.630000000005,
"FormatString": "#,##0;(#,##0)",
"RuleDerived": false
}
]
}

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m0z000000TN4sAAG","label":"Installation and Configuration-\u003EDatabase"}],"ARM Case Number":"","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"All Versions"},{"Product":{"code":"SS6G84","label":"IBM Cognos Analytics on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Was this topic helpful?

Document Information

More support for:
IBM Cognos Analytics

Component:
Installation and Configuration->Database

Software version:
All Versions

Operating system(s):
AIX, Linux, Windows

Document number:
6462333

Modified date:
06 May 2025

UID

ibm16462333

IBM Support

Tips