Cognos TM1 Excel Add-in

To retrieve data or to upload data from/into Cognos TM1, there should be an interface between Cognos TM1 and Microsoft Excel.

Cognos has provided an Excel Add-in to achieve the above scenario which is "tm1p.xla".
Path where you can find the "tm1p.xla": C:\Program Files\Cognos\TM1\bin\tm1p.xla

To add the "tm1p.xla" Add-in in your excel provided you have already installed Cognos TM1 with perspectives.
Steps to add the Cognos TM1 "tm1p.xla" Excel Add-in:

1. Open Microsoft Excel
2. Go to Tools and Click on Add-ins
3. Click on IBM Cognos TM1 Perspectives check box and click OK button

If you are not able to see IBM Cognos TM1 Perspectives in Add-ins list, please follow the below steps:

1. Open Microsoft Excel
2. Go to Tools and Click on Add-ins
3. Click on Browse... button and traverse through the path where tm1p.xla add-in is located. I have already mentioned the path in the beginning of the post.
4. Select tm1p.xla and click OK to insert the Cognos TM1 perspectives/Excel Add-in into the Add-ins list.
5. If the check box for IBM Cognos TM1 Perspectives is selected, click OK button or check the checkbox and click OK.