IBM Support

IBM Planning Analytics for Excel throws an error when the dimensional structure has changed for a referenced element

Troubleshooting


Problem

An exploration report run in IBM Planning Analytics for Excel errors out because an element has been moved from one parent to another. The dimensional structure has changed.

Symptom

Error will be similar to:
An error has occurred when executing the MDX: "Account^17^273^375^76345": member not found. MDX contains reference to an invalid Member

Cause

There has been a change in the dimensional structure. For example, an element's parent has changed from Region A to Region B.

Resolving The Problem

To resolve the issue:
1) In IBM Planning Analytics for Excel, click on the Planning Analytics addon. In the Exploration section, click on MDX and manually edit the MDX code to reflect element structure change.
or
2) Enable a feature flag in the tm1features.json file that, when turned on, will automatically detect invalid metadata and attempt to resolve on an exploration refresh or edit mdx. The feature flag is "r50_EnableMDXCleanupUtility" : true.
To enable,
  1. Ensure that no Microsoft Office applications are open.
  2. Navigate to the C:\Users\<user profile>\AppData\Local\Cognos\Office Connection
  3. Open tm1features.json in a text editor. If the file does not exist, simply create a file with that same name
  4. Add {"r50_EnableMDXCleanupUtility" : true}
  5. Save the tm1features.json file.
Note: if you already have a feature enabled in the tm1features.json, separate features with a comma. For example,
            { "r41_EnableConstrainedCalcScope": true, "r50_EnableMDXCleanupUtility" : true}

Document Location

Worldwide

[{"Type":"SW","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCTEW","label":"IBM Planning Analytics Local"},"ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"},{"Type":"SW","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSD29G","label":"IBM Planning Analytics"},"ARM Category":[{"code":"a8m0z000000GoRcAAK","label":"Troubleshooting->Planning Analytics For Excel"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"}]

Document Information

Modified date:
21 September 2021

UID

ibm16446751

Page Feedback