IBM Support

Error when using an Action Button to navigate to a worksheet whose name includes GB 18030 characters

Troubleshooting


Problem

In Planning Analytics for Microsoft Excel and TM1 Web, clicking an Action Button to open another worksheet results in a worksheet that contains no data.

Cause

The problem occurs when both of the following conditions are true:

  • an Action Button is configured to open a target worksheet whose name includes GB 18030 characters
  • the target worksheet contains a dynamic report

Resolving The Problem

To resolve this issue, rename the target worksheet using non-GB 18030 characters, then modify the Action Button properties to open the renamed worksheet.

[{"Product":{"code":"SSD29G","label":"IBM Planning Analytics"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Planning Analytics","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"2.0.2;2.0.1;2.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg22004597