IBM Support

Planning Analytics For Excel: In Exploration Report, All Data Cells Appear As <#1234#>

Troubleshooting


Problem

In Planning Analytics For Excel, within an Exploration report,  all cells contain the entry <#1234#>

Symptom

n/a

Environment

Exploration Report only

Resolving The Problem

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

[{"Type":"MASTER","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":"a8m50000000KzLFAA0","label":"Planning Analytics for Microsoft Excel-\u003EModelling"}],"ARM Case Number":"TS003986594","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]

Document Information

Modified date:
21 December 2021

UID

ibm16529598