Troubleshooting
Problem
Set Editor is blank in Planning Analytics for Excel
Resolving The Problem
-In Excel ribbon, select the "IBM Planning Analytics" tab.
-Click "Options"
-Click "IBM" from the left panel
-From the list of "IBM Connections", select the connection of your choice and click "Edit" button
-In the "Connection URL" field, verify the URL uses an FQDN server syntax (<servername>.<domain>)
-Click OK
-Reconnect to PAW
-Reconnect to the TM1 Server
-Right-click some dimension and select Edit Set: now the Set Editor dialog is correctly displayed.
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":"SSCTEW","label":"IBM Planning Analytics Local"},"ARM Category":[{"code":"a8m50000000KzJ4AAK","label":"Planning Analytics-\u003EPlanning Analytics For Microsoft Excel"}],"ARM Case Number":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
14 November 2022
UID
ibm16839107