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 »

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