Dynamic Report in PAX shows #NAME? instead of values
Technote (troubleshooting)
Problem(Abstract)
Dynamic Report in PAX shows #NAME? instead of values. Excel throws an error on the top stating Product Activation Failed
Cause
IBM Cognos Office Reporting TM1 (PAX) 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 (PAX) 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 (PAX) 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.
Document information
More support for:
IBM Planning Analytics Local
Planning Analytics v2.0 for Microsoft Excel
Software version: 2.0, 2.0.1, 2.0.2
Operating system(s): Windows
Reference #: 2004391
Modified date: 06 June 2017