Enable the add-in required to work with TM1 worksheet functions

To work with worksheet functions in IBM® Planning Analytics for Microsoft Excel, the TM1® add-in must be enabled. The add-in is enabled by default when you install IBM Planning Analytics for Microsoft Excel. If the add-in is disabled, however, you can enable it.

The IBM Cognos® Office Reporting TM1 add-in is installed in [installation_location]\IBM for Microsoft Office. The file name is CognosOfficeTM1.xll.

You can also follow along by watching this video: https://youtu.be/k8bgqwjK5Yw

TM1 worksheet functions return a numeric or string value. You can use TM1 worksheet functions in multiple ways. If you are using Planning Analytics for Microsoft Excel, you must first enable the IBM Cognos Office Reporting TM1 add-in. In this video, you’ll learn how to perform this task in IBM Planning Analytics for Microsoft Excel.

For information about enabling add-ins, see the Microsoft Excel Help.

Before you begin

If installed, disable the IBM TM1 Perspectives add-in. The IBM TM1 Perspectives add-in and the IBM Cognos Office Reporting TM1 add-in cannot be active at the same time.