IBM Support

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