IBM Support

Planning Analytics for Excel - Can't login with CAM authentication after PAW upgrade

Troubleshooting


Problem

After Planning Analytics Workspace (PAW) upgrade, users are not able to log in to PAfE with CAM authentication. They receive the following error:
"The PMHub service parameter was not specified or is not one of the configured locations"

Resolving The Problem

Re-create the "Office Connection" folder in C:\Users\<username>\AppData\Local\Cognos\Office Connection

  1. Close Excel
  2. Go to C:\Users\<username>\AppData\Local\Cognos\
  3. Rename the "Office Connection" folder to "Office Connection_OLD" folder
  4. Open Excel and setup connection to PAW as re-creating of the "Office Connection" folder deletes all existing entries

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"}]

Document Information

Modified date:
27 September 2023

UID

ibm17040611