Troubleshooting
Problem
PROBLEM
Working within an Exploration Report of Planning Analytics For Excel, the following error occurs when editing a dimension subset
Working within an Exploration Report of Planning Analytics For Excel, the following error occurs when editing a dimension subset
When the error occurs, one no longer can work within the subset editor and must close the editor.
Symptom
Error
The current set is not loaded successfully
{"errorMessage".{"error {"code"."EXECUTION_ERROR","message":null}},"query":"/harmony/gridservice/api/v1/CreateHierarchyQuery","httpStatusCode":500}
OK
Cause
Design Mode is enabled within Planning Analytics for Excel on the user's machine.
Diagnosing The Problem
The error is machine specific as other users will not encounter this error performing the same actions if design mode is disabled.
Resolving The Problem
STEPS:
Disable Design Mode
1. Open an Exploration report and select IBM Planning Analytics tab (from top menu)
2. Below the option MDX, Design Mode appears Bold (enabled)
3. Uncheck to disable
4. Test again
Document Location
Worldwide
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCTEW","label":"IBM Planning Analytics Local"},"Component":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
21 September 2021
UID
ibm11169128