Connect to TM1 server using VBA

Post Reply
Manojav
Posts: 1
Joined: Fri Jun 28, 2019 3:32 pm
OLAP Product: IBM Cognos TM1 perspectives
Version: 10.2.2
Excel Version: Excel 2013

Connect to TM1 server using VBA

Post by Manojav » Mon Jul 01, 2019 2:36 pm

Hi guys,

I need to connect to TM1 server using VBA. I tried using "N_Connect" and it is failed with the error "Login Failed: SystemServerCAMSecurityRequired"

I have some TM1 functions and expressions in the worksheet which will get executed and populate the data once connected. I need to achieve this by making a connection to TM1 server using VBA. Once the data is populated, need to disconnect as well.

I am very new to this and any help is appreciated :) :)

Thank you !!

Thanks & Regards,
Manoj

Post Reply