Troubleshooting
Problem
Dynamic Report in PA for MS-Excel shows #NAME? instead of values.
Excel throws an error on the top stating Product Activation Failed
Symptom
Cause
IBM Cognos Office Reporting TM1 (PA for MS-Excel) add-in not registered in Excel.
Diagnosing The Problem
Check the List of Add-Ins for Excel
Resolving The Problem
1. Disable the IBM Cognos TM1 Perspectives add-in.
The IBM Cognos TM1 Perspectives add-in and the IBM Cognos Office Reporting TM1 (PA for MS-Excel) add-in cannot be active at the same time
2. Enable the add-in required to work with Cognos TM1 worksheet
The IBM Cognos Office Reporting TM1 (PA for MS-Excel) add-in is installed in[installation_location]\IBM for Microsoft Office
The file name is CognosOfficeTM1.xll
For information about enabling add-ins, see the Microsoft Excel Help.
[{"Product":{"code":"SSCTEW","label":"IBM Planning Analytics Local"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Planning Analytics v2.0 for Microsoft Excel","Platform":[{"code":"PF033","label":"Windows"}],"Version":"2.0.2;2.0.1;2.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
13 June 2019
UID
swg22004391