IBM Support

Subset runtime error when selecting a single member

Troubleshooting


Problem

In IBM Planning Analytics for Excel, a runtime error is thrown when a member is selected via the subset editor.

Symptom

Failed to replace all members.
CCL Runtime Error: Not a valid tuple

Cause

Design Mode is enabled in Planning Analytics for Excel

Resolving The Problem

To resolve the issue, disable Design Mode from the Planning Analytics menu in Planning Analytics for Excel

Document Location

Worldwide

[{"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"}],"ARM Case Number":"TS004795989","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"}]

Document Information

Modified date:
12 January 2021

UID

ibm16403459